Received: from mta6.srv.hcvlny.cv.net (mta6.srv.hcvlny.cv.net [167.206.5.17]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2GMvPx73824 for ; Fri, 16 Mar 2001 17:57:25 -0500 (EST) (envelope-from Christopher.D.Audley@jhu.edu) Received: from jhu.edu (ool-18bfe44e.dyn.optonline.net [24.191.228.78]) by mta6.srv.hcvlny.cv.net (iPlanet Messaging Server 5.0 Patch 2 (built Dec 14 2000)) with ESMTP id <0GAB00G2VBRN5Y@mta6.srv.hcvlny.cv.net> for pgsql-sql@postgresql.org; Fri, 16 Mar 2001 17:57:23 -0500 (EST) Date: Fri, 16 Mar 2001 17:57:14 -0500 From: Christopher Audley Subject: Oracle to PostgreSQL help: What is (+) in Oracle select? To: pgsql-sql@postgresql.org Message-id: <3AB29A4A.8030303@jhu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en User-Agent: Mozilla/5.0 (X11; U; Linux 2.2.17-14 i686; en-US; m18) Gecko/20001107 Netscape6/6.0 X-Archive-Number: 200103/337 X-Sequence-Number: 2001 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? Thanks Chris