Does anyone know the status of outer join
with respect to PostgreSQL 6.4?
I'm in dire need of just LEFT OUTER JOIN
as I need to report which records approx 30,000
per day, no longer exist, which are new, and
which have been updated. The three ways I know
of simulating the affects are too slow:
1. use a UNION clause with NOT IN
2. create a function() to return the missing
field, else NULL
- or -
3. Programmatically determine if the record
does not exist for each record in
If anyone knows the status of outer join queries,
please let me know.
Marcus Mascari (mascarim(at)yahoo(dot)com)
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
pgsql-admin by date
|Next:||From: Tim Davies||Date: 1998-12-02 01:20:24|
|Subject: configure errors when installing 6.4|
|Previous:||From: Oliver Elphick||Date: 1998-12-01 22:49:12|
|Subject: Re: [ADMIN] recovering data from pgsql 6.1 installation |