Re: last comma inside "CREATE TABLE ()" statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: last comma inside "CREATE TABLE ()" statements
Дата
Msg-id 27993.987956509@sss.pgh.pa.us
обсуждение исходный текст
Ответ на last comma inside "CREATE TABLE ()" statements  (Louis-David Mitterrand <vindex@apartia.ch>)
Ответы Re: last comma inside "CREATE TABLE ()" statements  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: last comma inside "CREATE TABLE ()" statements  (Mike Finn <mike.finn@tacticalExecutive.com>)
Список pgsql-general
Louis-David Mitterrand <vindex@apartia.ch> writes:
> Is it against the SQL standard to accept a trailing comma in a table
> declaration?

Yes ...

> CREATE TABLE "currency" (
>     currency_id varchar(3),
>     rate float, <-------------------- BOOM! parse error
> );

> As in perl, it would make life easier to simply ignore/accept a trailing
> comma on table declarations.

... however, this seems like a reasonable idea that would not introduce
any major problems.  I have no objections, if someone wants to submit
a grammar patch.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Alex Pilosov
Дата:
Сообщение: Re: last comma inside "CREATE TABLE ()" statements
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 7.1 and Sequences