last comma inside "CREATE TABLE ()" statements

From: Louis-David Mitterrand <vindex(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: last comma inside "CREATE TABLE ()" statements
Date: 2001-04-22 15:25:08
Message-ID: 20010422172508.A1766@apartia.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it against the SQL standard to accept a trailing comma in a table
declaration?

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.

--
PHEDRE: Insensée, où suis-je ? et qu'ai-je dit ?
Où laissé-je égarer mes voeux et mon esprit ?
(Phèdre, J-B Racine, acte 1, scène 3)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-22 15:57:13 Re: Re: Trusted plperl
Previous Message Oliver Elphick 2001-04-22 13:50:31 Re: PostgreSQL 7.1 and Sequences