Re: BUG #7575: "between" does not work properly with inet/cidr addresses

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Mr Dash Four <mr(dot)dash(dot)four(at)googlemail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7575: "between" does not work properly with inet/cidr addresses
Date: 2012-10-12 08:31:28
Message-ID: m2391k2isf.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Mr Dash Four <mr(dot)dash(dot)four(at)googlemail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mr Dash Four 2012-10-12 11:26:46 Re: BUG #7575: "between" does not work properly with inet/cidr addresses
Previous Message John R Pierce 2012-10-12 06:49:08 Re: BUG #7596: Problem with /etc/init.d/postgresql.9.x file