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

Excerpts from Tom Lane's message of jue dic 01 18:32:58 -0300 2011:
> Boszormenyi Zoltan <zb@cybertec.at> writes:
> > 2011-12-01 20:09 keltez=C3=A9ssel, rep.dot.nop@gmail.com =C3=ADrta:
> >> Binding for "OFFSET :offset" works fine but binding for a &q=
uot;FETCH NEXT :next
> >> ROWS ONLY" raises:
> >> syntax error at or near "$2"
> >> SELECT * FROM foo OFFSET $1 ROWS FETCH NEXT $2 ROWS ONLY
>=20
> > This is not a supported syntax. Consider using
> > SELECT * FROM foo OFFSET $1 LIMIT $2
> > instead.
>=20
> 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.

Hmm, it works with parens only in the "fetch next" clause, they don't
seem necessary in the limit.  FWIW.

alvherre=3D# prepare foo(int, int) as select * from generate_series(1, 200)=
 offset $1 fetch next ($2) rows only;
PREPARE
alvherre=3D# execute foo(2+3, 1+2);
 generate_series=20
-----------------
               6
               7
               8
(3 filas)


--=20
=C3=81lvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support