From: Devin Atencio <devin@burgoyne.com>
To: pgsql-sql@postgresql.org
Subject: Datatype Inet and Searching
Date: Tue, 2 Dec 2003 16:50:28 -0700
Message-ID: <200312022353.hB2Nrnji023049@mail.burgoyne.com> (raw)
Dear Users,
I am very new to using the inet data type and I have a database with a list
of CIDRs in it
And I was hoping to be able to do some kind of select statement that would
pull the record
That the IP given is located in for example. If in my database I have a
record like:
Id cidr name
1 10.0.0.0/30 user1
2 10.0.0.4/30 user2
3 10.0.0.8/30 user3
I was hoping to be able to do something like:
Select * from mytable where cidr <<='10.0.0.5'
And the database would return only record 2 since it knows that 10.0.0.5 is
contained only within record 2.
I can't seem to figure out the correct syntax to make this type of query
happen. Any help would greatly
Be appreciated.
Devin Atencio
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: devin@burgoyne.com
Subject: Re: Datatype Inet and Searching
In-Reply-To: <200312022353.hB2Nrnji023049@mail.burgoyne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox