Eric Davies <Eric@xxxxxxxxxxxxx> writes: > As far as I can see, you can't write a set returning function that > takes a set as input, as in > select getMetaData( select * from mytable); > Is a function of the type I'm trying to write even possible in PostgreSQL? I don't think it's possible at the moment :-(. We've speculated about ways to relax the restriction that a function in FROM can't take any non-constant arguments. It appears that adding SQL99's LATERAL and/or UNNEST features might do it ... I've had a hard time finding any very clear explanation of their semantics, though, so I'm not entirely sure. regards, tom lane
