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 any reasonable way to do it in sql/pgplsql?
Thanks in advance.
--
Best regards,
Mikhail V. Puzanov.