Jaime Casanova <[email protected]> writes:
> i read that as allow me to use the ROWS in an OFFSET clause whatever i
> use LIMIT or FETCH for limiting results but seems like we try hard to
> make a distinguish from old syntax and new (sql standard) syntax
> pruebas=# select * from tab1 limit 3 offset 2 rows;
> ERROR: syntax error at or near "rows"
> LINE 1: select * from tab1 limit 3 offset 2 rows;
> ^
> pruebas=# select * from tab1 offset 2 fetch next 3 rows only;
> ERROR: syntax error at or near "fetch"
> LINE 1: select * from tab1 offset 2 fetch next 3 rows only;
Hmm. Seems like we could refactor the select_limit production so it
actually allows all the reasonable combinations. Let me have a look...
regards, tom lane
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
