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