Re: cidr data type question - Mailing list pgsql-general

From Harald Fuchs
Subject Re: cidr data type question
Date
Msg-id pumy35xg76.fsf@srv.protecting.net
Whole thread Raw
In response to cidr data type question  (Vasiliy G Tolstov <v.tolstov@selfip.ru>)
Responses Re: cidr data type question  (Vasiliy G Tolstov <v.tolstov@selfip.ru>)
List pgsql-general
In article <1257149236.3426.9.camel@localhost>,
Vasiliy G Tolstov <v.tolstov@selfip.ru> writes:

> Hello.
> I have table with cidr data type column (table is white/black list of
> networks).

> Does it possible to query - is the some address contains in any cidr
> network in this table? (for all networks in the table do "contains or
> equals"
> http://www.postgresql.org/docs/8.4/interactive/functions-net.html
> )

If you mess with IP addresses, you should have a look at the ip4r
contrib module.  Since I discovered it, I've never looked back at
cidr/inet.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Absolute value of intervals
Next
From: Vasiliy G Tolstov
Date:
Subject: Re: cidr data type question