On May 25, 2006 01:31 pm, "Merlin Moncure" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
