Vlad <[EMAIL PROTECTED]> writes:
> Postgresql 8.0.0, FreeBSD 5.3
> test=> select case 0 when 0 then null else 1/0 end as test;
> ERROR: division by zero
Hmm ... unexpected side effect of the change to avoid evaluating the
test-expression multiple times. This used to be transformed into
this at parse time:
select case when 0=0 then null else 1/0 end as test;
and then constant-folding would do the right thing.
But now it's transformed into something sort of like
select (let x = 0 in case when x=0 then ...)
and the when-clause therefore appears not to be constant. I think
I can fix this for 8.0.2, though.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
