Hi,
I think I've found a pretty reliable way to crash my pgsql backend.
To reproduce (at least on 6.5.1.) enter:
select * from pg_attribute where (case when 1=1 then (attname='testname') else (0=1) end);
I chose the pg_attribute table because it exists on every system :),
while the query does not look to make too much sense I orignally
wanted to implement different WHERE conditions based on another
condition (here just 1=1 :-)
Regards,
--
Jens Glaser Am Holderstrauch 13, 36041 Fulda, 0661/9429507 jens@jens.de