| From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | Nabil Sayegh <postgresql(at)e-trolley(dot)de>, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: DISTINCT ... ORDER BY |
| Date: | 2003-11-05 20:06:30 |
| Message-ID: | 3FA95846.2020701@e-trolley.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Stephan Szabo wrote:
> Your step 3 above isn't well defined in general. There's no single place
> in the sort order for a value of a column being distincted when the value
> occurs multiple times. In the data above, col1='b' occurs twice in the
> sort order and you need to give an indication of which place in the sort
> order you want to use.
Ok, let's look for alternatives.
Is it possible to add a serial column to my ordered result ?
I hope there is a way to do it without temporary tables as I want to keep
it all in 1 query.
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 | Karen Smallwood | 2003-11-05 20:27:19 | COPY with null |
| Previous Message | Corey W. Gibbs | 2003-11-05 19:25:30 | Remove Unused Blobs? |