Re: Question about a CIDR based query - Mailing list pgsql-sql

George,

Um, no, I need an EXPLAIN ANALYZE, not just an EXPLAIN.   Thanks.

> June_03=# explain select * from tmp where route >>='62.1.1.0/24';
>                            QUERY PLAN                           
> ----------------------------------------------------------------
>  Seq Scan on tmp  (cost=0.00..606.60 rows=14544 width=33)
>    Filter: (route >>= '62.1.1.0/24'::cidr)

-- 
-Josh BerkusAglio Database SolutionsSan Francisco