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

Re: Outer joins

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: kaiq(at)realtyideas(dot)com
Cc: "Michael S(dot) Kelly" <michaelk(at)axian(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Outer joins
Date: 2000-04-18 18:29:48
Message-ID: 200004181829.OAA24600@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
There is an FAQ item about it.

> why it is a problem at all, if you use sql so long? outer join
> can be easily simulated. 
> 
> On Tue, 18 Apr 2000, Michael S. Kelly wrote:
> 
> > I understand that outer joins are not supported in PostgreSQL.  I'm just
> > starting my first PostgreSQL project, and have to admit that this concerns
> > me.  Outer joins have come in handy, at some point, in almost every database
> > project I've ever worked on.  I guess I'd like to hear how you all work
> > around this issue.
> > 
> > Thanks,
> > 
> > -=michael=-
> > 
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-sql by date

Next:From: G. Anthony ReinaDate: 2000-04-18 18:44:12
Subject: Re: Counting distinct names
Previous:From: Michael S. KellyDate: 2000-04-18 18:17:02
Subject: RE: Outer joins

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