Re: SELECT question

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Michelle Konzack" <linux4michelle(at)freenet(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT question
Date: 2007-08-21 15:37:25
Message-ID: dcc563d10708210837h533528c7t7e371808dac5b06d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/18/07, Michelle Konzack <linux4michelle(at)freenet(dot)de> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-08-21 15:37:26 Re: SELECT question
Previous Message Ted Byers 2007-08-21 15:13:27 Re: Audit-trail engine inner-workings