| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Stanislav Motyčka <stanislav(dot)motycka(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |
| Date: | 2020-02-25 19:53:29 |
| Message-ID: | 20200225195329.GA303@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2020-Feb-25, Stanislav Motyčka 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 ..."
I think an important initial question is how do other database systems
implement this functionality, if they do, and what syntax do they offer.
From there we can move on to the conversation of where is the ISO SQL
committee going about this.
I think it's good to extend the standard to some extent, but it would
not do to have it extended in a direction that ends up contrary to what
they pursue in the future.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dipanjan Ganguly | 2020-02-25 19:53:57 | Re: Connections dropping while using Postgres backend DB with Ejabberd |
| Previous Message | Stanislav Motycka | 2020-02-25 19:46:37 | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |