Index: doc/src/sgml/xfunc.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v retrieving revision 1.109 diff -c -c -r1.109 xfunc.sgml *** doc/src/sgml/xfunc.sgml 29 Nov 2005 01:46:54 -0000 1.109 --- doc/src/sgml/xfunc.sgml 19 Jan 2006 22:43:58 -0000 *************** *** 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.)