Re: Subselects, the Oracle way - Mailing list pgsql-sql

From Tom Lane
Subject Re: Subselects, the Oracle way
Date
Msg-id 8294.992895326@sss.pgh.pa.us
Whole thread Raw
In response to Subselects, the Oracle way  ("Svenne Krap" <svenne@krap.dk>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Stef Telford
Date:
Subject: Referential Integrity Question (Delete/Insert during Transaction)
Next
From: Peter Eisentraut
Date:
Subject: Re: Subselects, the Oracle way