Just as I thought Postgres' quirky behaviour was having less of an impact on development I hit this lame barrier :
SELECT DISTINCT ON expressions must match initial ORDER BY expressions
It's entirely reasonable to want unique by pk, but order by a date field, thats' the kind of thing we use databases for, but no - Postgres requires that the distinct restriction matches the order by.
Very lame and incredibly annoying
