Re: postgres - CASE evaluates subexpression that is not needed to determine the result

Kamenoqd Zelen <kamenoqd@gmail.com> writes:
> I have the following 3 examples of case expressions in postgres, which I
> would expect to evaluate in the same way. However the first and the third
> give ERROR: invalid input syntax for integer: "2017.7". The second one
> returns true. Why is the difference?

Constant subexpressions get folded regardless of location.

            regards, tom lane