Re: [BUGS] BUG #2196: Useless RECHECK on RTREE index

2006-01-23 Thread Tom Lane
"" <[EMAIL PROTECTED]> writes: > Bitmap Heap Scan on tpoints (cost=1.05..10.46 rows=10 width=8) >Recheck Cond: ('(1,1),(0,0)'::box && box(point((x)::double precision, > (y)::double precision), point((x)::double precision, (y)::double > precision))) >-> Bitmap Index Scan on i_tpoints (co

[BUGS] BUG #2196: Useless RECHECK on RTREE index

2006-01-23 Thread
The following bug has been logged online: Bug reference: 2196 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: alphaev68-dec-osf5.1a Description:Useless RECHECK on RTREE index Details: create table tpoints (x int, y int); CREA