On 09/18/2014 01:10 PM, Hannu Krosing wrote:
> One possible syntax would be extending WITH to somehow enable on-spot
> functions in addition to on-spot views
>
> WITH FUNCTION myfunc(...) RETURNS TABLE(...) LANGUAGE plpgsql AS $$
> ...
> $$
> SELECT f.*
> FROM myfunc(x,y,z);
Oh! Awesome!
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com