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
Re: simulate union in subselect
order of multiple assignments in UPDATE
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?