postgres.git / summary / log / commit / refs
commit d53f7cf11658a3252a6fddf308b992b751379f09
Author: Noah Misch <noah@leadboat.com>
Date: Wed Jun 26 23:51:56 2013 +0000
First released in: 9.4.0, 8.4.18, 9.0.14, 9.1.10, 9.2.5, 9.3.0
Document effect of constant folding on CASE.
Back-patch to all supported versions.
Laurenz Albe
doc/src/sgml/func.sgml | 10 ++++++++++
1 file changed, 10 insertions(+)
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 4c5af4b83c8..8cf53855616 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -10563,6 +10563,16 @@ SELECT a,
SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END;
</programlisting>
</para>
+
+ <note>
+ <para>
+ As described in <xref linkend="xfunc-volatility">, functions and
+ operators marked <literal>IMMUTABLE</literal> can be evaluated when
+ the query is planned rather than when it is executed. This means
+ that constant parts of a subexpression that is not evaluated during
+ query execution might still be evaluated during query planning.
+ </para>
+ </note>
</sect2>
<sect2 id="functions-coalesce-nvl-ifnull">
[parent: 5f538ad004aa]