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

2011-12-01 20:09 keltez=C3=A9ssel, rep.dot.nop@gmail.com =C3=ADrta:
> The following bug has been logged on the website:
>
> Bug reference:      6315
> Logged by:          Bernhard Reutner-Fischer
> Email address:      rep.dot.nop@gmail.com
> PostgreSQL version: 9.1.1
> Operating system:   linux
> Description:=20=20=20=20=20=20=20=20
>
> Binding for "OFFSET :offset" works fine but binding for a "=
;FETCH NEXT :next
> ROWS ONLY" raises:
> syntax error at or near "$2"
> 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.


--=20
----------------------------------
Zolt=C3=A1n B=C3=B6sz=C3=B6rm=C3=A9nyi
Cybertec Sch=C3=B6nig & Sch=C3=B6nig GmbH
Gr=C3=B6hrm=C3=BChlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
     http://www.postgresql.at/