Re: immutable function calling stable function - Mailing list pgsql-sql

From Tom Lane
Subject Re: immutable function calling stable function
Date
Msg-id 8578.1090421134@sss.pgh.pa.us
Whole thread Raw
In response to immutable function calling stable function  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Markus Bertheau <twanger@bluetwanger.de> writes:
> shouldn't it be illegal for an immutable function to call a stable one?

No, because that's the standard hack for getting around it when you wish
to call a stable function in what you know to be a "safe" way.  If you
look in the archives you'll find cases where creating an immutable
wrapper function was the recommended solution to performance problems.
        regards, tom lane


pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: date_format in postresql
Next
From: Geoff Richards
Date:
Subject: MySQL-style "create temporary table foo select ..."