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

2011-12-01 20:09 keltezéssel, rep(dot)dot(dot)nop(at)gmail(dot)com írta:
> The following bug has been logged on the website:
>
> Bug reference: 6315
> Logged by: Bernhard Reutner-Fischer
> Email address: rep(dot)dot(dot)nop(at)gmail(dot)com
> PostgreSQL version: 9.1.1
> Operating system: linux
> Description:
>
> 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.

--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/