Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f2GNNfx77745 for ; Fri, 16 Mar 2001 18:23:41 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 22801 invoked by uid 89); 16 Mar 2001 23:23:39 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 16 Mar 2001 23:23:39 -0000 Received: by localhost with Microsoft MAPI; Fri, 16 Mar 2001 16:23:34 -0700 Message-ID: <01C0AE35.727035B0.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Christopher Audley'" , "pgsql-sql@postgresql.org" Subject: RE: Oracle to PostgreSQL help: What is (+) in Oracle select? Date: Fri, 16 Mar 2001 16:23:31 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/338 X-Sequence-Number: 2002 This is Oracle's syntax for an outer join. Try this in PostgreSQL SELECT o.* from one o LEFT JOIN two t ON o.key = t.key; -----Original Message----- From: Christopher Audley [SMTP:Christopher.D.Audley@jhu.edu] Sent: Friday, March 16, 2001 3:57 PM To: pgsql-sql@postgresql.org Subject: Oracle to PostgreSQL help: What is (+) in Oracle select? 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly