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
seenhttp://www.pop4.net? Online Campground Directory http://www.camping-usa.com Online Giftshop
Superstore http://www.cloudninegifts.com
==========================================================================