Re:Selecting All Columns Except One in PostgreSQL
by ereli1 on Saturday May 19, 2018 @10:13AM
(#17107965)
is EXCEPT part of the SQL standard?
[ Parent
| on HN ]
Re:Selecting All Columns Except One in PostgreSQL
by grzm on Saturday May 19, 2018 @10:29AM
(#17108010)
Yes, but not for this usage. It’s a set combiner like UNION and INTERSECT. IIRC, Tutorial D has an operator like this use of EXCEPT for attributes called ALL BUT.
Re:Selecting All Columns Except One in PostgreSQL
by blattimwind on Saturday May 19, 2018 @10:35AM
(#17108033)
Not in a column specification of a SELECT query.