Re: [GENERAL] last comma inside CREATE TABLE () statements

2001-04-27 Thread Rod Taylor
by default. -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: will trillich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 27, 2001 12:56 AM Subject: Re: [GENERAL] last comma inside

Re: [GENERAL] last comma inside CREATE TABLE () statements

2001-04-26 Thread Mike Finn
On Sunday 22 April 2001 10:21, you wrote: 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 Please don't. IMHO This would be an unnecessary

[GENERAL] last comma inside CREATE TABLE () statements

2001-04-22 Thread Louis-David Mitterrand
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.

Re: [GENERAL] last comma inside CREATE TABLE () statements

2001-04-22 Thread Alex Pilosov
On Sun, 22 Apr 2001, Louis-David Mitterrand wrote: Is it against the SQL standard to accept a trailing comma in a table declaration? Yes it is. CREATE TABLE "currency" ( currency_id varchar(3), rate float, BOOM! parse error ); As in perl, it would make life

Re: [GENERAL] last comma inside CREATE TABLE () statements

2001-04-22 Thread Tom Lane
Louis-David Mitterrand [EMAIL PROTECTED] 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

Re: [GENERAL] last comma inside CREATE TABLE () statements

2001-04-22 Thread Oliver Elphick
Tom Lane wrote: Louis-David Mitterrand [EMAIL PROTECTED] 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 );

Re: [GENERAL] last comma inside CREATE TABLE () statements

2001-04-22 Thread GH
On Sun, Apr 22, 2001 at 07:44:46PM +0100, some SMTP stream spewed forth: Tom Lane wrote: Louis-David Mitterrand [EMAIL PROTECTED] writes: Is it against the SQL standard to accept a trailing comma in a table declaration? Yes ... CREATE TABLE "currency" (