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

Поиск
Список
Период
Сортировка
От Guyren Howe
Тема Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]]
Дата
Msg-id 04749208-2BB9-4E4B-ADFF-464713C6D5CC@gmail.com
обсуждение исходный текст
Ответ на Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
Список pgsql-general
Дерево обсуждения


On Feb 25, 2020, at 11:28 , Paul A Jungwirth <pj@illuminatedcomputing.com> wrote:

On Tue, Feb 25, 2020 at 2:18 AM Stanislav Motyčka
<stanislav.motycka@gmail.com> wrote:
Sometimes (for tables with many columns) it would be better and easier to write "SELECT" statement with clause "EXCEPT":
"SELECT * [EXCEPT col1 [,col2]] FROM …"

The single biggest benefit is that I could write many more views that don’t need to be changed when I change the underlying table.



ul[class*='mb-extra__public-links'], ul[class*='mb-note__public-links'], ul[class*='mb-task__public-links'] { display: none !important; }

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

Предыдущее
От: Justin
Дата:
Сообщение: Re: Connections dropping while using Postgres backend DB with Ejabberd
Следующее
От: Stanislav Motycka
Дата:
Сообщение: Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]]