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:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 3:57 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
