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

From Bruce Momjian
Subject Re: Costs estimates for (inline SQL) functions ...
Date
Msg-id 200608241638.k7OGcX329525@momjian.us
Whole thread Raw
In response to Re: Costs estimates for (inline SQL) functions ...  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
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@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: tsvector/tsearch equality and/or portability issue issue ?
Next
From: Tom Lane
Date:
Subject: Re: Tricky bugs in concurrent index build