Re: Am I crazy or is this SQL not possible

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Aaron Bono" <postgresql(at)aranya(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Am I crazy or is this SQL not possible
Date: 2006-06-02 02:41:17
Message-ID: 23448.1149216077@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Aaron Bono" <postgresql(at)aranya(dot)com> writes:
> Is this SQL-99 compliant or a PostgreSQL specific query? I really like it
> and have never seen this before.

DISTINCT ON is a Postgres-ism, I'm afraid. It's pretty handy though.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Patrick Jacquot 2006-06-02 08:45:35 Re: Am I crazy or is this SQL not possible
Previous Message Aaron Bono 2006-06-02 01:44:18 Re: Am I crazy or is this SQL not possible