Re: How to call table returning function with other table

Perfect. Thanks.

Svenne

Markus Bertheau wrote:
> 2006/3/19, Svenne Krap <svenne(at)krap(dot)dk>:
>
>
>> 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.
>>
>
> 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 datatypes do not
> match
>
>