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

On Sun, Aug 20, 2006 at 10:56:12PM -0700, Neil Conway wrote:
> 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).

We should put this on the project's TODO...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461