Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0HJoRV78636 for ; Thu, 17 Jan 2002 14:50:27 -0500 (EST) (envelope-from bruno@wolff.to) Received: (qmail 1316 invoked by uid 500); 17 Jan 2002 19:52:15 -0000 Date: Thu, 17 Jan 2002 13:52:15 -0600 From: Bruno Wolff III To: Unnikrishnan Menon Cc: pgsql-sql@postgresql.org Subject: Re: Union instead of Outer Join Message-ID: <20020117195215.GA1260@wolff.to> Mail-Followup-To: Unnikrishnan Menon , pgsql-sql@postgresql.org References: <00d101c19f6d$8eba7300$e90aa8c0@UNNIKRISHNAN> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00d101c19f6d$8eba7300$e90aa8c0@UNNIKRISHNAN> User-Agent: Mutt/1.3.25i X-Archive-Number: 200201/202 X-Sequence-Number: 6288 On Thu, Jan 17, 2002 at 09:12:17PM +0530, Unnikrishnan Menon wrote: > Any help would be appreciated. If you are running 7.1 or can upgrade to 7.1, then you can do outer joins and don't need to use the union trick.