Postgres Pro
Downloads
Home   >   mailing lists

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

From Stanislav Motyčka
Subject a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
Date
Msg-id d51371a2-f221-1cf3-4a7d-b2242d4dafdb@gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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: Jehan-Guillaume de Rorthais
Date:
Subject: Re: Replication: slave server has 3x size of production server?
Next
From: Josef Šimánek
Date:
Subject: Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]