• Tom Lane's avatar
    Improve documentation about CASE and constant subexpressions. · 5b516835
    Tom Lane authored
    The possibility that constant subexpressions of a CASE might be evaluated
    at planning time was touched on in 9.17.1 (CASE expressions), but it really
    ought to be explained in 4.2.14 (Expression Evaluation Rules) which is the
    primary discussion of such topics.  Add text and an example there, and
    revise the <note> under CASE to link there.
    
    Back-patch to all supported branches, since it's acted like this for a
    long time (though 9.2+ is probably worse because of its more aggressive
    use of constant-folding via replanning of nominally-prepared statements).
    Pre-9.4, also back-patch text added in commit 0ce627d4 about CASE versus
    aggregate functions.
    
    Tom Lane and David Johnston, per discussion of bug #12273.
    5b516835
func.sgml 620 KB