From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | sszabo(at)bigpanda(dot)com |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] distinct. Is this the correct behaviour? |
Date: | 1999-10-21 09:52:55 |
Message-ID: | Pine.BSF.4.05.9910210543140.5578-100000@paprika.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 20 Oct 1999 sszabo(at)bigpanda(dot)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(at)michvhf(dot)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
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 1999-10-21 13:16:57 | Re: Planning final assault on query length limits |
Previous Message | Oleg Broytmann | 1999-10-21 07:33:12 | Re: [HACKERS] Readline use in trouble?] |