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
