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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Michael Nolan <htfoot(at)gmail(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How can you tell if a function is immutable from psql?
Date: 2007-02-22 02:10:57
Message-ID: 20070222021057.GA59405@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2007-02-22 02:38:46 Re: postgresql vs mysql
Previous Message Chris 2007-02-22 02:08:04 Re: postgresql vs mysql