Received: from athena.office.vi.net ([194.88.88.225]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2GNZjx79278 for ; Fri, 16 Mar 2001 18:35:46 -0500 (EST) (envelope-from rp@office.vi.net) Received: from rp by athena.office.vi.net with local (Exim 3.12 #1 (Debian)) id 14e3kp-00032S-00; Fri, 16 Mar 2001 23:35:31 +0000 Date: Fri, 16 Mar 2001 23:35:31 +0000 From: Richard Poole To: Christopher Audley Cc: pgsql-sql@postgresql.org Subject: Re: Oracle to PostgreSQL help: What is (+) in Oracle select? Message-ID: <20010316233531.A10408@office.vi.net> References: <3AB29A4A.8030303@jhu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3AB29A4A.8030303@jhu.edu>; from Christopher.D.Audley@jhu.edu on Fri, Mar 16, 2001 at 05:57:14PM -0500 X-Archive-Number: 200103/340 X-Sequence-Number: 2004 On Fri, Mar 16, 2001 at 05:57:14PM -0500, Christopher Audley wrote: > I'm trying to modify an application which runs on Oracle to run against > PostgreSQL. I'm currently stuck on a query that I can't recognize, it > doesn't look like standard SQL. > > A select is done across two tables, however when joining the foreign > key, the right hand side of the equallity has (+) appended > > SELECT o.* from one o, two t where o.key = t.key(+) > > Does anyone know what this does and how I can reproduce the select in > PostgreSQL? It's an outer join. In Postgres it'd be SELECT o.* from one left outer join two using ( key ) but it's new in 7.1 . Richard