On May 25, 2006 01:31 pm, "Merlin Moncure" <mmoncure@xxxxxxxxx> wrote: > > SELECT DISTINCT ON (a, b) a, b, c FROM t ORDER BY a DESC, b DESC, c > > DESC; > > that is actually slower than group by in my case...am i missing > something? (both essentially resolved to seq_scan) Try it with an index on a,b,c. -- Alan
