[SQL] simulate union in subselect

[Wei Weng]

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;

Thanks a lot 

Wei

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster