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 4A78AD1B4E8 for ; Tue, 30 Sep 2003 05:19:22 +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 50436-10 for ; Tue, 30 Sep 2003 02:18:52 -0300 (ADT) Received: from rock.spider.ru (rock.spider.ru [62.183.34.226]) by svr1.postgresql.org (Postfix) with ESMTP id 1F92BD1B524 for ; Tue, 30 Sep 2003 02:18:51 -0300 (ADT) Received: from rock (localhost [127.0.0.1]) by rock (Postfix) with SMTP id 00B9491246 for ; Tue, 30 Sep 2003 09:18:50 +0400 (MSD) Received: from sad.localnet.ru (sad.localnet.ru [10.0.0.33]) by rock.spider.ru (Postfix) with ESMTP id BA29891234 for ; Tue, 30 Sep 2003 09:18:49 +0400 (MSD) Content-Type: text/plain; charset="iso-8859-1" From: sad Organization: IT To: pgsql-sql@postgresql.org Subject: Re: SQL Syntax problem Date: Tue, 30 Sep 2003 09:22:06 +0400 User-Agent: KMail/1.4.3 References: <200309281443.09936.bedo7@gmx.net> In-Reply-To: <200309281443.09936.bedo7@gmx.net> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200309300922.06402.sad@bankir.ru> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/418 X-Sequence-Number: 15396 > 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 =3D a.awk_id and b.bet_id(+) =3D a.bet_idemp > and a.ask_id =3D f.ask_id(+) This (+) means JOIN=20 e.g. (+)-marked equations used as a joining condition To translate it to PGSQL syntax simply remove (+) :-)=20 (only one thing i forgot: isn't it OUTER JOIN?...)