Обсуждение: is limit a reserved keyword?

Поиск
Список
Период
Сортировка

is limit a reserved keyword?

От
Gabriel Russell
Дата:
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?

ThanksGabriel Russellg.russell@ieee.org



Re: is limit a reserved keyword?

От
Tom Lane
Дата:
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