UUID_NUMERIC

Description

Return a LARGEINT type uuid

This function continues to return LARGEINT; the native UUID type does not change that behavior. Use UUID_V4 or UUID_V7 when a native UUID value is required.

Syntax

UUID_NUMERIC()

Return Value

Return a LARGEINT type uuid. Note that LARGEINT is an Int128, so uuid_numeric() may produce negative values

Example

select uuid_numeric()

+----------------------------------------+
| uuid_numeric()                         |
+----------------------------------------+
| 82218484683747862468445277894131281464 |
+----------------------------------------+