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’
select * from mytable where cider >>= '10.0.0.5'
The operation a >>= b mean:
a contain or is equal b.
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
