Re: [SQL] simulate union in subselect

[Tom Lane]

"Wei Weng" <[EMAIL PROTECTED]> writes:
> I know this is not do-able, but is there any way to simulate the
> following in Postgresql 7.1?

> select id from
> (select id, recv_date as date from table1 
> union
> select id, send_date as date from table2) AS subtable
> order by date;

What gives you the idea that this doesn't work?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]