RE: [HACKERS] implementing outer joins

From: "Stupor Genius" <stuporg(at)erols(dot)com>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Cc: "Brett McCormick" <brett(at)work(dot)chicken(dot)org>
Subject: RE: [HACKERS] implementing outer joins
Date: 1998-07-03 14:49:51
Message-ID: 000101bda691$d5825880$c697accf@darren
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> does anyone have any idea how difficult it would be to implement, and
> perhaps point me in the right direction?
>

I forget where, but there is a place in the code where the two values
of the join are compared to see whether the row qualifies. Around
this spot there is a check for one of the values being null and if it
is, the function doesn't include the data. Seems that modifying that
spot or using it as a basis for your code could be a quick start for
the left join. The right could perhaps then be converted beforehand
in the optimizer to a left to be handled there.

But there's prolly a great and sane reason why this wouldn't work.

Haven't thought about the full outer join yet. Don't have my machine
completely configured yet and it's hard to stay in to do that with it
being summer and all.

Later,
darrenk

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Roberto Joao Lopes Garcia 1998-07-03 14:57:05 Re: [HACKERS] Re: (postgres) Libpq Win32
Previous Message Sferacarta Software 1998-07-03 10:02:13 Access & Postgres