Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA80996 for ; Mon, 8 Nov 1999 16:23:17 -0500 (EST) (envelope-from peter@peter-e.yi.org) Received: from uria.its.uu.se ([130.238.7.14]:1725 "EHLO peter-e.yi.org") by merganser.its.uu.se with ESMTP id ; Mon, 8 Nov 1999 22:22:58 +0100 Received: from peter (helo=localhost) by peter-e.yi.org with local-esmtp (Exim 3.02 #2) id 11kwJR-0001JG-00; Mon, 08 Nov 1999 22:26:53 +0100 Date: Mon, 8 Nov 1999 22:26:53 +0100 (CET) From: Peter Eisentraut To: "Matlack, Brad" cc: pgsql-sql@postgresql.org Subject: Re: [SQL] newbie outer-join In-Reply-To: <69730CEEF766D311B4D800902785F90413BE5C@kssgqm01.ogden.disa.mil> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: Peter Eisentraut On 1999-11-08, Matlack, Brad mentioned: > I'm trying to do what I think is an outer-join: > > SELECT > da.datname as database, > de.description as comment > FROM > pg_database as da, > pg_description as de > WHERE > (da.oid = de.objoid) > > Obviously, if there are no descriptions, no values will be returned. > What I want is to display all databases, with comments (valid or null). SELECT datname, [...,] obj_description(pg_database.oid) FROM pg_database; is a work-around. Outer joins will appear in the next release, so I hear. -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden