postgres.git / summary / log / commit / refs
commit ca1700130be70d6b2c5dfcabbf0717036bf6bded
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 29576d7ca32..36ec0691b5d 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -9290,6 +9290,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>
[parent: f44eedc3f0f3]