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

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Costs estimates for (inline SQL) functions ...
Дата
Msg-id 1156139773.9480.21.camel@localhost
обсуждение исходный текст
Ответ на Costs estimates for (inline SQL) functions ...  (Hans-Juergen Schoenig <postgres@cybertec.at>)
Ответы Re: Costs estimates for (inline SQL) functions ...
Список 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 по дате отправления:

Предыдущее
От: Hans-Juergen Schoenig
Дата:
Сообщение: Costs estimates for (inline SQL) functions ...
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Replication