numeric to ipv6 inet

[Mikhail Puzanov <misha.puzanov@xxxxxxxxx>]

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.