[GENERAL] simple case syntax oddity in 8.0.0

[Vlad]

Hi there:

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

test=> select case when 0=0 then null else 1/0 end as test;
 test
------

(1 row)

test=>

Postgresql 7.4.5, FreeBSD 5.3

test => select case 0 when 0 then null else 1/0 end as test;
 test
------

(1 row)

test => select case when 0=0 then null else 1/0 end as test;
 test
------



-- 
Vlad

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq