summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJonathan Ellis <jbellis@gmail.com>2007-01-24 00:13:45 +0000
committerJonathan Ellis <jbellis@gmail.com>2007-01-24 00:13:45 +0000
commit4e9aaff50ff679fc51c4d799b000c2fcfc70a999 (patch)
tree637d8507630b8ffa9930193bb7ec731482e898dd
parent2a7a5525c0088fa478004aaa87bf0076b7ca336a (diff)
downloadsqlalchemy-4e9aaff50ff679fc51c4d799b000c2fcfc70a999.tar.gz
note support for LIMIT in firebird and mssql
-rw-r--r--doc/build/content/sqlconstruction.txt2
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/build/content/sqlconstruction.txt b/doc/build/content/sqlconstruction.txt
index 507f97ebf..213456220 100644
--- a/doc/build/content/sqlconstruction.txt
+++ b/doc/build/content/sqlconstruction.txt
@@ -426,7 +426,7 @@ These are specified as keyword arguments:
{sql}c = users.select(limit=10, offset=20).execute()
SELECT users.user_id, users.user_name, users.password FROM users LIMIT 10 OFFSET 20
-The Oracle driver does not support LIMIT and OFFSET directly, but instead wraps the generated query into a subquery and uses the "rownum" variable to control the rows selected (this is somewhat experimental).
+The Oracle driver does not support LIMIT and OFFSET directly, but instead wraps the generated query into a subquery and uses the "rownum" variable to control the rows selected (this is somewhat experimental). Similarly, the Firebird and MSSQL drivers convert LIMIT into queries using FIRST and TOP, respectively.
### Inner and Outer Joins {@name=join}