Re: stable functions

2007/5/31, Vincenzo Romano <vincenzo.romano@gmail.com>:
> Hi all.
>
> Can functions whose effect is to create functions (yep!)
> be labelled as "stable"?

According to the docs, no.

"STABLE indicates that the function cannot modify the database (...)
any function that has side-effects must be classified volatile"

http://www.postgresql.org/docs/8.2/static/sql-createfunction.html

If you labeled creatorfunc(param) as stable, ant then issued "SELECT
creatorfunc(sometable.param) FROM sometable", there is a theoretical
risk that creatorfunc would be called only _once_ for each distinct
value of param.




--
Filip Rembiałkowski