Re: Costs estimates for (inline SQL) functions ... - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Costs estimates for (inline SQL) functions ...
Date
Msg-id 1156139773.9480.21.camel@localhost
Whole thread Raw
In response to Costs estimates for (inline SQL) functions ...  (Hans-Juergen Schoenig <postgres@cybertec.at>)
Responses Re: Costs estimates for (inline SQL) functions ...
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: Costs estimates for (inline SQL) functions ...
Next
From: Fujii Masao
Date:
Subject: Re: Replication