Calling the same function more than once with the same arguments

Поиск
Список
Период
Сортировка
От Clodoaldo Pinto
Тема Calling the same function more than once with the same arguments
Дата
Msg-id a595de7a0604191429u7c84765dv81fd542c2ed812fc@mail.gmail.com
обсуждение исходный текст
Ответы Re: Calling the same function more than once with the same  (Ben <bench@silentmedia.com>)
Re: Calling the same function more than once with the same arguments  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm building a function caller() in which a certain function called()
will be called many times in from clauses with the same arguments and
I'm wondering if is there a performance penalty for that or if the sql
engine is smart enough to call called() only once.

I tried to substitute called() in the from clauses for a temporary
table created first in caller() but it refuses to build caller() with
the message "ERROR:  relation "temp_table_name" does not exist". It
does not exist in build time but it will exist in run time.

Regards, Clodoaldo Pinto

В списке pgsql-general по дате отправления:

Предыдущее
От: Mauricio Mantilla
Дата:
Сообщение: Re: help plpgsql, cursors, fetch into
Следующее
От: Ben
Дата:
Сообщение: Re: Calling the same function more than once with the same