Re: Trailing comma support in SELECT statements - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Trailing comma support in SELECT statements
Date
Msg-id 54431CBB.2010801@BlueTreble.com
Whole thread Raw
In response to Re: Trailing comma support in SELECT statements  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: Trailing comma support in SELECT statements
List pgsql-hackers
On 10/17/14, 11:19 PM, David E. Wheeler wrote:
> On Oct 17, 2014, at 3:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> Yeah, exactly.  Personally I'm *not* for this, but if we do it we should
>> do it consistently: every comma-separated list in the SQL syntax should
>> work the same.
>
> PL/pgSQL, too, I presume.

Yes.

The only case I can think of where we wouldn't want this is COPY.

BTW, this should also apply to delimiters other than commas; for example, some geometry types use ; as a delimiter
betweenpoints.
 

I do think such a change should be made in stages, and maybe not every last one makes it into 9.5, but the intention
shouldcertainly be that we support extra delimiters *everywhere*.
 
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: get_actual_variable_range vs idx_scan/idx_tup_fetch
Next
From: Robert Haas
Date:
Subject: Re: Superuser connect during smart shutdown