Search Postgresql Archives

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

Subject: Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
From: Stanislav Motycka <stanislav.motycka@xxxxxxxxx>
Date: Tue, 25 Feb 2020 20:46:37 +0100
Cc: PG-General Mailing List <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CA+renyWW_wjY7Qsis6fHJL_VQj=274aRD2Tb-k_QYe=aNwEing@mail.gmail.com>
References: <d51371a2-f221-1cf3-4a7d-b2242d4dafdb@gmail.com> <CAALojA9s5nkWezDJZMDj+EsDuwDzpexM0kV_gcP-MZhF00hYRw@mail.gmail.com> <CAFp7QwpCNq_wuXwaOOjvcaRjC3vVTQZrifbb3EHpPv9ZWiVz+w@mail.gmail.com> <CAALojA_ycJBcbp4hgbvO21HqX0_jnbRDnpa8fBEm2=GRn++Azw@mail.gmail.com> <CA+renyWW_wjY7Qsis6fHJL_VQj=274aRD2Tb-k_QYe=aNwEing@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.5.0

Dňa 25. 2. 2020 o 20:28 Paul A Jungwirth napísal(a):

I take the proposal to mean this:

SELECT listOfColumns [EXCEPT listOfColumns] FROM ...

Exactly, simply exclude unneeded columns from the base clause "SELECT", nothing more ..

Follow-Ups:
- Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
  - From: Paul Jungwirth

References:
- a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
  - From: Stanislav Motyčka
- Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
  - From: Miles Elam
- Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
  - From: Josef Šimánek
- Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
  - From: Miles Elam
- Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]
  - From: Paul A Jungwirth