We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent f44eedc commit ca17001Copy full SHA for ca17001
doc/src/sgml/func.sgml
@@ -9290,6 +9290,16 @@ SELECT a,
9290
SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END;
9291
</programlisting>
9292
</para>
9293
+
9294
+ <note>
9295
+ <para>
9296
+ As described in <xref linkend="xfunc-volatility">, functions and
9297
+ operators marked <literal>IMMUTABLE</literal> can be evaluated when
9298
+ the query is planned rather than when it is executed. This means
9299
+ that constant parts of a subexpression that is not evaluated during
9300
+ query execution might still be evaluated during query planning.
9301
+ </para>
9302
+ </note>
9303
</sect2>
9304
9305
<sect2>
0 commit comments