Skip site navigation (1) Skip section navigation (2)

keyword LIMIT in SQL-statement, psqlodbc workaround?

From: "Johann Zuschlag" <zuschlag2(at)online(dot)de>
To: "Pgsql-interfaces(at)postgresql(dot)org" <Pgsql-interfaces(at)postgresql(dot)org>
Subject: keyword LIMIT in SQL-statement, psqlodbc workaround?
Date: 2000-12-21 21:17:58
Message-ID: E149D5E-00045j-00@mrelay00.kundenserver.de (view raw or flat)
Thread:
Lists: 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




Responses

pgsql-interfaces by date

Next:From: Barry LindDate: 2000-12-21 22:17:51
Subject: Bugs in 7.1beta JDBC driver
Previous:From: Dave PageDate: 2000-12-21 15:18:20
Subject: Problems with int8 and MS ADO/ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group