Re: [BUGS] BUG #6315: FETCH NEXT :next ROWS ONLY fails

[Tom Lane]

Boszormenyi Zoltan <z...@cybertec.at> writes:
> 2011-12-01 20:09 keltezéssel, rep.dot....@gmail.com írta:
>> Binding for &quot;OFFSET :offset&quot; works fine but binding for a 
>> &quot;FETCH NEXT :next
>> ROWS ONLY&quot; raises:
>> syntax error at or near &quot;$2&quot;
>> SELECT * FROM foo OFFSET $1 ROWS FETCH NEXT $2 ROWS ONLY

> This is not a supported syntax. Consider using
> SELECT * FROM foo OFFSET $1 LIMIT $2
> instead.

Well, actually it is supported, but you missed the fine print where it
says that you have to add parentheses if the offset or count isn't a
simple integer constant.  I'll apply a patch to make that a bit more
obvious.

                        regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs