how much volatile is a function

Поиск
Список
Период
Сортировка
От Anibal David Acosta
Тема how much volatile is a function
Дата
Msg-id 001501cd605d$999e0ef0$ccda2cd0$@devshock.com
обсуждение исходный текст
Ответы Re: how much volatile is a function  ("David Johnston" <polobo@yahoo.com>)
Re: how much volatile is a function  (Sergey Konoplev <sergey.konoplev@postgresql-consulting.com>)
Список pgsql-general

I have a table, this table are rarely changed (added or deleted).

My function receive parameters and do a query to the table.

 

Does postgres re run the query on each function call, or has some kind of “flag” indicating that table as not been changed and return cached result of a previous call if the call has same parameters?

 

Thanks!

 

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

Предыдущее
От: Bartosz Dmytrak
Дата:
Сообщение: Re: PostgreSQL limitations question
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: how much volatile is a function