Received: from lady.axian.com (lady.axian.com [38.252.131.138]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA72509 for ; Tue, 18 Apr 2000 14:16:22 -0400 (EDT) (envelope-from michaelk@axian.com) Received: from TestClient (Test_Client [38.252.132.181]) by lady.axian.com (8.9.1a/8.9.1) with SMTP id LAA24453; Tue, 18 Apr 2000 11:16:10 -0700 (PDT) From: "Michael S. Kelly" To: Cc: Subject: RE: Outer joins Date: Tue, 18 Apr 2000 11:17:02 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Importance: Normal X-Archive-Number: 200004/190 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 * * 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=- >