FunctionsType Conversion

to_uuid_or_zero

Converts values to UUID and uses an all-zero UUID when conversion fails.

to_uuid_or_zero(…) → UUID

Kind · scalar

Converts values to UUID and uses an all-zero UUID when conversion fails.

Part of the Type Conversion family.

to_uuid_or_null

Converts values to UUID and returns NULL when conversion fails.

to_valid_utf8

Repairs invalid UTF-8 byte sequences by replacing malformed segments with '?', returning valid UTF-8 text.