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 t

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

[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 broadcast)