6 ms·
One of the features I wish Postgres had is "column matchers" from ClickHouse: https://clickhouse.com/docs/en/sql-reference/statements/select#columns-expression
by zX41ZdbW 3y ago
One of the features I wish Postgres had is "column matchers" from ClickHouse: https://clickhouse.com/docs/en/sql-reference/statements/select#columns-expression https://clickhouse.com/docs/en/sql-reference/statements/sele...
SELECT COLUMNS('_id$') FROM table;
SELECT * EXCEPT(id) FROM table;
SELECT * REPLACE(i + 1 AS i) FROM table;
SELECT * APPLY(toString) FROM table;