Limit+Offset query wrong result in Postgres 9.0.3 ? - Mailing list pgsql-general

From urkpostenardr
Subject Limit+Offset query wrong result in Postgres 9.0.3 ?
Date
Msg-id CAELx_2MChX7HJZgKcYWOoSp0az00iad8sCmzfx2gv5jRh-pKGw@mail.gmail.com
Whole thread Raw
Responses Re: Limit+Offset query wrong result in Postgres 9.0.3 ?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: Limit+Offset query wrong result in Postgres 9.0.3 ?  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
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!



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Expensive log_line_prefix ?
Next
From: Condor
Date:
Subject: Re: How to raise index points when equal and like is usedwith gist ?