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)

Oh, and also a SELECT VERSION(); would be nice.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco