STABLE marker on functions with single select

Поиск
Список
Период
Сортировка
От Laszlo Hornyak
Тема STABLE marker on functions with single select
Дата
Msg-id 1028130796.8334160.1378134720003.JavaMail.root@redhat.com
обсуждение исходный текст
Ответы Re: STABLE marker on functions with single select
Список pgsql-general
hi,

We have some plpgsql functions that return a setof rows from some tables by a single query, they are quite simple. Only
theapplication invokes these functions to query the database, one at a time. e.g. select getFooById(1) 
Do I correctly assume that marking the functions as STABLE will not have any effect on the performance in this case?

Thank you,
Laszlo


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