Re: trying to write a many-to-many type function.

Eric Davies <Eric(at)barrodale(dot)com> 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