bigint to ip

On 2009-08-09, Mindaugas G. <mindaugas@biovela.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?

dunno if this will help.

create function bigint_to_inet(bigint) returns inet as $$
select (($1>>24&255)||'.'||($1>>16&255)||'.'||($1>>8&255)||'.'||($1>>0&255))::inet
$$ immutable language sql;

"Mindaugas G." <mindaugas@biovela.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