a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]

Поиск
Список
Период
Сортировка
От Stanislav Motyčka
Тема a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
Дата
Msg-id d51371a2-f221-1cf3-4a7d-b2242d4dafdb@gmail.com
обсуждение исходный текст
Ответы Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]  (Josef Šimánek <josef.simanek@gmail.com>)
Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]  (Miles Elam <miles.elam@productops.com>)
Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]]  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения
Hello,

Sometimes (for tables with many columns) it would be better and easier to write "SELECT" statement with clause "EXCEPT":
"SELECT * [EXCEPT col1 [,col2]] FROM ..."

It's easier to write "except" one or two columns from all (*) as to write names of all columns besides one or two.
What do you thin about it?

Best regards
Stano Motycka

В списке pgsql-general по дате отправления:

Предыдущее
От: Jehan-Guillaume de Rorthais
Дата:
Сообщение: Re: Replication: slave server has 3x size of production server?
Следующее
От: Josef Šimánek
Дата:
Сообщение: Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]