On 8/18/07, Michelle Konzack <linux4michelle@xxxxxxxxxx> wrote: > Am 2007-08-17 12:53:41, schrieb Michael Glaesemann: > > (Is is just me or have there been a lot of queries that can be solved > > using DISTINCT ON recently?) > > I do not know... Since when does "DISTINCT ON" exist? I have been lurking on this thread, don't have much to add, but distinct on has been around in postgresql for as long as I can remember. It's not SQL spec, so it's not portable. but it is awefully useful. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
