Re: [SQL] Does optimizer know about 'constant' expressions?

[Tom Lane]

Philip Warner <[EMAIL PROTECTED]> writes:
> It seems that the optimizer does not know about (or calculate values of)
> constant expressions when determining strategy.

Datetime calculations are not considered constant-foldable.  See
prior discussions, eg thread "Constant propagation and similar issues"
in pghackers on 11-Sep.

                        regards, tom lane