From: | "Svenne Krap" <svenne(at)krap(dot)dk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Subselects, the Oracle way - slightly OT |
Date: | 2001-06-18 20:39:36 |
Message-ID: | 3B2E8328.9896.A58B9B2@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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(at)krap(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Stef Telford | 2001-06-18 20:43:16 | Referential Integrity Question (Delete/Insert during Transaction) |
Previous Message | Joe Conway | 2001-06-18 20:18:12 | Re: Subselects, the Oracle way |