Thread

1. is limit a reserved keyword?

   Gabriel Russell <g.russell@ieee.org> — 2000-05-26T21:24:51Z

   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
   
   
   

2. Re: [SQL] is limit a reserved keyword?

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-05-26T22:48:04Z

   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