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

Re: Outer join in postgresql

From: Peter Vazsonyi <neko(at)kredit(dot)sth(dot)szif(dot)hu>
To: Patrick Kay <patk(at)auctionsolutions(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Outer join in postgresql
Date: 2000-06-12 18:21:38
Message-ID: Pine.LNX.4.10.10006122011350.1782-100000@kredit.sth.szif.hu (view raw or flat)
Thread:
Lists: pgsql-sql
On Mon, 12 Jun 2000, Patrick Kay wrote:

> I am looking for a way run an outer join in psql.  Can anyone help?
> 
> Informix has an "OUTER" keyword.  I don't see anything like this in the docs
> for psql.
> 
> Thanks much.
> -Pat Kay
> 

Hmmm... I don't now the exact definition of outer join.
I feel it may somethink like this:

SELECT * FROM a WHERE NOT EXISTS 
	(SELECT id FROM b WHERE b.id=a.id);

This works in postgresql, but doesn't use indices ;(
I mean this runs an sequencial scan on a, and many index scan on b.
The result may be done with a special hash-join, but not in current
versions.
I have a strange sens, in 7.1 it will be...
  regards
--
 nek;(


In response to

pgsql-sql by date

Next:From: Ed LoehrDate: 2000-06-12 19:23:47
Subject: Re: Outer join in postgresql
Previous:From: Ed LoehrDate: 2000-06-12 15:23:58
Subject: Re: Newbie question on how to check triggers created

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