Re: simulate union in subselect - Mailing list pgsql-sql

"Wei Weng" <wweng@kencast.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