aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2001-09-23 04:28:18 +0000
committerBruce Momjian <bruce@momjian.us>2001-09-23 04:28:18 +0000
commite19a5adaf71466efccbe1be92842e209ff6099a6 (patch)
tree29f45db01508f11f7c408eefe4fe0ed33c961fd3 /src
parent1bd0b3406a4a86d324c1f86e32ef48b474e424a1 (diff)
downloadpostgresql-e19a5adaf71466efccbe1be92842e209ff6099a6.tar.gz
postgresql-e19a5adaf71466efccbe1be92842e209ff6099a6.zip
Update regress tests for new LIMIT x,y behavior.
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/limit.out2
-rw-r--r--src/test/regress/sql/limit.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/limit.out b/src/test/regress/expected/limit.out
index e14cd6daf7e..c99e0941567 100644
--- a/src/test/regress/expected/limit.out
+++ b/src/test/regress/expected/limit.out
@@ -98,7 +98,7 @@ SELECT ''::text AS five, unique1, unique2, stringu1
SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
- ORDER BY unique1 LIMIT 5, 900;
+ ORDER BY unique1 LIMIT 900, 5;
five | unique1 | unique2 | stringu1
------+---------+---------+----------
| 900 | 913 | QIAAAA
diff --git a/src/test/regress/sql/limit.sql b/src/test/regress/sql/limit.sql
index d9c36888503..99842af2f6a 100644
--- a/src/test/regress/sql/limit.sql
+++ b/src/test/regress/sql/limit.sql
@@ -29,4 +29,4 @@ SELECT ''::text AS five, unique1, unique2, stringu1
ORDER BY unique1 OFFSET 990 LIMIT 5;
SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
- ORDER BY unique1 LIMIT 5, 900;
+ ORDER BY unique1 LIMIT 900, 5;