Re: [SQL] simulate union in subselect

2001-04-26 Thread Peter Eisentraut
Wei Weng 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; I haven't actually tried whether this does

Re: [SQL] simulate union in subselect

2001-04-26 Thread Tom Lane
Wei Weng [EMAIL PROTECTED] 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

[SQL] simulate union in subselect

2001-04-26 Thread Wei Weng
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 ---(end of