Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] distinct. Is this the correct behaviour? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] distinct. Is this the correct behaviour?
Date
Msg-id 17081.940520176@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] distinct. Is this the correct behaviour?  ("Damond Walker" <dwalker@black-oak.com>)
Responses Re: [HACKERS] distinct. Is this the correct behaviour?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
"Damond Walker" <dwalker@black-oak.com> writes:
> Returned the following message under MS SQL Server 7.0:
>     ORDER BY items must appear in the select list if SELECT DISTINCT is
> specified.

Sure looks like that is the consensus answer to the semantics problem...
guess we should do the same.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] GPL vs BSD licencing - a new twist
Next
From: Peter Mount
Date:
Subject: RE: [HACKERS] GPL vs BSD licencing - a new twist