Postgres Pro
Downloads
Home   >   mailing lists

Re: distinct() vs distinct on () - Mailing list pgsql-sql

From Tom Lane
Subject Re: distinct() vs distinct on ()
Date
Msg-id 14905.1007010121@sss.pgh.pa.us
Whole thread Raw
In response to distinct() vs distinct on ()  ("Haywood J'Bleauxmie" <hj1@fc4.outerscape.net>)
List pgsql-sql
Tree view 
"Haywood J'Bleauxmie" <hj1@fc4.outerscape.net> writes:
> The first SELECT does NOT work in that the distinct() is ignored.

Hard to believe.  Would you mind providing a *complete* example?
Queries with no schema or test data are not very helpful.
        regards, tom lane

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: PL/pgSQL loops?
Next
From: Tom Lane
Date:
Subject: Re: Return Opaque / Error in Function