Postgres Pro
Downloads
Home   >   mailing lists

Re: Am I crazy or is this SQL not possible - Mailing list pgsql-sql

From Tom Lane
Subject Re: Am I crazy or is this SQL not possible
Date
Msg-id 23448.1149216077@sss.pgh.pa.us
Whole thread Raw
In response to Re: Am I crazy or is this SQL not possible  ("Aaron Bono" <postgresql@aranya.com>)
List pgsql-sql
Tree view 
"Aaron Bono" <postgresql@aranya.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

pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: Am I crazy or is this SQL not possible
Next
From: Patrick Jacquot
Date:
Subject: Re: Am I crazy or is this SQL not possible