Smokes your problems, coughs fresh air.

pg_rowalesce: COALESCE(), but for rows

Another part of my spin-off PostgreSQL extension series is pg_rowalesce. From its (generated with pg_readme):

The pg_rowalesce PostgreSQL extensions its defining feature is the rowalesce() function. rowalesce() is like coalesce(), but for rows and other composite types. From its arbitrary number of argument rows, for each field/column, rowalesce() takes the value from the first row for which that particular field/column has a not null value.

1 Comment

  1. Rowan Rodrik

    pg_rowalesce can now be found on PGXN—The PostgreSQL Extension Network:

© 2024 BigSmoke

Theme by Anders NorenUp ↑