incorrect syntax for offset
От | Jaime Casanova |
---|---|
Тема | incorrect syntax for offset |
Дата | |
Msg-id | 3073cc9b0908181508n766464b7jffab0fa3977299e5@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: incorrect syntax for offset
Re: incorrect syntax for offset |
Список | pgsql-docs |
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 по дате отправления: