Received: from cicero1.cybercity.dk (cicero1.cybercity.dk [212.242.40.4]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5IJ7da38712 for ; Mon, 18 Jun 2001 15:07:40 -0400 (EDT) (envelope-from svenne@krap.dk) Received: from usr02.cybercity.dk (usr02.cybercity.dk [212.242.40.82]) by cicero1.cybercity.dk (Postfix) with ESMTP id 70A9115FC26 for ; Mon, 18 Jun 2001 21:07:04 +0200 (CEST) Received: from puppy (port89.ds1-vby.adsl.cybercity.dk [212.242.53.92]) by usr02.cybercity.dk (8.11.2/8.11.0) with ESMTP id f5IJ7Ys47307 for ; Mon, 18 Jun 2001 21:07:34 +0200 (CEST) (envelope-from svenne@krap.dk) From: "Svenne Krap" To: pgsql-sql@postgresql.org Date: Mon, 18 Jun 2001 21:05:44 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Subselects, the Oracle way Reply-To: svenne@krap.dk Message-ID: <3B2E6D28.17314.A02C932@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200106/268 X-Sequence-Number: 3529 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