Re: [GENERAL] numeric to ipv6 inet

2013-08-23 Thread Arjen Nienhuis
On Aug 23, 2013 11:58 AM, "Mikhail Puzanov" wrote: > > Hello, > > I need to convert the set of ipv6 addresses stored as numerics > (by historical reasons mostly) to inet type. > > Something like > '0:0:0:0:0:0:0:0'::inet + 55831599345971591062080247067748335616::bigint > apparently doesn't work as

Re: [GENERAL] numeric to ipv6 inet

2013-08-23 Thread Osvaldo Kussama
2013/8/23, Mikhail Puzanov : > Hello, > > I need to convert the set of ipv6 addresses stored as numerics > (by historical reasons mostly) to inet type. > > Something like > '0:0:0:0:0:0:0:0'::inet + 55831599345971591062080247067748335616::bigint > apparently doesn't work as the number added is too

[GENERAL] numeric to ipv6 inet

2013-08-23 Thread Mikhail Puzanov
Hello, I need to convert the set of ipv6 addresses stored as numerics (by historical reasons mostly) to inet type. Something like '0:0:0:0:0:0:0:0'::inet + 55831599345971591062080247067748335616::bigint apparently doesn't work as the number added is too big to be converted to bigint. Is there an