X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 369D6D1B508
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 28 Sep 2003 12:43:43 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 47628-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 28 Sep 2003 09:43:15 -0300 (ADT)
Received: from dialin-212-144-135-251.arcor-ip.net
	(dialin-212-144-135-251.arcor-ip.net [212.144.135.251])
	by svr1.postgresql.org (Postfix) with ESMTP id 17018D1B507
	for <pgsql-sql@postgresql.org>; Sun, 28 Sep 2003 09:43:11 -0300 (ADT)
Received: from localhost ([127.0.0.1] helo=beluga ident=doris)
	by dialin-212-144-135-251.arcor-ip.net with esmtp (Exim 3.35 #1
	(Debian)) id 1A3atM-0001UD-00
	for <pgsql-sql@postgresql.org>; Sun, 28 Sep 2003 14:43:12 +0200
Content-Type: text/plain;
  charset="us-ascii"
From: Doris Bernloehr <bedo7@gmx.net>
To: pgsql-sql@postgresql.org
Subject: SQL Syntax problem
Date: Sun, 28 Sep 2003 14:43:09 +0200
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200309281443.09936.bedo7@gmx.net>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/392
X-Sequence-Number: 15370

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