44
44
<script type="text/javascript" src="../_static/doctools.js"></script>
45
45
<!-- end iterate through sphinx environment script_files -->
47
<script type="text/javascript" src="../_static/detectmobile.js"></script>
47
48
<script type="text/javascript" src="../_static/init.js"></script>
48
49
<link rel="index" title="Index" href="../genindex.html" />
49
50
<link rel="search" title="Search" href="../search.html" />
72
74
<div id="docs-container">
80
<div id="docs-top-navigation-container" class="body-background">
77
81
<div id="docs-header">
82
<div id="docs-version-header">
83
Release: <span class="version-num">0.9.6</span> | Release Date: June 23, 2014
78
86
<h1>SQLAlchemy 0.9 Documentation</h1>
80
<div id="docs-search">
82
<form class="search" action="../search.html" method="get">
83
<input type="text" name="q" size="18" /> <input type="submit" value="Search" />
84
<input type="hidden" name="check_keywords" value="yes" />
85
<input type="hidden" name="area" value="default" />
89
<div id="docs-version-header">
90
Release: <span class="version-num">0.9.4</span> | Release Date: March 28, 2014
97
<div id="docs-top-navigation">
98
<div id="docs-top-page-control" class="docs-navigation-links">
91
<div id="docs-body-container">
93
<div id="fixed-sidebar" class="withsidebar">
96
<div id="docs-sidebar-popout">
97
<h3><a href="../index.html">SQLAlchemy 0.9 Documentation</a></h3>
99
<p id="sidebar-paginate">
100
<a href="index.html" title="Changes and Migration">Up</a> |
102
<a href="changelog_01.html" title="0.1 Changelog">Prev</a> |
103
<a href="migration_07.html" title="What’s New in SQLAlchemy 0.7?">Next</a>
106
<p id="sidebar-topnav">
107
<a href="../index.html">Contents</a> |
108
<a href="../genindex.html">Index</a>
111
<div id="sidebar-search">
112
<form class="search" action="../search.html" method="get">
113
<input type="text" name="q" size="12" /> <input type="submit" value="Search" />
114
<input type="hidden" name="check_keywords" value="yes" />
115
<input type="hidden" name="area" value="default" />
121
<div id="docs-sidebar">
124
What’s New in SQLAlchemy 0.8?
101
<a href="changelog_01.html" title="previous chapter">0.1 Changelog</a>
104
<a href="migration_07.html" title="next chapter">What’s New in SQLAlchemy 0.7?</a>
108
<a href="../contents.html">Table of Contents</a> |
109
<a href="../genindex.html">Index</a>
110
| <a href="../_sources/changelog/migration_08.txt">view source
115
<div id="docs-navigation-banner">
116
<a href="../index.html">SQLAlchemy 0.9 Documentation</a>
117
» <a href="index.html" title="Changes and Migration">Changes and Migration</a>
119
What’s New in SQLAlchemy 0.8?
124
What’s New in SQLAlchemy 0.8?
131
<div id="docs-body-container">
133
<div id="docs-sidebar">
134
<h3><a href="../index.html">Table of Contents</a></h3>
136
128
<li><a class="reference internal" href="#">What’s New in SQLAlchemy 0.8?</a><ul>
137
129
<li><a class="reference internal" href="#introduction">Introduction</a></li>
138
130
<li><a class="reference internal" href="#platform-support">Platform Support</a><ul>
198
<h4>Previous Topic</h4>
200
<a href="changelog_01.html" title="previous chapter">0.1 Changelog</a>
204
<a href="migration_07.html" title="next chapter">What’s New in SQLAlchemy 0.7?</a>
208
<h4>Quick Search</h4>
210
<form class="search" action="../search.html" method="get">
211
<input type="text" name="q" size="18" /> <input type="submit" value="Search" />
212
<input type="hidden" name="check_keywords" value="yes" />
213
<input type="hidden" name="area" value="default" />
219
198
<div id="docs-body" class="withsidebar" >
221
200
<div class="section" id="what-s-new-in-sqlalchemy-0-8">
789
768
really drives what kinds of operations are present, it’s the
790
769
<em>type</em> of the expression. The implementation details are
791
770
minimal - only a few extra methods are added to the core
792
<a class="reference internal" href="../core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement" title="sqlalchemy.sql.expression.ColumnElement"><tt class="xref py py-class docutils literal"><span class="pre">ColumnElement</span></tt></a> type so that it consults it’s
771
<a class="reference internal" href="../core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement" title="sqlalchemy.sql.expression.ColumnElement"><tt class="xref py py-class docutils literal"><span class="pre">ColumnElement</span></tt></a> type so that it consults its
793
772
<a class="reference internal" href="../core/types.html#sqlalchemy.types.TypeEngine" title="sqlalchemy.types.TypeEngine"><tt class="xref py py-class docutils literal"><span class="pre">TypeEngine</span></tt></a> object for an optional set of operators.
794
773
New or revised operations can be associated with any type,
795
774
either via subclassing of an existing type, by using
1248
1227
<div class="highlight-python"><pre>SELECT t1.x, t2.y FROM t2</pre>
1250
1229
<p>which is invalid SQL as “t1” is not referred to in any FROM clause.</p>
1251
<p>Now, in the absense of an enclosing SELECT, it returns:</p>
1230
<p>Now, in the absence of an enclosing SELECT, it returns:</p>
1252
1231
<div class="highlight-python"><pre>SELECT t1.x, t2.y FROM t1, t2</pre>
1254
1233
<p>Within a SELECT, the correlation takes effect as expected:</p>