Re: BUG #7575: "between" does not work properly with inet/cidr addresses - Mailing list pgsql-bugs

From Dimitri Fontaine
Subject Re: BUG #7575: "between" does not work properly with inet/cidr addresses
Date
Msg-id m2391k2isf.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: BUG #7575: "between" does not work properly with inet/cidr addresses  (Mr Dash Four <mr.dash.four@googlemail.com>)
Responses Re: BUG #7575: "between" does not work properly with inet/cidr addresses  (Mr Dash Four <mr.dash.four@googlemail.com>)
List pgsql-bugs
Mr Dash Four <mr.dash.four@googlemail.com> writes:
> That isn't possible in my case, because on the right side I have IP ranges
> (from-to) and currently there isn't a PostgreSQL function which converts IP
> ranges to cidr/inet, but even if there was such function available, this may
> produce more than one cidr/inet ranges, so it won't be of much use.

Have you tried using the ip4r extension yet?

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #7596: Problem with /etc/init.d/postgresql.9.x file
Next
From: Mr Dash Four
Date:
Subject: Re: BUG #7575: "between" does not work properly with inet/cidr addresses