Hi, Is this bug in Postgres ? If yes, is it fixed in latest release ? Second query should return 2 rows instead of 1 ?
create table t(i int); insert into t values(1); insert into t values(2); insert into t values(3); pgdb=# select i from t order by i limit 9223372036854775806 offset 1; select i from t order by i limit 9223372036854775806 offset 1; i 2 3 (2 rows) pgdb=# select i from t order by i limit 9223372036854775807 offset 1; select i from t order by i limit 9223372036854775807 offset 1; i 2 (1 row) pgdb=# My server Version is postgres (PostgreSQL) 9.0.3 Thanks in advance!