Re: [HACKERS] Re: 7.0 weirdness

thanks for the hlep guys..

for those that are curious, the distinct is tehr cause it's
someone elses code that i'm workig on .. :) have to kick
out the bug's//

jeff

On Tue, 30 May 2000, Matthias Urlichs wrote:

> Hi,
>
> Jeff MacDonald:
> > gid is unique.. it's a serial..
> >
> Then there is no point in using "DISTINCT" in the first place, is there?
>
> > funny thing is tho this worked on 6.5
>
> It happened to work because your gid is unique. But in the general case,
> it can't work. Consider this table:
>
> gid created
> X 1
> Y 2
> X 3
>
> Now, should your query's result be
>
> gid
> X
> Y
>
> or should it be
>
> gid
> Y
> X
>
> ? And since the typical implementation throws away non-selected-for
> columns before UNIQUEing, how should it be able to sort anything?
>
> --
> Matthias Urlichs | noris network GmbH | smurf(at)noris(dot)de | ICQ: 20193661
> The quote was selected randomly. Really. | http://smurf.noris.de/
> --
> Problem mit cookie: File exists
>