Re: [BUGS] BUG #4800: constraint_exclusion could be smarter with bool conversion

2009-05-08 Thread Tom Lane
"Alex" writes: > I wish constraint_exclusion to be smarter with bool conversion so that > 'select * from foo where (mask&5)::bool' can be faster; Don't hold your breath. It's tough enough deriving conclusions from ordinary btree-indexable comparison operators. regards, t

[BUGS] BUG #4800: constraint_exclusion could be smarter with bool conversion

2009-05-08 Thread Alex
The following bug has been logged online: Bug reference: 4800 Logged by: Alex Email address: a...@xdcom.org PostgreSQL version: 8.3.6 Operating system: rhel5 Description:constraint_exclusion could be smarter with bool conversion Details: Table "public.foo1" Column