2006/3/19, Svenne Krap <[EMAIL PROTECTED]>:

> 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

Reply via email to