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
Re: last comma inside "CREATE TABLE ()" statements |
| Список | 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 по дате отправления: