Re: compare integer to inet

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Bill MacArthur <webmaster(at)dhs-club(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: compare integer to inet
Date: 2011-08-21 19:34:58
Message-ID: m2r54ev9r1.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bill MacArthur <webmaster(at)dhs-club(dot)com> writes:
> The reason I ask for this is that we have a dataset that contains
> ranges of IP addresses, associated with countries, where the addresses
> are represented as integers (bigints).

I would then use the ip4r extension, which is very very good for that
kind of things.

http://pgfoundry.org/projects/ip4r/

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2011-08-21 19:38:26 Re: Validate standby against master
Previous Message A J 2011-08-21 15:07:15 Re: Question on Postgres Index internals