IPv4 Address
Type Registry
IPv4 Address
technology.internet.ip_v4 Standard 4-octet IPv4 address format (e.g., 192.168.1.1). Resolves to VARCHAR with INET validation. Can optionally parse to DuckDB INET type with the inet extension.
Domain technology›internet
Casts to VARCHAR
Scope Universal
Try it
CLI
$ finetype infer -i "192.168.1.1"
→ technology.internet.ip_v4 DuckDB
Detect
SELECT finetype('192.168.1.1');
-- → 'technology.internet.ip_v4' Cast expression
CAST({col} AS VARCHAR) Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'technology.internet.ip_v4'; JSON Schema
finetype schema technology.internet.ip_v4 {
"$id": "https://noon.sh/schemas/technology.internet.ip_v4",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Standard 4-octet IPv4 address format (e.g., 192.168.1.1). Resolves to VARCHAR with INET validation. Can optionally parse to DuckDB INET type with the inet extension.",
"examples": [
"192.168.1.1",
"8.8.8.8",
"127.0.0.1",
"10.0.0.0"
],
"pattern": "^(?:(?: 25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.){3}(?: 25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"title": "IPv4 Address",
"type": "string"
} Examples
192.168.1.18.8.8.8127.0.0.110.0.0.0 Also known as
ipv4