2011-12-01 20:09 keltezéssel, rep.dot....@gmail.com írta: > The following bug has been logged on the website: > > Bug reference: 6315 > Logged by: Bernhard Reutner-Fischer > Email address: rep.dot....@gmail.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/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
