Re: BUG #6315: FETCH NEXT :next ROWS ONLY fails

Boszormenyi Zoltan <zb(at)cybertec(dot)at> writes:
> 2011-12-01 20:09 keltezssel, rep(dot)dot(dot)nop(at)gmail(dot)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