Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Neil Conway wrote: > >> If a function's return value for a particular set of arguments could > >> change within a single table scan, the function is volatile -- ISTM > >> xslt_process() clearly falls within that definition. > > > My thought was that a web page lookup is going to be a very expensive > > operation, so you would not want it to requery inside a transaction. > > > It is not like random() where you want it to be re-called and it is > > inexpensive. > > "It's too expensive" is not a valid rationale for claiming that > something is stable when it is not. In any case, you have fallen into > the all too common trap of supposing that these labels have something > to do with caching function results. Calling it stable is not going > to improve performance, only create a risk of wrong answers.
Well, should be marked as VOLATILE? A web lookup? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings