> For row comparisons, (a, b) > (x, y) is equivalent to:
> (a > x) OR ((a = x) AND (b > y))
[1] https://dev.mysql.com/doc/refman/8.0/en/comparison-operators...
SELECT * EXCEPT FOO_ID FROM FOO;
I have always wanted this but have never vome across it...
WHERE NOT EXIST (SELECT ...)
can help?
I don't know any way to do that personally.
Otherwise, dynamic column names (that's your search engine fodder) require introspection…
-- "Chinook" sample database
select column_name
from information_schema.columns
where table_name = 'Track'
except
select 'UnitPrice'
I mean, the information from the information_schema must be updated anyway when one deletes a column or table, so I thought maybe a function like that which looks it up could exist.
I will try with PL/pgSQL, have long wanted to familiarise myself with it anyway.
If there's subset of rows you frequently want, you may just be able to define a view and use that. (At one point, I defined a text macro in my terminal to list the fields I usually wanted on our "orders" table.)
[1] https://blog.jooq.org/2018/05/14/selecting-all-columns-excep...