Re: [SQL] Subselects, the Oracle way

[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 ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])