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

[Josef Šimánek <josef.simanek@xxxxxxxxx>]

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.motycka@xxxxxxxxx> 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