Re: Question about a CIDR based query

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: siganos(at)gmail(dot)com (George Siganos), pgsql-sql(at)postgresql(dot)org
Subject: Re: Question about a CIDR based query
Date: 2004-06-29 23:52:24
Message-ID: 200406291652.24900.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2004-06-30 03:49:06 Re: Question about a CIDR based query
Previous Message Stephan Szabo 2004-06-29 21:25:18 Re: OUTER JOIN problem