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

From: Stanislav Motyčka <stanislav(dot)motycka(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
Date: 2020-02-25 10:17:47
Message-ID: d51371a2-f221-1cf3-4a7d-b2242d4dafdb@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Šimánek 2020-02-25 10:30:54 Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
Previous Message Jehan-Guillaume de Rorthais 2020-02-25 09:55:44 Re: Replication: slave server has 3x size of production server?