3 ms·
i would rather it written as SELECT * BUT or SELECT * EXCEPT or even SELECT ALL BUT. SQL has always been that language that is easy to read. even when you don'
by blondin 5y ago
i would rather it written as SELECT * BUT or SELECT * EXCEPT or even SELECT ALL BUT.
SQL has always been that language that is easy to read. even when you don't understand what the queries are doing. adding a cryptic syntax like "-column" would make it less readable.
- colinmhayes 5y agoEXCEPT is already a sql keyword
- polygotdomain 5y agoWhat about SELECT * WITHOUT {columns_you_do_not_want} FROM... EXCEPT is already a keyword and has is used for set-based operations, so I don't think it's good to overload it.
- edgyquant 5y agoI like this fwiw
- recursive 5y agoThe given syntax is obviously a no-go. It's already unary minus.