Postgres Pro
Downloads
Home   >   mailing lists

Re: How can you tell if a function is immutable from psql? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: How can you tell if a function is immutable from psql?
Date
Msg-id 20070222021057.GA59405@winnie.fuhr.org
Whole thread Raw
In response to How can you tell if a function is immutable from psql?  ("Michael Nolan" <htfoot@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: postgresql vs mysql
Next
From: Richard Broersma Jr
Date:
Subject: Re: postgresql vs mysql