Re: distinct() vs distinct on ()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Haywood J'Bleauxmie" <hj1(at)fc4(dot)outerscape(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: distinct() vs distinct on ()
Date: 2001-11-29 05:02:01
Message-ID: 14905.1007010121@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Haywood J'Bleauxmie" <hj1(at)fc4(dot)outerscape(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-11-29 06:08:36 Re: PL/pgSQL loops?
Previous Message Stephan Szabo 2001-11-29 03:53:30 Re: PL/pgSQL loops?