Postgres Pro
Downloads
Home   >   mailing lists

Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] - Mailing list pgsql-general

From Josef Šimánek
Subject Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
Date
Msg-id CAFp7Qwr9j_JFH2MMgmV2YbBqBn9Vu3xPKSLxvghMf5WnsL4Ljg@mail.gmail.com
Whole thread Raw
In response to a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]  (Stanislav Motyčka <stanislav.motycka@gmail.com>)
Responses Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]]
List pgsql-general
Tree view

út 25. 2. 2020 v 11:18 odesílatel Stanislav Motyčka <stanislav.motycka@gmail.com> napsal:
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 by date:

Previous
From: Stanislav Motyčka
Date:
Subject: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
Next
From: Fabio Ugo Venchiarutti
Date:
Subject: Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]]