Re: Costs estimates for (inline SQL) functions ...
От | Bruce Momjian |
---|---|
Тема | Re: Costs estimates for (inline SQL) functions ... |
Дата | |
Msg-id | 200608241638.k7OGcX329525@momjian.us обсуждение исходный текст |
Ответ на | Re: Costs estimates for (inline SQL) functions ... ("Jim C. Nasby" <jnasby@pervasive.com>) |
Список | 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 по дате отправления: