Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres - CASE evaluates subexpression that is not needed to determine the result - Mailing list pgsql-bugs

From Tom Lane
Subject Re: postgres - CASE evaluates subexpression that is not needed to determine the result
Date
Msg-id 7647.1541429153@sss.pgh.pa.us
Whole thread Raw
In response to postgres - CASE evaluates subexpression that is not needed todetermine the result  (Kamenoqd Zelen <kamenoqd@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: postgres - CASE evaluates subexpression that is not needed todetermine the result
Next
From: Andriy Bartash
Date:
Subject: Update on bug #15468