On Tue, Aug 2, 2011 at 00:25, Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)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.