Re: Trailing comma support in SELECT statements

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Trailing comma support in SELECT statements
Дата
Msg-id 54305156.5020808@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Trailing comma support in SELECT statements  (David G Johnston <david.g.johnston@gmail.com>)
Ответы Re: Trailing comma support in SELECT statements
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: proposal: doc: simplify examples of dynamic SQL
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Aussie timezone database changes incoming