Skip site navigation (1) Skip section navigation (2)

Re: cacheable stored functions?

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: cacheable stored functions?
Date: 2004-02-20 15:59:39
Message-ID: 40362EEB.9050103@klaster.net (view raw or flat)
Thread:
Lists: pgsql-performance
Dnia 2004-02-20 16:35, Użytkownik Bill Moran napisał:
> Can anyone say whether this is a supported feature in plpgsql, and is
> safe to use?  Is it simply undocumented, or am I just looking in the
> wrong place?

"iscachable" is only for backward compatibility - it's changed now to 
"IMMUTABLE"


You can read more about immutable, stable and volatile functions in 
Postgresql documentation - chapter SQL Commands/CREATE FUNCTION.

Regards,
Tomasz Myrta

In response to

pgsql-performance by date

Next:From: Richard HuxtonDate: 2004-02-20 16:01:28
Subject: Re: cacheable stored functions?
Previous:From: Stephan SzaboDate: 2004-02-20 15:47:33
Subject: Re: cacheable stored functions?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group