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 | [EMAIL PROTECTED] | ICQ: 20193661
The quote was selected randomly. Really. | http://smurf.noris.de/
--
Problem mit cookie: File exists
