Re: oracle's first_value function for postgres?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ben <bench(at)silentmedia(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: oracle's first_value function for postgres?
Date: 2005-09-14 13:16:50
Message-ID: 20050914131650.GP6026@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Stephen Frost <sfrost(at)snowman(dot)net> writes:
> > * Ben (bench(at)silentmedia(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-09-14 13:19:48 Re: how to list rules?
Previous Message philip johnson 2005-09-14 11:56:15 XlogFlus error message