⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
advanced help
per page, with , order by , clip by
Results of 1 - 1 of about 1 for netmask (0.000 sec.)
inet Extension 9414
The inet extension defines the INET data type for storing IPv4 and IPv6 Internet addresses. It supports the CIDR notation for subnet masks (e.g., 198.51.100.0/22 , 2001:db8:3c4d::/48 ). Installing and Loading The inet extension will be tran ... M tbl; cidr host 192.168.0.0/16 192.168.0.0 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::1a2f:1a2b netmask Function Computes the network mask for the address's network. CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.1 ... 68.1.5/24'), ('127.0.0.1'), ('2001:db8:3c4d:15::1a2f:1a2b/96'); SELECT cidr, netmask(cidr) AS netmask FROM tbl; cidr netmask 192.168.1.5/24 255.255.255.0/24 127.0.0.1 255.255.255.255 2001:db8:3c4d:15::1a2f:1 ... :ffff:ffff:ffff::/96 network Function Returns the network part of the address, zeroing out whatever is to the right of the netmask. CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.5/24'), ('127.0.0.1'), ('2001:db8:3c4d:15::1a2f:1a2b/96' ...
https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work