Neil Conway <[EMAIL PROTECTED]> writes: > This works, but it seems overly verbose. It occurred to me that we could > easily add a new PL/PgSQL statement that evaluates a set-returning > expression and adds *all* the resulting rows to the function's result > set. For example:
I think we've got something isomorphic to that in the patch queue already --- take a look at Pavel's "table function" patch. It's in need of cleanup but I think it will make it in. regards, tom lane ---------------------------(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