7 ms·
PostgresSQL "crosstab ( source_sql text, category_sql text ) → setof record" https://www.postgresql.org/docs/current/tablefunc.html https://www.postgresql.org
by amichal 6mo ago
PostgresSQL
"crosstab ( source_sql text, category_sql text ) → setof record"
https://www.postgresql.org/docs/current/tablefunc.html https://www.postgresql.org/docs/current/tablefunc.html
VIA https://www.beekeeperstudio.io/blog/how-to-pivot-in-postgresql/ https://www.beekeeperstudio.io/blog/how-to-pivot-in-postgres... as a current googlable reference/guide