Received: from cicero1.cybercity.dk (cicero1.cybercity.dk [212.242.40.4]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5IKfTa78634 for ; Mon, 18 Jun 2001 16:41:29 -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 BD33D15FC78 for ; Mon, 18 Jun 2001 22:40:55 +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 f5IKfPR82653 for ; Mon, 18 Jun 2001 22:41:25 +0200 (CEST) (envelope-from svenne@krap.dk) From: "Svenne Krap" To: pgsql-sql@postgresql.org Date: Mon, 18 Jun 2001 22:39:36 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Subselects, the Oracle way - slightly OT Reply-To: svenne@krap.dk Message-ID: <3B2E8328.9896.A58B9B2@localhost> References: <3B2E6D28.17314.A02C932@localhost> In-reply-to: <8294.992895326@sss.pgh.pa.us> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200106/273 X-Sequence-Number: 3534 > That should work fine in 7.1 ... Ups.. forgot to tell that I was working on 7.0.3 .. upgrade is not an option right now.. but I guess you answered already (not possible in 7.0) :) Btw. any idea when cross-database queries will be implementet (you know select x.col1, y.col2 from localtable x, foreigndbtable y where x.col1=y.col2) ? A real needy feature, if you ask me :) Btw. a litte side question: having a table with quite an amount of data (all telephone/addresses in denmark :) which change only very rarely (once every 3 months). I our first setup it is contained in a database for its own (becase PGSQL 7.0 - not sure about 7.1) connects rather slowly, if giant tables are present. Is there any way to speed it up, or is a split database design the only way to go ? Again TIA 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