Tag Archives: Til

TIL: Finding a row with the max of multiple columns in Postgresql

Part of my job is desigining helper applications around a set of data in a database designed by a third-party software vendor. The vendor’s database design is … interesting to say the least; many of the records are versioned, so a common challenge is to find the newest record for a given entity.