Re: How to call table returning function with other table

Поиск
Список
Период
Сортировка
От Svenne Krap
Тема Re: How to call table returning function with other table
Дата
Msg-id 441D5F05.4060107@krap.dk
обсуждение исходный текст
Ответ на Re: How to call table returning function with other table  ("Markus Bertheau" <mbertheau.pg@googlemail.com>)
Список pgsql-sql
Perfect. Thanks.<br /><br /> Svenne<br /><br /> Markus Bertheau wrote: <blockquote
cite="mid684362e10603190532p1903fca8p@mail.gmail.com"type="cite"><pre wrap="">2006/3/19, Svenne Krap <a
class="moz-txt-link-rfc2396E"href="mailto:svenne@krap.dk"><svenne@krap.dk></a>:
 
 </pre><blockquote type="cite"><pre wrap="">So it is something like "select xxx(id) from othertable where otherwhere
= 't'" except that it mangles the columns into an array. I have tried to
move the function-call into the fromlist (as it is usually done) but I
seem unsuccessful in getting the ID's into it.   </pre></blockquote><pre wrap="">
You have to use something like SELECT (xxx(id)).* FROM othertable
WHERE otherwhere = 't', I believe.

Markus Bertheau

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to      choose an index scan if your joining column's
datatypesdo not      match
 
 </pre></blockquote><br />

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Markus Bertheau"
Дата:
Сообщение: Re: How to call table returning function with other table
Следующее
От: "Bath, David"
Дата:
Сообщение: Lead and tail quotes with \pset fieldsep