⌘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 subnet (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 ... 1.5/24 192.168.1.255/24 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::ffff:ffff/96 <<= Predicate Is subnet contained by or equal to subnet? CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.0/24'), ('127.0.0.1'), ( ... '2001:db8:3c4d:15::1a2f:1a2b/96'); SELECT cidr, INET '192.168.1.5/32' <<= cidr AS subnet_contained FROM tbl; cidr subnet_contained 192.168.1.0/24 true 127.0.0.1 false 2001:db8:3c4d:15::1a2f:1a2b/96 false >>= Pre ... dicate Does subnet contain or equal subnet? CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.0/24'), ('127.0.0.1'), ('2001:db ...
https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work