Re: bigint to ipaddress

There is no such thing as converting a bigint into an text ip address,
unless you make it xD Google for "postgres INET_ATON" (INET_ATON is mysql's
ip-to-int)

However, there are datatypes in postgres which allow you to work directly
with ips and networks:
http://www.postgresql.org/docs/7.4/interactive/datatype-net-types.html

Greetings ;)

On Sun, Aug 9, 2009 at 05:44, Mindaugas G. <mindaugas(at)biovela(dot)lt> wrote:

> Hi,
>
> googling few days with no success,
> 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?
>
>

--
Mailed by:
UnReAl4U - unreal4u
ICQ #: 54472056
www: http://www.chw.net/