Functions
Clean text, calculate values and write conditions. Use these expressions in Formula to create columns or in Filter to choose rows.
All functions
347 functions
No functions match. Try another name or a shorter description.
Text
Return the Unicode number of the first character in text.
binConverts the string to binary representation.
bit_lengthNumber of bits in a string.
chrReturns a character which corresponds to the ASCII code value or Unicode code point.
concatJoin text values or lists into one value. Missing values are skipped, while the || operator returns a missing value if any input is missing.
concat_wsJoin text values with a separator between them. Missing values are skipped.
containsCheck whether text contains a search string. It also checks a list for an item, a map for a key and an unnamed struct for a value.
damerau_levenshteinCount the edits needed to turn one string into another, like levenshtein, but swapping two neighboring characters counts as one edit. Uppercase and lowercase letters count as different.
formatFill {} placeholders in text with values, as in format('{} and {}', 'a', 1).
format_bytesConvert a byte count to a readable size using units based on powers of 2, such as KiB, MiB and GiB. Also available as pg_size_pretty.
from_base64Decode base64 text into binary data.
hammingCalculate the Hamming distance between two strings: the number of positions where their characters differ. Both strings must have the same length, and uppercase and lowercase letters count as different.
hashCalculate a numeric hash of one or more values. It isn't a cryptographic hash, so don't use it for security.
hexConvert a value to hexadecimal text.
ilike_escapeCheck whether text matches a LIKE pattern, ignoring uppercase and lowercase. The escape character lets the pattern search for a literal % or _.
instrFind where a search string first appears in text, counting from 1. Returns 0 if there is no match.
jaccardScore how similar two strings are by the characters they share, from 0 to 1. Uppercase and lowercase letters count as different.
jaro_similarityThe Jaro similarity between two strings. Characters of different cases (e.g., a and A) are considered different. Returns a number between 0 and 1. For similarity < score_cutoff, 0 is returned instead. score_cutoff defaults to 0.
jaro_winkler_similarityThe Jaro-Winkler similarity between two strings. Characters of different cases (e.g., a and A) are considered different. Returns a number between 0 and 1. For similarity < score_cutoff, 0 is returned instead. score_cutoff defaults to 0.
leftReturn the first characters of text, up to the given count.
left_graphemeExtracts the left-most count grapheme clusters.
lengthCount the characters in text. For a list, count its items.
length_graphemeNumber of grapheme clusters in string.
levenshteinCount the fewest character insertions, deletions and substitutions needed to turn one string into another. Uppercase and lowercase letters count as different.
like_escapeCheck whether text matches a LIKE pattern, treating uppercase and lowercase as different. The escape character lets the pattern search for a literal % or _.
lowerConvert text to lowercase.
lpadAdd a character to the left of text until it reaches a given length. Longer text is cut from the right to that length.
ltrimRemove spaces from the start of text. Pass a second argument to remove those characters instead.
md5Calculate the MD5 hash of text or binary data, returned as hexadecimal text.
md5_numberReturn the MD5 hash of text or binary data as a UHUGEINT number.
md5_number_lowerRead the lower 64 bits of an MD5 digest as an unsigned integer.
md5_number_upperRead the upper 64 bits of an MD5 digest as an unsigned integer.
nfc_normalizeConverts string to Unicode NFC normalized string. Useful for comparisons and ordering if text data is mixed between NFC normalized and not.
not_ilike_escapeCheck whether text doesn't match a LIKE pattern, ignoring uppercase and lowercase. The escape character lets the pattern search for a literal % or _.
not_like_escapeCheck whether text doesn't match a LIKE pattern, treating uppercase and lowercase as different. The escape character lets the pattern search for a literal % or _.
parse_dirnameReturn the top-level directory name from a path. The optional separator can be system, both_slash (default), forward_slash or backslash.
parse_dirpathReturn a path up to its last slash, such as a/b for a/b/c.txt. The optional separator can be system, both_slash (default), forward_slash or backslash.
parse_filenameReturn the last component of a path, such as c.txt for a/b/c.txt. Set trim_extension to true to remove the file extension. The optional separator can be system, both_slash (default), forward_slash or backslash.
parse_pathReturn the directories and filename in a path as a list. The optional separator can be system, both_slash (default), forward_slash or backslash.
positionFind where a search string first appears in text, counting from 1. Returns 0 if there is no match.
prefixCheck whether text begins with a given string.
printfBuild text from a template with placeholders, such as %s for text and %d for whole numbers.
repeatRepeat text, binary data or a list a given number of times.
replaceReplace every occurrence of one piece of text with another.
reverseReverse the characters in text.
rightReturn the last characters of text, up to the given count.
right_graphemeExtracts the right-most count grapheme clusters.
rpadAdd a character to the right of text until it reaches a given length. Longer text is cut from the right to that length.
rtrimRemove spaces from the end of text. Pass a second argument to remove those characters instead.
sha1Returns a VARCHAR with the SHA-1 hash of the value.
sha256Calculate the SHA-256 hash of text or binary data, returned as hexadecimal text.
split_partSplit text at a separator and retrieve one part by its position.
starts_withCheck whether text begins with a given string.
string_splitSplit text at a separator and return the parts as a list.
strip_accentsRemove accents from text, so ü becomes u.
strlenCount the bytes in text. Accented letters and emoji take more than one byte each.
substringExtract part of text, starting at a character position where 1 is the first character. Without a length, it continues to the end of the text.
substring_graphemeExtracts substring starting from grapheme clusters start up to the end of the string. If optional argument length is set, extracts a substring of length grapheme clusters instead. Note that a start value of 1 refers to the first character of the string.
suffixCheck whether text ends with a given string.
to_baseConverts number to a string in the given base radix, optionally padding with leading zeros to min_length.
to_base64Encode binary data as base64 text.
translateSwap individual characters: each character in the second argument becomes the character at the same position in the third. Characters with no counterpart are removed.
trimRemove spaces from both ends of text. Pass a second argument to remove those characters instead.
unbinConverts a value from binary representation to a blob.
unhexConverts a value from hexadecimal representation to a blob.
unicodeReturns an INTEGER representing the unicode codepoint of the first character in the string.
upperStandardize text in uppercase before comparing labels or displaying codes.
url_decodeTurn percent codes in a URL back into the original characters.
url_encodeMake text safe for a URL by replacing spaces and special characters with percent codes.
Numbers
Return the absolute value of a number, removing any minus sign.
acosComputes the arccosine of x.
acoshComputes the inverse hyperbolic cos of x.
addAdd two values.
asinComputes the arcsine of x.
asinhComputes the inverse hyperbolic sin of x.
atanComputes the arctangent of x.
atan2Computes the arctangent (y, x).
atanhComputes the inverse hyperbolic tan of x.
bit_countReturns the number of bits that are set.
cbrtCalculate the cube root of a number.
ceilRound a number up to the nearest whole number.
ceilingRound a number up to the nearest whole number.
cosComputes the cos of x.
cotComputes the cotangent of x.
degreesConvert an angle from radians to degrees.
divideDivide whole numbers and discard the fractional part.
evenRound a number away from zero to the next even whole number.
expRaise e, about 2.718, to a given power.
factorialMultiply a whole number by every whole number below it, down to 1.
fdivDivide two numbers and round the quotient down to a whole number, stored as DOUBLE.
floorRound a number down to the nearest whole number.
fmodFind the remainder using division rounded down toward negative infinity.
gammaInterpolation of (x-1) factorial (so decimal inputs are allowed).
gcdFind the largest whole number that divides two numbers exactly.
greatestReturn the largest of its arguments, ignoring missing values. Text is compared by character, so lowercase letters count as larger than uppercase letters.
greatest_common_divisorFind the largest whole number that divides two numbers exactly.
isfiniteCheck whether a value is finite, meaning neither infinite nor NaN.
isinfCheck whether a value is infinite.
isnanCheck whether a number is NaN, the special "not a number" value.
lcmFind the smallest whole number that two numbers both divide into exactly.
leastReturn the smallest of its arguments, ignoring missing values. Text is compared by character, so uppercase letters count as smaller than lowercase letters.
least_common_multipleFind the smallest whole number that two numbers both divide into exactly.
lgammaComputes the log of the gamma function.
lnCalculate the natural logarithm (base e) of a number.
logCalculate a logarithm. With one argument it uses base 10, and with two the first argument is the base.
log10Calculate the base-10 logarithm of a number.
log2Calculate the base-2 logarithm of a number.
multiplyMultiply two values.
nextafterReturns the next floating point value after x in the direction of y.
piReturn the value of pi, about 3.14159.
powRaise a number to a power.
powerRaise a number to a power.
radiansConvert an angle from degrees to radians.
randomReturn a random number between 0 and 1. Each row gets a new value.
roundRound decimal values to a consistent number of places for prices, measurements or reports.
round_evenRound a number, resolving exact halfway cases toward the nearest even digit.
roundbankersRound a number using the half-to-even rule for exact halfway cases.
signReturn -1 for a negative number, 0 for zero and 1 for a positive number.
signbitReturns whether the signbit is set or not.
sinComputes the sin of x.
sqrtCalculate the square root of a number.
subtractSubtract one value from another.
tanComputes the tan of x.
truncRemove the fractional part of a number, rounding toward zero. An optional second argument keeps that many decimal places.
xorBitwise XOR.
Dates & times
Calculate the time between two timestamps as an interval, subtracting the second from the first.
centuryGet the century from a date or timestamp, such as 20 for 1992.
date_addMove a date or timestamp forward or backward by an interval.
date_diffCount the unit boundaries crossed between two dates or timestamps. For example, January 31 to February 1 crosses one month boundary.
date_partGet one part of a date, time or interval, such as the year. Pass a list of part names to get a struct of parts.
date_subCount the complete units between two dates or timestamps. For example, January 31 to February 1 is zero complete months. Also available as datesub.
date_truncRound a date or timestamp down to the start of a unit such as month or year. Also available as datetrunc.
datepartGet one part of a date, time or interval, such as the year. Pass a list of part names to get a struct of parts.
dayGet the day of the month, from 1 to 31, from a date or timestamp.
daynameGet the English name of the weekday.
dayofmonthGet the day of the month, from 1 to 31, from a date or timestamp.
dayofweekGet the day of the week as a number, where Sunday is 0 and Saturday is 6.
dayofyearGet the day of the year, from 1 to 366, from a date or timestamp.
days_in_monthFind the number of days in the month containing a date.
decadeExtract the decade component from a date or timestamp.
epochGet the seconds since 1970-01-01 for a date or timestamp, or the total seconds in an interval.
epoch_msGet the milliseconds since 1970-01-01 for a date or timestamp. Given a whole number of milliseconds, it returns the matching timestamp instead.
epoch_nsExtract the epoch component in nanoseconds from a temporal type.
epoch_usExtract the epoch component in microseconds from a temporal type.
eraExtract the era component from a date or timestamp.
extractExtract a date or time component such as the year.
generate_seriesCreate a list of values from start to stop, including stop. Start defaults to 0 and step defaults to 1.
get_current_timestampReturn the current date and time, with time zone.
hourGet the hour, from 0 to 23, from a date or timestamp.
isodowGet the ISO day of the week as a number, where Monday is 1 and Sunday is 7.
isoyearGet the ISO week-numbering year, which can differ from the calendar year around New Year.
julianExtract the Julian Day number from a date or timestamp.
last_dayReturn the last day of the month containing a date.
make_dateBuild a date from a year, month and day. It also accepts a struct with those fields or a day count since 1970-01-01.
make_timeBuild a time from an hour, minute and seconds.
make_timestampBuild a timestamp from a year, month, day, hour, minute and seconds.
make_timestamp_msBuild a timestamp from the number of milliseconds since 1970-01-01.
make_timestamp_nsThe timestamp for the given nanoseconds since epoch.
microsecondExtract the microsecond component from a date or timestamp.
millenniumExtract the millennium component from a date or timestamp.
millisecondExtract the millisecond component from a date or timestamp.
minuteGet the minute, from 0 to 59, from a date or timestamp.
monthGet the month number, from 1 to 12, from a date or timestamp.
monthnameGet the English name of the month.
nowReturn the current date and time, with time zone.
quarterGet the quarter, from 1 to 4, from a date or timestamp.
rangeCreate a list of values from start up to stop, excluding stop. Start defaults to 0 and step defaults to 1.
secondGet the second, from 0 to 59, from a date or timestamp.
strftimeFormat a date or timestamp as text using a format string such as %d/%m/%Y.
strptimeParse text into a timestamp using a format string such as %d/%m/%Y. Text that doesn't match raises an error; use try_strptime to get a missing value instead.
time_bucketRound a date or timestamp down to the start of a fixed-width bucket, such as every 2 days. Buckets count from 2000-01-03, or from 2000-01-01 for month and year buckets, unless you pass your own origin.
timezoneWith one argument, get the time zone offset of a timestamp in seconds. With two arguments, convert a time or timestamp to a time zone given as a name, or as an interval for a time with time zone.
timezone_hourExtract the timezone_hour component from a date or timestamp.
timezone_minuteExtract the timezone_minute component from a date or timestamp.
to_centuriesConstruct a century interval.
to_daysTurn a number into an interval of that many days.
to_decadesConstruct a decade interval.
to_hoursConstruct an hour interval.
to_microsecondsConstruct a microsecond interval.
to_millenniaConstruct a millennium interval.
to_millisecondsConstruct a millisecond interval.
to_minutesConstruct a minute interval.
to_monthsTurn a number into an interval of that many months.
to_quartersConstruct a quarter interval.
to_secondsConstruct a second interval.
to_timestampConvert seconds since 1970-01-01 to a timestamp with time zone.
to_weeksTurn a number into an interval of that many weeks, shown in days.
to_yearsTurn a number into an interval of that many years.
transaction_timestampReturn the current date and time, with time zone.
try_strptimeParse text into a timestamp using a format string such as %d/%m/%Y. Text that doesn't match returns a missing value instead of an error.
weekGet the ISO week number from a date or timestamp.
weekdayGet the day of the week as a number, where Sunday is 0 and Saturday is 6.
weekofyearGet the ISO week number from a date or timestamp.
yearGet the year from a date or timestamp.
yearweekCombine the ISO year and week number into one number, such as 199207 for week 7 of 1992.
Conditions & missing values
Check whether a value falls within an inclusive range.
CASEChoose a result using one or more conditions.
coalesceReplace missing values with the first available alternative.
ifChoose between two values using a condition.
ifnullUse a fallback when a value is missing.
IS NULLFind missing values without confusing them with empty text.
nullifTurn a sentinel value, such as zero or an empty string, into a missing value.
OperatorsCalculate values and combine comparisons in expressions.
Patterns
Match text against a pattern without distinguishing uppercase and lowercase.
LIKEMatch text against a case-sensitive pattern.
regexp_escapeEscape special characters in text so that a regular expression matches it literally.
regexp_extractReturn the part of text that matches a regular expression, or empty text if there is no match. An optional constant group number picks a capturing group, and regex options can follow.
regexp_extract_allFind every non-overlapping match of a regular expression in text and return them as a list. An optional group number picks a capturing group, and regex options can follow.
regexp_full_matchCheck whether all of the text matches a regular expression. An optional argument sets regex options.
regexp_matchesCheck whether text contains a match for a regular expression. An optional argument sets regex options.
regexp_replaceReplace the first match of a regular expression in text. Pass the g option to replace every match.
regexp_split_to_arraySplit text at each match of a regular expression and return the parts as a list. An optional argument sets regex options.
string_split_regexSplit text at each match of a regular expression and return the parts as a list. An optional argument sets regex options.
Across rows
Find the fraction of rows whose sort value is less than or equal to the current value.
dense_rankRank distinct values consecutively, giving ties the same rank.
fillEstimate missing values using linear interpolation along an ordered sequence.
first_valueRepeat the first value in a window frame.
lagCompare each row with a value from an earlier row.
last_valueRepeat the last value in a window frame.
leadCompare each row with a value from a later row.
nth_valueRetrieve a value at a specified position within a window frame.
ntileDivide ordered rows into a requested number of approximately equal groups.
percent_rankExpress a row rank on a scale from zero to one.
rankRank values while leaving gaps after ties.
row_numberNumber rows in a specified order.
Lists & arrays
Computes the cosine distance between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_cosine_similarityComputes the cosine similarity between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_cross_productComputes the cross product of two arrays of size 3. The array elements can not be NULL.
array_distanceComputes the distance between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_extractGet one item from a list or one character from text by position, where 1 is the first. For a struct, choose a field by name, or by position in an unnamed struct.
array_inner_productComputes the inner product between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_negative_inner_productComputes the negative inner product between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_pop_backRemove the last value from a list.
array_pop_frontRemove the first value from a list.
array_push_frontAdd a value at the beginning of a list.
array_sliceExtract a section of a list or text by start and end positions, where 1 is the first position. Negative positions count from the end.
array_to_stringJoin the values in a list into one string using a separator.
array_to_string_comma_defaultJoin the values in a list into comma-separated text.
array_valueCreates an ARRAY containing the argument values.
flattenMerge a list of lists into one list, removing one level of nesting.
list_aggregateRun a named aggregate function, such as min or sum, over the items in a list.
list_any_valueTake the first non-missing value from a list.
list_appendAdd a value to the end of a list. Also available as array_append and array_push_back.
list_approx_count_distinctCalculate an approximate count of distinct values from the values in a list.
list_avgCalculate the arithmetic mean from the values in a list.
list_bit_andCalculate the bitwise AND from the values in a list.
list_bit_orCalculate the bitwise OR from the values in a list.
list_bit_xorCalculate the bitwise XOR from the values in a list.
list_bool_andCalculate whether all non-missing values are true from the values in a list.
list_bool_orCalculate whether any non-missing value is true from the values in a list.
list_concatJoin lists into one list. Missing inputs are skipped, while the || operator returns a missing value if either input is missing.
list_containsCheck whether a list contains a value.
list_cosine_distanceComputes the cosine distance between two same-sized lists.
list_cosine_similarityComputes the cosine similarity between two same-sized lists.
list_countCalculate the number of non-missing values from the values in a list.
list_distanceCalculates the Euclidean distance between two points with coordinates given in two inputs lists of equal length.
list_distinctRemove duplicates and missing values from a list. The original order isn't kept.
list_entropyCalculate the information entropy from the values in a list.
list_extractGet the list item at a position, where 1 is the first item. A negative position counts from the end.
list_filterKeep the list items for which a lambda expression returns true. The lambda result must be convertible to BOOLEAN, and the output has the same type as the input list.
list_firstCalculate the first value from the values in a list.
list_grade_upSort a list and return the original positions of its items instead of their values. It accepts the same options as list_sort.
list_has_allCheck whether a list contains every item of a second list. Missing values are ignored.
list_has_anyCheck whether two lists share at least one item. Missing values are ignored.
list_histogramCalculate a frequency map from the values in a list.
list_inner_productComputes the inner product between two same-sized lists.
list_intersectReturn the distinct items that appear in both lists.
list_kurtosisCalculate the sample excess kurtosis from the values in a list.
list_kurtosis_popCalculate the population excess kurtosis from the values in a list.
list_lastCalculate the last value from the values in a list.
list_madCalculate the median absolute deviation from the values in a list.
list_maxCalculate the largest value from the values in a list.
list_medianCalculate the median from the values in a list.
list_minCalculate the smallest value from the values in a list.
list_modeCalculate the most frequent value from the values in a list.
list_negative_inner_productComputes the negative inner product between two same-sized lists.
list_positionFind the position of a value in a list, where 1 is the first item. Returns a missing value if it isn't found.
list_prependAdd a value to the beginning of a list. Also available as array_prepend.
list_productCalculate the product from the values in a list.
list_reduceReduces all elements of the input list into a single scalar value by executing the lambda function on a running result and the next list element. The lambda function has an optional initial_value argument.
list_resizeResize a list to the given size. New items take the given value, or a missing value if none is given.
list_reverseReverse the order of values in a list. Also available as array_reverse.
list_reverse_sortSort the items in a list in reverse order. An optional argument sets where missing values go (NULLS FIRST or NULLS LAST).
list_selectBuild a list from the items at the given positions, where 1 is the first item.
list_semCalculate the standard error of the mean from the values in a list.
list_skewnessCalculate the sample skewness from the values in a list.
list_sliceExtract a section of a list or text by start and end positions, where 1 is the first position. Negative positions count from the end.
list_sortSort the items in a list. Optional arguments set the order (ASC or DESC) and where missing values go (NULLS FIRST or NULLS LAST).
list_stddev_popCalculate the population standard deviation from the values in a list.
list_stddev_sampCalculate the sample standard deviation from the values in a list.
list_string_aggCalculate comma-separated text from the values in a list.
list_sumAdd up the values in a list.
list_transformApply a lambda expression to each list item and return the results as a list. The item type of the output comes from the lambda result.
list_uniqueCount the distinct items in a list, ignoring missing values.
list_valueCreate a list from its arguments.
list_var_popCalculate the population variance from the values in a list.
list_var_sampCalculate the sample variance from the values in a list.
list_whereKeep the list items whose matching position in a second list of true and false values is true.
list_zipPair up items by position from two or more lists, returning a list of structs. Shorter lists are padded with missing values unless you set truncate, which stops at the shortest list.
Maps
Count the entries in a map.
element_atLook up a key in a map and return its value inside a list, or an empty list if the key is absent. The key must have the same type as the map's keys.
mapCreate a map from a list of keys and a list of values.
map_concatMerge maps into one. If a key appears more than once, the value from the last map with that key wins.
map_containsCheck whether a map has a given key.
map_contains_entryCheck whether a map includes a particular key and value together.
map_contains_valueCheck whether any entry in a map has the requested value.
map_entriesReturn a map's entries as a list of structs with key and value fields.
map_extractLook up a key in a map and return its value inside a list, or an empty list if the key is absent. The key must have the same type as the map's keys.
map_extract_valueLook up a key in a map and return its value, or a missing value if the key is absent. The key must have the same type as the map's keys.
map_from_entriesCreate a map from a list of structs that each hold a key and a value.
map_keysList the keys of a map.
map_valuesList the values of a map.
Structs
Create an unnamed struct from its arguments.
struct_concatMerge several structs into one.
struct_containsCheck whether an unnamed struct contains a value.
struct_extractGet one entry from a struct by name, or by position starting at 1 in an unnamed struct.
struct_extract_atGet one entry from a struct by position, starting at 1.
struct_insertAdd fields to an existing struct. Each new field takes its name from a named argument, as in struct_insert(s, b := 2).
struct_packCreate a struct from named arguments. Each field takes its name from its argument, as in struct_pack(a := 1).
struct_positionFind the position of a value in an unnamed struct, starting at 1.
struct_updateChange or add fields in an existing struct. Each field takes its name from a named argument, as in struct_update(s, b := 2).
struct_valuesReturn the field values of a struct as an unnamed struct.
Bits
Returns first starting index of the specified substring within bits, or zero if it isn't present. The first (leftmost) bit is indexed 1.
bitstringPads the bitstring until the specified length.
get_bitExtracts the nth bit from bitstring; the first (leftmost) bit is indexed 0.
set_bitSets the nth bit in bitstring to newvalue; the first (leftmost) bit is indexed 0. Returns a new bitstring.
Binary data
Converts blob to VARCHAR. Invalid UTF-8 is handled based on the error behavior argument. Can be 'strict' (default, fail), 'replace' to replace invalid characters with '?', or 'ignore' to skip invalid characters.
encodeConverts the string to BLOB. Converts UTF-8 characters into literal encoding.
octet_lengthNumber of bytes in blob.
Enums
Returns the numeric value backing the given enum value.
enum_firstReturns the first value of the input enum type.
enum_lastReturns the last value of the input enum type.
enum_rangeReturns all values of the input enum type as an array.
enum_range_boundaryReturns the range between the two given enum values as an array. The values must be of the same enum type. When the first parameter is NULL, the result starts with the first value of the enum type. When the second parameter is NULL, the result ends with the last value of the enum type.
Unions
Conversion & identifiers
Convert a value to another data type; invalid conversions raise an error.
constant_or_nullReturn the first argument, or a missing value if the second argument is missing.
gen_random_uuidReturn a random UUID v4, such as 7e7ea35f-f813-46ce-ac7b-12658c021bcb.
TRY_CASTConvert a value to another data type, returning a missing value if conversion fails.
typeofReturn the name of an expression's data type.
uuidReturn a random UUID v4, such as 7e7ea35f-f813-46ce-ac7b-12658c021bcb.
uuid_extract_timestampExtract the timestamp for the given UUID v7.
uuid_extract_versionExtract a version for the given UUID.
uuidv4Return a random UUID v4, such as 7e7ea35f-f813-46ce-ac7b-12658c021bcb.
uuidv7Return a random, time-ordered UUID v7, such as 019482e4-1441-7aad-8127-eec99573b0a0.