Re: SQL equivalent to nested loop

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL equivalent to nested loop
Date: 2005-06-06 23:16:52
Message-ID: 1118099812.7415.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)bluetwanger(dot)de>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2005-06-07 01:24:52 Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp.
Previous Message KÖPFERL Robert 2005-06-06 18:08:07 Re: SQL equivalent to nested loop