Index: xfunc.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v retrieving revision 1.109 retrieving revision 1.110 diff -c -c -r1.109 -r1.110 *** xfunc.sgml 29 Nov 2005 01:46:54 -0000 1.109 --- xfunc.sgml 19 Jan 2006 22:52:08 -0000 1.110 *************** *** 1,5 **** --- 1,5 ---- *************** *** 899,911 **** A STABLE function cannot modify the database and is guaranteed to return the same results given the same arguments ! for all calls within a single surrounding query. This category ! allows the optimizer to optimize away multiple calls of the function ! within a single query. In particular, it is safe to use an expression ! containing such a function in an index scan condition. (Since an ! index scan will evaluate the comparison value only once, not once at ! each row, it is not valid to use a VOLATILE function in ! an index scan condition.) --- 899,911 ---- A STABLE function cannot modify the database and is guaranteed to return the same results given the same arguments ! for all rows within a single statement. This category allows the ! optimizer to optimize multiple calls of the function to a single ! call. In particular, it is safe to use an expression containing ! such a function in an index scan condition. (Since an index scan ! will evaluate the comparison value only once, not once at each ! row, it is not valid to use a VOLATILE function in an ! index scan condition.)