Postgresql – How to efficiently aggregate rows into arrays, but preserve `NULL` to indicate missing data?
I currently have a database schema like the following table: CREATE TABLE Measures( expId SERIAL, iteration INT NOT NULL, value float4 NOT NULL, PRIMARY KEY(expId, iteration) ); So, a table of various measurements, repeated for n iterations. Though, because we…