| From: | Josef Šimánek <josef(dot)simanek(at)gmail(dot)com> |
|---|---|
| To: | Stanislav Motyčka <stanislav(dot)motycka(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |
| Date: | 2020-02-25 10:30:54 |
| Message-ID: | CAFp7Qwr9j_JFH2MMgmV2YbBqBn9Vu3xPKSLxvghMf5WnsL4Ljg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Just to mention, similar concept can be found in Google BigQuery.
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select-except
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select-replace
út 25. 2. 2020 v 11:18 odesílatel Stanislav Motyčka <
stanislav(dot)motycka(at)gmail(dot)com> napsal:
> 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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabio Ugo Venchiarutti | 2020-02-25 10:52:37 | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |
| Previous Message | Stanislav Motyčka | 2020-02-25 10:17:47 | a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |