X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 19C6652864 for ; Mon, 6 Jun 2005 20:17:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27037-10 for ; Mon, 6 Jun 2005 23:16:54 +0000 (GMT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id 8FCB05285B for ; Mon, 6 Jun 2005 20:16:52 -0300 (ADT) Received: from tschibtschibojtschitsch (dsl-082-082-193-099.arcor-ip.net [82.82.193.99]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id j56NGpT29882; Tue, 7 Jun 2005 01:16:51 +0200 Subject: Re: SQL equivalent to nested loop From: Markus Bertheau To: =?ISO-8859-1?Q?K=D6PFERL?= Robert Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-Iu8DzUYezAwntYpE9P8s" Date: Tue, 07 Jun 2005 01:16:52 +0200 Message-Id: <1118099812.7415.2.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/89 X-Sequence-Number: 21690 --=-Iu8DzUYezAwntYpE9P8s Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Dnia 06-06-2005, pon o godzinie 20:08 +0200, K=C3=96PFERL Robert napisa=C5= =82(a): > This is basicly a Join, a cross table >=20 > i.e. >=20 > select b.w from table a, table b where ... You'd hope that. The problem is that you don't have the tables and afterwards specify the join condition, but in specifying the tables (=3Dcalling the function) you have the join condition already. I can't figure out the right syntax. What are you proposing? SELECT * from f(4, 'foo') as b, f(b.int, 'bar')? oocms=3D# select * from object_get_list_of_reference_property(311, 'Themen') as b, object_get_list_of_reference_property(b.object_id, 'Objekte'); ERROR: ?????????????? ????????? ?? FROM ?? ????? ????????? ?? ?????? ????????? ?? ??? ?? ?????? ??????? I can't get an english error message atm :/, but that doesn't work. Markus --=20 Markus Bertheau --=-Iu8DzUYezAwntYpE9P8s Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBCpNlk2RUnMPztcykRAvXwAKCR9bDyOD8HbTzNNb9KL937oXFFhQCeP09Q SCNl/9TkSqkUSM8cd4Aqybo= =VFIt -----END PGP SIGNATURE----- --=-Iu8DzUYezAwntYpE9P8s--