| From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
|---|---|
| To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: DISTINCT ... ORDER BY |
| Date: | 2003-11-05 21:36:22 |
| Message-ID: | 3FA96D56.80605@e-trolley.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Stephan Szabo wrote:
> Well, what did you get when you tried something like Bruno's updated
It worked.
But I thought you were trying to tell me that it could be non-deterministic.
> example or my group by one, and lets work from there.
I tried the group by method but as my order by expressions are booleans I couldn't use min()
and didn't find an applicable aggregate function.
so I thought to myself if we could just get a serial column after sorting, then we could use min()
on that column.
But if (both of) you are sure that the 'distinct method' is deterministic (in the end) I'd be glad.
TFYH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-11-05 22:55:06 | Re: DISTINCT ... ORDER BY |
| Previous Message | Nabil Sayegh | 2003-11-05 21:27:40 | Re: DISTINCT ... ORDER BY |