2007/5/31, Vincenzo Romano <[EMAIL PROTECTED]>:
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
