Oracle to PostgreSQL help: What is (+) in Oracle select?

From: Christopher Audley <Christopher(dot)D(dot)Audley(at)jhu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Oracle to PostgreSQL help: What is (+) in Oracle select?
Date: 2001-03-16 22:57:14
Message-ID: 3AB29A4A.8030303@jhu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Davis 2001-03-16 23:23:31 RE: Oracle to PostgreSQL help: What is (+) in Oracle select?
Previous Message Tom Lane 2001-03-16 20:09:50 Re: update table sequence