"Svenne Krap" <svenne@krap.dk> 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