select distinct on (code) id,code,active from objects \
where version<=2 and (process=17 or process=0) \
group by id,code,active,version \
order by code asc,active desc,version desc
I'm a bit green with Postgres. Is this query performant enough? Are
there things I can do to make it better (indexing, some other method?)
I have 'id' as the primary key and unique(code,version,active).
-- Ciprian Popovici <ciprian(dot)popovici(at)integrare(dot)ro>