Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: stable functions
- From: "Filip Rembiałkowski" <plk(dot)zuber(at)gmail(dot)com>
- To: "Vincenzo Romano" <vincenzo(dot)romano(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: stable functions
- Date: Thu, 31 May 2007 13:23:36 +0200
2007/5/31, Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)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
- Follow-Ups:
- Re: stable functions
- From: Vincenzo Romano
- Re: stable functions
- References:
- stable functions
- From: Vincenzo Romano
- stable functions
- Prev by Date: warm standby server stops doing checkpoints after a while
- Next by Date: TSEARCH2: disable stemming in indexes and triggers
- Previous by thread: stable functions
- Next by thread: Re: stable functions
- Indexes: