Re: How to call table returning function with other table - Mailing list pgsql-sql

2006/3/19, Svenne Krap <svenne@krap.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