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  (David Johnston <polobo@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: psql --command option ignores --variable's
Следующее
От: David Johnston
Дата:
Сообщение: Re: STABLE marker on functions with single select