Postgres Pro
Downloads
Home   >   mailing lists

Re: oracle's first_value function for postgres? - Mailing list pgsql-general

From Stephen Frost
Subject Re: oracle's first_value function for postgres?
Date
Msg-id 20050914131650.GP6026@ns.snowman.net
Whole thread Raw
In response to Re: oracle's first_value function for postgres?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > * Ben (bench@silentmedia.com) wrote:
> >> Sweet, indeed it is. DISTINCT ON seems to be a postgresism, but I can
> >> live with that.
>
> > Uhhh, I was pretty sure it was standard SQL...
>
> Nope, definitely a Postgres-ism.

Huh.  Guess I suck then.  I actually do this a fair bit, is there any
way to do it in standard SQL?  It's terribly useful...

    Thanks,

        Stephen
Attachment

pgsql-general by date:

Previous
From: "philip johnson"
Date:
Subject: XlogFlus error message
Next
From: Michael Fuhr
Date:
Subject: Re: how to list rules?