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.