Re: Costs estimates for (inline SQL) functions ...

On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote:
> CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
>        SELECT relname::text, relpages::int4
>                FROM pg_class;
> $$ LANGUAGE SQL IMMUTABLE;

> As far as i remember inlined SQL code has been implemented into the 
> planner around 7.4.

We don't currently inline set-returning functions. This has been on my
TODO list for a while, but I haven't found the cycles for it yet (of
course, if anyone's interested in fixing this, don't let my idleness
stop you -- I would think it shouldn't be too difficult).

-Neil