Svenne Krap 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
I don't know what's supposed to be the "Oracle" way about this, but this
particular query should work in PostgreSQL 7.1.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter