The min()/max() aggregate functions don't work on composite types in PostgreSQL. :blobcatsob:

Which is silly because they do have a defined order - you can throw a b-tree index on them, apply the usual comparison operators and even throw them in an ORDER BY clause.

Sign in to participate in the conversation

A lonely little town in the wider world of the fediverse.