PARSE_URL

​

Syntax

​

Scalar

parse_url(url, part [, key])

​

Arguments

​

Returns

• Type: STRING
• Possible values: The requested component text, or NULL when absent or the part selector is unsupported.
• NULL behavior: NULL url/part returns NULL. An explicitly supplied NULL key returns NULL even for a part other than QUERY. Missing components or keys return NULL.

​

Properties

​

Usage notes

• Query extraction splits raw key=value pairs on & and returns the first matching key. It does not percent-decode values or convert plus to space; a key-only item without = does not match.
• A URL without an explicit scheme is parsed as a relative URI: PATH/QUERY/REF/FILE can exist, while HOST/PROTOCOL/AUTHORITY/USERINFO return NULL. An absolute URL with no explicit slash has an empty PATH rather than /.

​

Examples

​

Example values

SELECT parse_url('https://example.com/p?a=1&b=2', 'HOST') AS host, parse_url('https://example.com/p?a=1&b=2', 'QUERY', 'a') AS parameter;

​

Read a path and a missing query key

SELECT parse_url('https://example.com/docs?q=sql', 'PATH') AS path, parse_url('https://example.com/docs?q=sql', 'QUERY', 'missing') AS missing_key;

​

Limitations

• Malformed absolute URLs can raise a parsing error. Unsupported part names return NULL. URLs are normalized during parsing; raw query and path components keep percent-encoded characters.