On Tue, Aug 2, 2011 at 00:25, Hitoshi Harada <umi.tan...@gmail.com> wrote:
> db1=# select * from test_xy order by x LIMIT 9223372036854775807 OFFSET 6; [ ...] > db1=# select * from test_xy order by x LIMIT pow(2, 63); > ERROR: bigint out of range > ERROR: bigint out of range > > Maybe a parser converts literal unexpectedly? pow(2, 63) != 9223372036854775807, pow(2, 63) - 1 does :-). On top of that pow(2, 63) seems to default to the double variant of pow() which causes rounding issues. You probably want LIMIT pow(2, 63::numeric)-1. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
