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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2004-02-20 16:01:28 Re: cacheable stored functions?
Previous Message Stephan Szabo 2004-02-20 15:47:33 Re: cacheable stored functions?