Re: set returning function with variable argument - possible? - Mailing list pgsql-general

On Thu, 16 Jun 2011, David Johnston wrote:

> The only way to feed another relation into a function is to place the
> function in the SELECT list.  If you then want to expand the result of the
> function call you alias the function result and then ".*" against it.
>
> WITH feeder AS (
> SELECT f(var) AS result FROM xtable WHERE ...
> )
> SELECT (feeder.result).*
> FROM feeder
> ;

[snip]

Thanks, David, this worked perfectly!  {thanks also to Pavel}

     -Frank