simulate union in subselect - Mailing list pgsql-sql

From Wei Weng
Subject simulate union in subselect
Date
Msg-id 9c7g2a$2f4o$1@news.tht.net
Whole thread Raw
Responses Re: simulate union in subselect  (Peter Eisentraut <peter_e@gmx.net>)
Re: simulate union in subselect  (Tom Lane <tgl@sss.pgh.pa.us>)
order of multiple assignments in UPDATE  (Anuradha Ratnaweera <anuradha@gnu.org>)
List pgsql-sql
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 by date:

Previous
From: Hans-Jürgen Schönig
Date:
Subject: SET SEQSCAN TO OFF - error
Next
From: "Emils Klotins"
Date:
Subject: Re: Regexps -- too complex?