Re: [SQL] Subselects, the Oracle way

2001-06-18 Thread Tom Lane
"Svenne Krap" <[EMAIL PROTECTED]> writes: > Is there any way to mimic the oracle way of subselect, especially > constructs like > select * from (select col1 as x, col2, col6 from t1 union select col2 > as x, col6, col2 from t2) y order by y.x That should work fine in 7.1 ...

[SQL] Subselects, the Oracle way

2001-06-18 Thread Svenne Krap
Hi, Is there any way to mimic the oracle way of subselect, especially constructs like select * from (select col1 as x, col2, col6 from t1 union select col2 as x, col6, col2 from t2) y order by y.x I am aware of the fact, that it is possible to accomplish through the use of tempoary tables,