Re: bigint to ip

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: "Mindaugas G(dot)" <mindaugas(at)biovela(dot)lt>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: bigint to ip
Date: 2009-08-16 19:33:20
Message-ID: m23a7r5zb3.fsf@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mindaugas G." <mindaugas(at)biovela(dot)lt> writes:
> for example I have db with ip_src etc ant its data type bigint,
> how must look select query what I can see ip address (int) instead of
> bigint?

You might be interrested into the ip4r project:
http://pgfoundry.org/projects/ip4r/

Regards,
--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andre Lopes 2009-08-16 20:10:20 plpgsql function to validate e-mail
Previous Message Scott Ribe 2009-08-16 19:08:15 Re: Generating random unique alphanumeric IDs