SQL Syntax problem

From: Doris Bernloehr <bedo7(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL Syntax problem
Date: 2003-09-28 12:43:09
Message-ID: 200309281443.09936.bedo7@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-09-28 16:02:43 Re: [SQL] plpgsql doesn't coerce boolean expressions to
Previous Message Josh Berkus 2003-09-28 05:29:50 Re: Mystery function error