Search Postgresql Archives
a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
- From: Stanislav Motyčka <stanislav.motycka@xxxxxxxxx>
- Date: Tue, 25 Feb 2020 11:17:47 +0100
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.5.0
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]