SQL Syntax problem - Mailing list pgsql-novice

From Doris Bernloehr
Subject SQL Syntax problem
Date
Msg-id 200309281518.02269.bedo7@gmx.net
Whole thread Raw
Responses Re: SQL Syntax problem
Re: SQL Syntax problem
List pgsql-novice
Hello.

I've got a problem in porting the following select statement from Oracle to
Postgres, because of the characters after "b.bet_id" and "f.ask_id" in the
where clause: (+)
I don't know what these characters mean and how I can transform these into
PostgreSql Syntax.


select        ...
from         auswahlkatalog k, anspruchkorrektur a, beteiligter b, v_betkorr f
where           k.awk_id = a.awk_id and b.bet_id(+) = a.bet_idemp
        and a.ask_id = f.ask_id(+);


Hoping for help.
Doris


pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Views and confidentiality
Next
From: Tom Lane
Date:
Subject: Re: SQL Syntax problem