Affects Version/s: None
Fix Version/s: None
support the following syntax:
which for a table t with columns a,b,c,d,e would be equal to:
Please note that the EXCLUDE clause relates directly to its preceding asterisk.
Here are some useful use cases:
This supplies a very clean way to select all columns without getting "Ambiguous column reference" and without the need to specify all the columns of at least one of the tables.
Currently, without this enhancement, the query would look something like this:
Considering a table may hold hundreds or even thousands of column, this can be come very ugly and error prone.
Often this require some scripting work.
Creating views with all the tables columns except for some technical columns
Remove computational columns that are not needed in the final row-set, e.g. -
retrieve the last record for each customer