From: Markus Bertheau <twanger@bluetwanger.de>
To: KÖPFERL Robert <robert.koepferl@sonorys.at>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL equivalent to nested loop
Date: Tue, 07 Jun 2005 01:16:52 +0200
Message-ID: <1118099812.7415.2.camel@localhost.localdomain> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB16744@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB16744@neptun.sonorys.at>
Dnia 06-06-2005, pon o godzinie 20:08 +0200, KÖPFERL Robert napisał(a):
> This is basicly a Join, a cross table
>
> i.e.
>
> 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
(=calling 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=# 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
--
Markus Bertheau <twanger@bluetwanger.de>
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: twanger@bluetwanger.de, robert.koepferl@sonorys.at
Subject: Re: SQL equivalent to nested loop
In-Reply-To: <1118099812.7415.2.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox