From: Michael S. Kelly <michaelk@axian.com>
To: kaiq@realtyideas.com
Cc: pgsql-sql@postgresql.org
Subject: RE: Outer joins
Date: Tue, 18 Apr 2000 11:17:02 -0700
Message-ID: <NEBBKOJMAKEJJCCOJPPPAEMKCAAA.michaelk@axian.com> (raw)
In-Reply-To: <Pine.LNX.4.10.10004181253230.29720-100000@picasso.realtyideas.com>
Actually found the answer to my question in Bruce Momjian's book. I'm
shamefaced to say that I never considered UNION ALL solve the problem.
thanks,
-=michael=-
*****************************************************
* Michael S. Kelly
* 4800 SW Griffith Dr., Ste. 202
* Beaverton, OR 97005 USA
* voice: (503)644-6106 x122 fax: (503)643-8425
* <michaelk@axian.com>
* http://www.axian.com/
*****************************************************
* Axian: Software Consulting and Training
*****************************************************
-----Original Message-----
From: kaiq@realtyideas.com [mailto:kaiq@realtyideas.com]
Sent: Tuesday, April 18, 2000 10:54 AM
To: Michael S. Kelly
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Outer joins
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=-
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: michaelk@axian.com, kaiq@realtyideas.com
Subject: RE: Outer joins
In-Reply-To: <NEBBKOJMAKEJJCCOJPPPAEMKCAAA.michaelk@axian.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox