simulate union in subselect

Поиск
Список
Период
Сортировка
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


В списке pgsql-sql по дате отправления: