From: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: SQL equivalent to nested loop |
Date: | 2005-06-07 08:58:52 |
Message-ID: | ED4E30DD9C43D5118DFB00508BBBA76EB16745@neptun.sonorys.at |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Instead of tablenames just use functions (tablefunctions)
like my example
select a."Id", a."Code" from "GetLanguages"() a, "GetLanguages"() b
"2","en"
"2","en"
"1","de"
"1","de"
|-----Original Message-----
|From: Markus Bertheau [mailto:twanger(at)bluetwanger(dot)de]
|Sent: Dienstag, 07. Juni 2005 01:17
|To: KÖPFERL Robert
|Cc: pgsql-sql(at)postgresql(dot)org
|Subject: RE: [SQL] SQL equivalent to nested loop
|
|
|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>
|
From | Date | Subject | |
---|---|---|---|
Next Message | KÖPFERL Robert | 2005-06-07 09:26:31 | Can we stop that? |
Previous Message | Achilleus Mantzios | 2005-06-07 08:29:05 | Re: to listadmin |