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

Jim C. Nasby wrote:
> 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...

Done.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +