Re: [PERFORM] [GENERAL] Index use in BETWEEN statement...

2005-09-26 Thread Tom Lane
"Cristian Prieto" <[EMAIL PROTECTED]> writes: > mydb=# explain analyze select locid from geoip_block where > '216.230.158.50'::inet between start_block and end_block; > As you see it still using a sequential scan in the table and ignores the > index, any other suggestion? That two-column index is

Re: [PERFORM] [GENERAL] Index use in BETWEEN statement...

2005-09-26 Thread Cristian Prieto
mydb=# explain analyze select locid from geoip_block where '216.230.158.50'::inet between start_block and end_block; QUERY PLAN ---