is limit a reserved keyword?

Started by Gabriel Russellalmost 26 years ago2 messagesbugs
Jump to latest
#1Gabriel Russell
g.russell@ieee.org

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?

Thanks
Gabriel Russell
g.russell@ieee.org

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Gabriel Russell (#1)
Re: [SQL] is limit a reserved keyword?

Gabriel Russell <g.russell@ieee.org> writes:

Is limit a reserved keyword?

Yes.

If so, then it is not in the list of reserved keywords.

Documentation oversight, evidently :-(

regards, tom lane