Обсуждение: How can you tell if a function is immutable from psql?

Поиск
Список
Период
Сортировка

How can you tell if a function is immutable from psql?

От
"Michael Nolan"
Дата:
Am I just missing it or is there no way to tell if a function is noted as immutable from the \df or \df+ output in psql?
--
Mike Nolan

Re: How can you tell if a function is immutable from psql?

От
Michael Fuhr
Дата:
On Wed, Feb 21, 2007 at 09:20:19AM -0600, Michael Nolan wrote:
> Am I just missing it or is there no way to tell if a function is noted as
> immutable from the \df or \df+ output in psql?

Apparently not.  You could examine pg_proc.provolatile.

http://www.postgresql.org/docs/8.2/interactive/catalog-pg-proc.html

--
Michael Fuhr