Yes... Described in "38.4. Expressions"...
To be more exact, it's neither bug nor feature. To evaluate an integral CASE
... END expression, the 'main' SQL engine needs all its parameters passed to
exist at least. But the evaluation rules (I think) remain the same both in
separate SQL queries and server procedures.
Thanks for reply,
In response to
pgsql-bugs by date
|Next:||From: Brian Ceccarelli||Date: 2009-08-20 20:24:53|
|Subject: BUG #4999: select 'a' < 'A' is true, but should be false . . .|
|Previous:||From: Pavel Stehule||Date: 2009-08-20 09:42:06|
|Subject: Re: BUG #4997: Expression evaluation rules|