Re: [SQL] DISTINCT ON () with UNION

[Tom Lane]

[EMAIL PROTECTED] writes:
> How can you use a distinct on () including the whole union.

In 7.1 you can write

select distinct ... from (select ... union select ...) ss;

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly