Re: [GENERAL] bigint to ip

2009-08-16 Thread Dimitri Fontaine
"Mindaugas G." 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 -- Sent via pgsql-ge

Re: [GENERAL] bigint to ip

2009-08-14 Thread Jasen Betts
On 2009-08-09, Mindaugas G. 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) re

[GENERAL] bigint to ip

2009-08-09 Thread Mindaugas G.
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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http