keyword LIMIT in SQL-statement, psqlodbc workaround?

Поиск
Список
Период
Сортировка
От Johann Zuschlag
Тема keyword LIMIT in SQL-statement, psqlodbc workaround?
Дата
Msg-id E149D5E-00045j-00@mrelay00.kundenserver.de
обсуждение исходный текст
Ответы Re: keyword LIMIT in SQL-statement, psqlodbc workaround?
wrong values in ODBC parameters?
Список pgsql-interfaces
Hi,

I'm using a commercial application. Well, apart from the problem 
that it crashes my psqlodbc.dll (which I'm trying to debug)
it uses the keyword LIMIT.

Like: CREATE ITEMS (NAME VARCHAR(10), LIMIT NUMERIC...

To my knowledge it worked with PostgreSQL 6.4. Why not with 7.x?
I thought it should be possible. Did I misinterpret SQL-92/98?
MS-SQL and ORACLE are accepting it.

Since I can't persuade my application to put LIMIT in quotes,
I need another solution. Any ideas, workarounds how to do it in
psqlodbc?

regards

Johann





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

Предыдущее
От: Dave Page
Дата:
Сообщение: Problems with int8 and MS ADO/ODBC
Следующее
От: Barry Lind
Дата:
Сообщение: Bugs in 7.1beta JDBC driver