V6_NTOA
Converts an IPv6 address represented as varbinary to a character string.
Behavior Type
Syntax
V6_NTOA ( expression )
Parameters
expression |
( |
Notes
The following syntax converts an IPv6 address represented as VARBINARY
B to a string A.
V6_NTOA
right-pads B to 16 bytes with zeros, if necessary, and calls the Linux function inet_ntop.
=> V6_NTOA(VARBINARY B) -> VARCHAR A
If B is NULL or longer than 16 bytes, the result is NULL.
Vertica automatically converts the form '::ffff:1.2.3.4' to '1.2.3.4'.
Examples
=> SELECT V6_NTOA(' \001\015\270\000\000\000\000\000\010\010\000 \014Az'); v6_ntoa --------------------------- 2001:db8::8:800:200c:417a (1 row)
=> SELECT V6_NTOA(V6_ATON('1.2.3.4')); v6_ntoa --------- 1.2.3.4 (1 row) => SELECT V6_NTOA(V6_ATON('::1.2.3.4')); v6_ntoa ----------- ::1.2.3.4 (1 row)