DISTINCT ON () with UNION

From: pgsql(at)peope(dot)net
To: pgsql-sql(at)postgresql(dot)org
Subject: DISTINCT ON () with UNION
Date: 2001-05-13 23:14:04
Message-ID: 20010513.23140422@mis.configured.host
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-05-14 00:52:39 Re: DISTINCT ON () with UNION
Previous Message Subhramanya Shiva 2001-05-13 16:43:59 how to remove ?