Subselects, the Oracle way
От | Svenne Krap |
---|---|
Тема | Subselects, the Oracle way |
Дата | |
Msg-id | 3B2E6D28.17314.A02C932@localhost обсуждение исходный текст |
Ответы |
Referential Integrity Question (Delete/Insert during Transaction)
Re: Subselects, the Oracle way Re: Subselects, the Oracle way |
Список | pgsql-sql |
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, but would rather not use them. Thanks in advance Svenne -- svenne@krap.dk http://www.krap.dk ICQ 5434480 PGP-key http://keys.pgp.dk:11371/pks/lookup?op=get&search=0xDF484022 PGP @ http://www.pgp.com / http://www.phpi.com
В списке pgsql-sql по дате отправления: