Re: Options to rowwise persist result of stable/immutable function with RECORD result

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Options to rowwise persist result of stable/immutable function with RECORD result
Дата
Msg-id CAKFQuwbu7cQagO1V6nU2WAPbpFfsDYEAqKNr+aK2+ahdOkTZZw@mail.gmail.com
обсуждение исходный текст
Ответ на Options to rowwise persist result of stable/immutable function with RECORD result  (Eske Rahn <eske@septima.dk>)
Ответы Re: Options to rowwise persist result of stable/immutable function with RECORD result  (Eske Rahn <eske@septima.dk>)
Список pgsql-hackers
On Tuesday, March 21, 2023, Eske Rahn <eske@septima.dk> wrote:
Hi,

I have noticed a rather odd behaviour that is not strictly a bug, but is unexpected.

It is when a immutable (or stable) PG function is returning results in a record structure a select on these calls the function repeatedly for each element in the output record.

The LATERAL join modifier exists to handle this kind of situation.

David J.
 

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: HOT chain validation in verify_heapam()
Следующее
От: Andres Freund
Дата:
Сообщение: Re: HOT chain validation in verify_heapam()