incorrect syntax for offset
От
Jaime Casanova
Тема
incorrect syntax for offset
Дата
Msg-id
3073cc9b0908181508n766464b7jffab0fa3977299e5@mail.gmail.com
Список
Дерево обсуждения
incorrect syntax for offset Jaime Casanova <jcasanov@systemguards.com.ec>
Re: incorrect syntax for offset Bruce Momjian <bruce@momjian.us>
Re: incorrect syntax for offset Tom Lane <tgl@sss.pgh.pa.us>
Hi.
Our current docs says that we support the following syntax (i'm
putting just the lines that disturbes me) inside a SELECT statement
"""
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
"""
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;
^
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
В списке pgsql-docs по дате отправления
От: Andreas Wenk
Дата: