syntax error at or near "ROWS"

Поиск
Список
Период
Сортировка
От Kristian Ivarsson
Тема syntax error at or near "ROWS"
Дата
Msg-id DB9PR01MB951240CCA56FE855C86CB51EF19A2@DB9PR01MB9512.eurprd01.prod.exchangelabs.com
обсуждение исходный текст
Список pgsql-odbc
PostgreSQL version: 16.4
Operating system:   Microsoft Windows 10 Enterprise Version 10.0.19044

SQLGetInfo with SQL_DBMS_NAME says version 16.0.4 though

Driver PSQLODBC35W.DLL version 13.02.0000



This error occurs only with some statements when using binding parameters
through ODBC

This statement is an example of when the error occurs

   SELECT "Id","Begin","End","Logfile" FROM "ServerSession" ORDER BY "Begin" ASC OFFSET ? ROWS FETCH FIRST ? ROW ONLY

but some more complex SQL statements (with `... OFFSET ? ROWS FETCH FIRST ? ROW ONLY`) works just fine

Having fixed values (e.g. `...OFFSET 100 ROWS FETCH FIRST 10 ROW ONLY`) works for all statements

I still haven't figured out the pattern what the differences really are that make some statements to work and some not to work (I haven't dug into the open source code at all (yet))


/ Kristian

p.s.

   I made a report to the "wrong" mail-list first where I was adviced to use this one

   https://www.postgresql.org/message-id/3145581.1725892966%40sss.pgh.pa.us

d.s.

В списке pgsql-odbc по дате отправления: