Postgres Pro
Downloads
Home   >   mailing lists

DISTINCT ON () with UNION - Mailing list pgsql-general

From Per-Olof Pettersson
Subject DISTINCT ON () with UNION
Date
Msg-id 20010513.23201496@mis.configured.host
Whole thread Raw
List pgsql-general
Tree view 
How can you use a distinct on () including the whole union.

eg

select distinct on (valutaid) valutaid, short from valuta UNION select
landid, land from land order by valutaid;

table: valuta
valutaid    valuta
1        USD
2        SEK

table: land
landid    land
1        Sweden
2        USA
3        Norway

The above would give
1    USD
1    Sweden
2    SEK
2    USA
3    Norway

What I would like to get is
1    USD
2    SEK
3    Norway

I did specify distinct on (valutaid) anyways =)

Any suggestions?

Best regards
Per-Olof Pettersson

pgsql-general by date:

Previous
From: "Howard Williams"
Date:
Subject: trigger/function question
Next
From: "Eric G. Miller"
Date:
Subject: Re: Bug with timestamp !!!