Skip site navigation (1) Skip section navigation (2)

left outer join

From: Marcus Mascari <mascarim(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: left outer join
Date: 1998-12-02 00:50:56
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
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)

Get your free address at

pgsql-admin by date

Next:From: Tim DaviesDate: 1998-12-02 01:20:24
Subject: configure errors when installing 6.4
Previous:From: Oliver ElphickDate: 1998-12-01 22:49:12
Subject: Re: [ADMIN] recovering data from pgsql 6.1 installation

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group