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

is limit a reserved keyword?

From: Gabriel Russell <g(dot)russell(at)ieee(dot)org>
To: pgsql-sql(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: is limit a reserved keyword?
Date: 2000-05-26 21:24:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-sql
I have a piece of commercial software that does a query like so:
CREATE TABLE chargelimits (id int NOT NULL, user_id int NOT NULL, limit 
float NOT NULL )
but the postgresql 7.0 gives a parse error near "limit".
Is limit a reserved keyword?
If so, then it is not in the list of reserved keywords.
Is there a way that I can make this query run without altering it?

	Gabriel Russell


pgsql-bugs by date

Next:From: Tom LaneDate: 2000-05-26 22:48:04
Subject: Re: [SQL] is limit a reserved keyword?
Previous:From: Nishad PRAKASHDate: 2000-05-26 14:18:01
Subject: Re: \dS and \df <pattern> crashing psql

pgsql-sql by date

Next:From: Tom LaneDate: 2000-05-26 21:34:28
Subject: Re: Re: [SQL] aliases break my query
Previous:From: Olivier PRENANTDate: 2000-05-26 20:03:56
Subject: New Type

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