"D. Dante Lorenso" <dante@xxxxxxxxxxx> writes: > Tom Lane wrote: >> I can't reproduce any such problem in 8.2 branch tip, and a desultory >> scan of the CVS history back to 8.2.4 doesn't turn up any obviously >> related patches. Please provide a self-contained test case for what >> you're seeing. > I think this is a problem with the BYTEA type. So far as I can tell, it's a problem with having declared the function STABLE. You want IMMUTABLE if you're hoping to have this usage folded to a constant. regards, tom lane