"Wei Weng" <wweng(at)kencast(dot)com> 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