diff options
author | Bruce Momjian | 2001-10-20 02:55:39 +0000 |
---|---|---|
committer | Bruce Momjian | 2001-10-20 02:55:39 +0000 |
commit | f363b3177d6b50c987c2028fde610e25026be416 (patch) | |
tree | f59975efa055d245a4160c439c8f6845e0eebb65 /HISTORY | |
parent | 424d9389d61997266aa17dec7ac8247a2459fdef (diff) |
Remove LIMIT #,# and suggest LIMIT # OFFSET #, per mailing list discussion.
Diffstat (limited to 'HISTORY')
-rw-r--r-- | HISTORY | 5 |
1 files changed, 2 insertions, 3 deletions
@@ -38,9 +38,8 @@ Migration to 7.2 A dump/restore using pg_dump is required for those wishing to migrate data from any previous release. One significant change is that - SELECT ... LIMIT 10,20 now uses the 10 as the OFFSET and the 20 as - the LIMIT. Previous versions had this reversed. This change was - made for MySQL compatibility. + the SELECT ... LIMIT 10,20 syntax is no longer supported. You must + now use LIMIT 10 OFFSET 20 to accomplish the same thing. |