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

Поиск
Список
Период
Сортировка
От Christopher Audley
Тема Oracle to PostgreSQL help: What is (+) in Oracle select?
Дата
Msg-id 3AB29A4A.8030303@jhu.edu
обсуждение исходный текст
Ответы Re: Oracle to PostgreSQL help: What is (+) in Oracle select?
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: update table sequence
Следующее
От: Michael Davis
Дата:
Сообщение: RE: Oracle to PostgreSQL help: What is (+) in Oracle select?