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 54305156.5020808@BlueTreble.com
Whole thread Raw
In response to Re: Trailing comma support in SELECT statements  (David G Johnston <david.g.johnston@gmail.com>)
Responses Re: Trailing comma support in SELECT statements
List pgsql-hackers
On 10/3/14, 4:02 PM, David G Johnston wrote:
> Should we also allow:
>
> SELECT
> , col1
> , col2
> , col3
> FROM ...
>
> ?
I would say yes, if we're going to do this. I don't see it being any worse than trailing commas.

If we are going to do this, we need to do it EVERYWHERE.

FWIW, the way I normally "work around" this problem is:

SELECT    blah    , foo    , bar    , baz

In my experience, it's quite uncommon to mess with the first item in the list, which mostly eliminates the issue. A
missingleading comma is also MUCH easier to spot than a missing trailing comma.
 



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: proposal: doc: simplify examples of dynamic SQL
Next
From: Bruce Momjian
Date:
Subject: Re: Aussie timezone database changes incoming