Horton

Re: [HACKERS] distinct. Is this the correct behaviour?

Vince Vielhaber <vev@michvhf.com>

View thread
From: Vince Vielhaber <vev@michvhf.com>
To: sszabo@bigpanda.com
Cc: hackers@postgreSQL.org
Date: 1999-10-21T09:52:55Z
Lists: pgsql-hackers 
On Wed, 20 Oct 1999 sszabo@bigpanda.com wrote:

> 
> This seems to generally work in postgres for the simple cases I tried:
>  select x from foo group by x order by min(y)
> 
> Now I don't know if there are any hidden gotchas in that (or wierdness
> with the spec), but it also feels better to me than using distinct in this
> case as well, because it seems to explicitly describe how you want y
> ordered.

Hey!  That works!  Thanks!  Just checked sybase and the original query
acts identical to ours.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null
  # include <std/disclaimers.h>       Have you seen http://www.pop4.net?
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================