Functions and Operators

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends elem to array, returning the result.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Appends two arrays.

Calculates the length of input on the provided array_dimension. However, because CockroachDB doesn’t yet support multi-dimensional arrays, the only supported array_dimension is 1.

Calculates the minimum value of input on the provided array_dimension. However, because CockroachDB doesn’t yet support multi-dimensional arrays, the only supported array_dimension is 1.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Return the index of the first occurrence of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Returns and array of indexes of all occurrences of elem in array.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Prepends elem to array, returning the result.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Remove from array all elements equal to elem.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Replace all occurrences of toreplace in array with replacewith.

Join an array into a string with a delimiter.

Join an array into a string with a delimiter, replacing NULLs with a null string.

Calculates the maximum value of input on the provided array_dimension. However, because CockroachDB doesn’t yet support multi-dimensional arrays, the only supported array_dimension is 1.

Split a string into components on a delimiter.

Split a string into components on a delimiter with a specified string to consider NULL.

Matches case insensetively unescaped with pattern using ‘escape’ as an escape token.

Test for subnet inclusion or equality, using only the network parts of the addresses. The host part of the addresses is ignored.

Test for subnet inclusion or equality, using only the network parts of the addresses. The host part of the addresses is ignored.

Checks if two IP addresses are of the same IP family.

Matches unescaped with pattern using ‘escape’ as an escape token.

Checks whether unescaped not matches case insensetively with pattern using ‘escape’ as an escape token.

Checks whether unescaped not matches with pattern using ‘escape’ as an escape token.

Checks whether unescaped not matches with pattern using ‘escape’ as an escape token.

Matches unescaped with pattern using ‘escape’ as an escape token.

Returns the element with the greatest value.

Returns the element with the lowest value.

Calculates the interval between begin and end.

Calculates the interval between val and the current time.

Returns the current system time on one of the cluster nodes.

Returns the current system time on one of the cluster nodes.

Returns the date of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

This function is the preferred overload and will be evaluated by default.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

This function is the preferred overload and will be evaluated by default.

Truncates input to precision element. Sets all fields that are less significant than element to zero (or one, for day and month)

Compatible elements: millennium, century, decade, year, quarter, month, week, day, hour, minute, second, millisecond, microsecond.

Truncates input to precision element. Sets all fields that are less significant than element to zero.

Compatible elements: hour, minute, second, millisecond, microsecond.

Truncates input to precision element. Sets all fields that are less significant than element to zero (or one, for day and month)

Compatible elements: millennium, century, decade, year, quarter, month, week, day, hour, minute, second, millisecond, microsecond.

Truncates input to precision element. Sets all fields that are less significant than element to zero (or one, for day and month)

Compatible elements: millennium, century, decade, year, quarter, month, week, day, hour, minute, second, millisecond, microsecond.

Returns a timestamp which is very likely to be safe to perform against a follower replica.

This function is intended to be used with an AS OF SYSTEM TIME clause to perform historical reads against a time which is recent but sufficiently old for reads to be performed against the closest replica as opposed to the currently leaseholder for a given range.

Note that this function requires an enterprise license on a CCL distribution to return without an error.

From input, extracts and formats the time as identified in extract_format using standard strftime notation (though not all formatting is supported).

From input, extracts and formats the time as identified in extract_format using standard strftime notation (though not all formatting is supported).

From input, extracts and formats the time as identified in extract_format using standard strftime notation (though not all formatting is supported).

Returns input as a timestamptz using format (which uses standard strptime formatting).

Extracts element from input.

Compatible elements: millennium, century, decade, year, isoyear, quarter, month, week, dayofweek, isodow, dayofyear, julian, hour, minute, second, millisecond, microsecond, epoch

Extracts element from input.

Compatible elements: millennium, century, decade, year, month, day, hour, minute, second, millisecond, microsecond, epoch

Extracts element from input.

Compatible elements: hour, minute, second, millisecond, microsecond, epoch

Extracts element from input.

Compatible elements: millennium, century, decade, year, isoyear, quarter, month, week, dayofweek, isodow, dayofyear, julian, hour, minute, second, millisecond, microsecond, epoch

Extracts element from input.

Compatible elements: millennium, century, decade, year, isoyear, quarter, month, week, dayofweek, isodow, dayofyear, julian, hour, minute, second, millisecond, microsecond, epoch, timezone, timezone_hour, timezone_minute

Extracts element from input.

Compatible elements: hour, minute, second, millisecond, microsecond, epoch, timezone, timezone_hour, timezone_minute

Extracts element from input. Compatible elements: hour, minute, second, millisecond, microsecond. This is deprecated in favor of extract which supports duration.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

This function is the preferred overload and will be evaluated by default.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

This function is the preferred overload and will be evaluated by default.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

This function is the preferred overload and will be evaluated by default.

Returns the start time of the current statement.

Returns the start time of the current statement.

Returns the current system time on one of the cluster nodes as a string.

Treat given time without time zone as located in the specified time zone This is deprecated in favor of timezone(str, time)

Treat given time stamp without time zone as located in the specified time zone. This is deprecated in favor of timezone(str, timestamp)

Convert given time stamp with time zone to the new time zone, with no time zone designation This is deprecated in favor of timezone(str, timestamptz)

Convert given time with time zone to the new time zone This is deprecated in favor of timezone(str, timetz)

Treat given time without time zone as located in the specified time zone.

Treat given time stamp without time zone as located in the specified time zone.

Convert given time stamp with time zone to the new time zone, with no time zone designation.

Convert given time stamp with time zone to the new time zone, with no time zone designation.

Convert given time with time zone to the new time zone.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

Returns the time of the current transaction.

The value is based on a timestamp picked when the transaction starts and which stays constant throughout the transaction. This timestamp has no relationship with the commit order of concurrent transactions.

This function is the preferred overload and will be evaluated by default.

Returns a UUID.

Generates a random UUID and returns it as a value of UUID type.

Returns a unique ID used by CockroachDB to generate unique row IDs if a Primary Key isn’t defined for the table. The value is a combination of the insert timestamp and the ID of the node executing the statement, which guarantees this combination is globally unique. However, there can be gaps and the order is not completely guaranteed.

Returns a UUID.

Converts the combined IP address and prefix length to an abbreviated display format as text.For INET types, this will omit the prefix length if it’s not the default (32 or IPv4, 128 for IPv6)

For example, abbrev('192.168.1.2/24') returns '192.168.1.2/24'

Gets the broadcast address for the network address represented by the value.

For example, broadcast('192.168.1.2/24') returns '192.168.1.255/24'

Extracts the IP family of the value; 4 for IPv4, 6 for IPv6.

For example, family('::1') returns 6

Extracts the address part of the combined address/prefixlen value as text.

For example, host('192.168.1.2/16') returns '192.168.1.2'

Creates an IP host mask corresponding to the prefix length in the value.

For example, hostmask('192.168.1.2/16') returns '0.0.255.255'

Retrieves the prefix length stored in the value.

For example, masklen('192.168.1.2/16') returns 16

Creates an IP network mask corresponding to the prefix length in the value.

For example, netmask('192.168.1.2/16') returns '255.255.0.0'

Sets the prefix length of val to prefixlen.

For example, set_masklen('192.168.1.2', 16) returns '192.168.1.2/16'.

Converts the IP address and prefix length to text.

Returns the array as JSON or JSONB.

Returns the array as JSON or JSONB.

Returns the number of elements in the outermost JSON or JSONB array.

Builds a possibly-heterogeneously-typed JSON or JSONB array out of a variadic argument list.

Builds a JSON object out of a variadic argument list.

Returns the JSON value pointed to by the variadic arguments.

This form of json_object takes keys and values pairwise from two separate arrays. In all other respects it is identical to the one-argument form.

Builds a JSON or JSONB object out of a text array. The array must have exactly one dimension with an even number of members, in which case they are taken as alternating key/value pairs.

Remove the specified path from the JSON object.

Returns the JSON value pointed to by the variadic arguments.

Returns the JSON value pointed to by the variadic arguments. If create_missing is false, new keys will not be inserted to objects and values will not be prepended or appended to arrays.

Returns from_json with all object fields that have null values omitted. Other null values are untouched.

Returns the type of the outermost JSON value as a text string.

Returns the number of elements in the outermost JSON or JSONB array.

Builds a possibly-heterogeneously-typed JSON or JSONB array out of a variadic argument list.

Builds a JSON object out of a variadic argument list.

Returns the JSON value pointed to by the variadic arguments.

Returns the JSON value pointed to by the variadic arguments. new_val will be inserted before path target.

Returns the JSON value pointed to by the variadic arguments. If insert_after is true (default is false), new_val will be inserted after path target.

This form of json_object takes keys and values pairwise from two separate arrays. In all other respects it is identical to the one-argument form.

Builds a JSON or JSONB object out of a text array. The array must have exactly one dimension with an even number of members, in which case they are taken as alternating key/value pairs.

Returns the given JSON value as a STRING indented and with newlines.

Returns the JSON value pointed to by the variadic arguments.

Returns the JSON value pointed to by the variadic arguments. If create_missing is false, new keys will not be inserted to objects and values will not be prepended or appended to arrays.

Returns from_json with all object fields that have null values omitted. Other null values are untouched.

Returns the type of the outermost JSON value as a text string.

Returns the value as JSON or JSONB.

Returns the value as JSON or JSONB.

Calculates the absolute value of val.

Calculates the absolute value of val.

Calculates the absolute value of val.

Calculates the inverse cosine of val.

Calculates the inverse sine of val.

Calculates the inverse tangent of val.

Calculates the inverse tangent of x/y.

Calculates the cube root (∛) of val.

Calculates the cube root (∛) of val.

Calculates the smallest integer not smaller than val.

Calculates the smallest integer not smaller than val.

Calculates the smallest integer not smaller than val.

Calculates the smallest integer not smaller than val.

Calculates the smallest integer not smaller than val.

Calculates the smallest integer not smaller than val.

Calculates the cosine of val.

Calculates the cotangent of val.

Calculates the CRC-32 hash using the Castagnoli polynomial.

Calculates the CRC-32 hash using the Castagnoli polynomial.

Calculates the CRC-32 hash using the IEEE polynomial.

Calculates the CRC-32 hash using the IEEE polynomial.

Converts val as a radian value to a degree value.

Calculates the integer quotient of x/y.

Calculates the integer quotient of x/y.

Calculates the integer quotient of x/y.

Calculates e ^ val.

Calculates e ^ val.

Calculates the largest integer not greater than val.

Calculates the largest integer not greater than val.

Calculates the largest integer not greater than val.

Calculates the 32-bit FNV-1 hash value of a set of values.

Calculates the 32-bit FNV-1 hash value of a set of values.

Calculates the 32-bit FNV-1a hash value of a set of values.

Calculates the 32-bit FNV-1a hash value of a set of values.

Calculates the 64-bit FNV-1 hash value of a set of values.

Calculates the 64-bit FNV-1 hash value of a set of values.

Calculates the 64-bit FNV-1a hash value of a set of values.

Calculates the 64-bit FNV-1a hash value of a set of values.

Returns true if val is NaN, false otherwise.

Returns true if val is NaN, false otherwise.

Calculates the natural log of val.

Calculates the natural log of val.

Calculates the base b log of val.

Calculates the base b log of val.

Calculates the base 10 log of val.

Calculates the base 10 log of val.

Calculates x%y.

Calculates x%y.

Calculates x%y.

Returns the value for pi (3.141592653589793).

Calculates x^y.

Calculates x^y.

Calculates x^y.

Calculates x^y.

Calculates x^y.

Calculates x^y.

Converts val as a degree value to a radians value.

Returns a random float between 0 and 1.

Keeps decimal_accuracy number of figures to the right of the zero position in input using half away from zero rounding. If decimal_accuracy is not in the range -2^31…(2^31-1), the results are undefined.

Keeps decimal_accuracy number of figures to the right of the zero position in input using half to even (banker’s) rounding.

Rounds val to the nearest integer, half away from zero: round(+/-2.4) = +/-2, round(+/-2.5) = +/-3.

Rounds val to the nearest integer using half to even (banker’s) rounding.

Determines the sign of val: 1 for positive; 0 for 0 values; -1 for negative.

Determines the sign of val: 1 for positive; 0 for 0 values; -1 for negative.

Determines the sign of val: 1 for positive; 0 for 0 values; -1 for negative.

Calculates the sine of val.

Calculates the square root of val.

Calculates the square root of val.

Calculates the tangent of val.

Truncates the decimal values of val.

Truncates the decimal values of val.

return the bucket number to which operand would be assigned in a histogram having count equal-width buckets spanning the range b1 to b2.

return the bucket number to which operand would be assigned in a histogram having count equal-width buckets spanning the range b1 to b2.

return the bucket number to which operand would be assigned given an array listing the lower bounds of the buckets; returns 0 for an input less than the first lower bound; the thresholds array must be sorted, smallest first, or unexpected results will be obtained

Returns the latest value obtained with nextval for this sequence in this session.

Return value most recently obtained with nextval in this session.

Advances the given sequence and returns its new value.

Set the given sequence’s current value. The next call to nextval will return value + Increment

Set the given sequence’s current value. If is_called is false, the next call to nextval will return value; otherwise value + Increment.

Produces a virtual table containing aclitem stuff (returns no rows as this feature is unsupported in CockroachDB)

For internal CRDB testing only. The function calls a callback identified by name registered with the server by the test.

Produces a virtual table containing a single row with no values.

This function is used only by CockroachDB’s developers for testing purposes.

Produces a virtual table containing the integer values from start to end, inclusive.

Produces a virtual table containing the integer values from start to end, inclusive, by increment of step.

Produces a virtual table containing the timestamp values from start to end, inclusive, by increment of step.

Returns a series comprising the given array’s subscripts.

Returns a series comprising the given array’s subscripts.

Returns a series comprising the given array’s subscripts.

When reverse is true, the series is returned in reverse order.

Returns the input array as a set of rows with an index

Expands a JSON array to a set of JSON values.

Expands a JSON array to a set of text values.

Expands the outermost JSON or JSONB object into a set of key/value pairs.

Expands the outermost JSON or JSONB object into a set of key/value pairs. The returned values will be of type text.

Returns sorted set of keys in the outermost JSON object.

Expands a JSON array to a set of JSON values.

Expands a JSON array to a set of text values.

Expands the outermost JSON or JSONB object into a set of key/value pairs.

Expands the outermost JSON or JSONB object into a set of key/value pairs. The returned values will be of type text.

Returns sorted set of keys in the outermost JSON object.

Produces a virtual table containing the keywords known to the SQL parser.

Returns the input arrays as a set of rows

Returns the input array as a set of rows

Returns the character code of the first character in val. Despite the name, the function supports Unicode too.

Calculates the number of bits used to represent val.

Calculates the number of bits used to represent val.

Calculates the number of bits used to represent val.

Removes any characters included in trim_chars from the beginning or end of input (applies recursively).

For example, btrim('doggie', 'eod') returns ggi.

Removes all spaces from the beginning and end of val.

Calculates the number of bytes in val.

Calculates the number of characters in val.

Calculates the number of bytes in val.

Calculates the number of characters in val.

Returns the character with the code given in val. Inverse function of ascii().

Concatenates a comma-separated list of strings.

Uses the first argument as a separator between the concatenation of the subsequent arguments.

For example concat_ws('!','wow','great') returns wow!great.

Decode the bytes in str into a string using encoding enc. Supports encodings ‘UTF8’ and ‘LATIN1’.

Encode the string str as a byte array using encoding enc. Supports encodings ‘UTF8’ and ‘LATIN1’.

Decodes data using format (hex / escape / base64).

Encodes data using format (hex / escape / base64).

Converts the byte string representation of an IP to its character string representation.

Converts the byte string representation of a UUID to its character string representation.

Extracts a bit at given index in the bit array.

Extracts a bit at given index in the byte array.

Capitalizes the first letter of val.

Returns the first return_set bytes from input.

Returns the first return_set characters from input.

Calculates the number of bytes in val.

Calculates the number of characters in val.

Calculates the number of bits in val.

Converts all characters in val to their lower-case equivalents.

Pads string to length by adding ’ ’ to the left of string.If string is longer than length it is truncated.

Pads string by adding fill to the left of string to make it length. If string is longer than length it is truncated.

Removes any characters included in trim_chars from the beginning (left-hand side) of input (applies recursively).

For example, ltrim('doggie', 'od') returns ggie.

Removes all spaces from the beginning (left-hand side) of val.

Calculates the MD5 hash value of a set of values.

Calculates the MD5 hash value of a set of values.

Calculates the number of bytes used to represent val.

Calculates the number of bytes used to represent val.

Calculates the number of bits used to represent val.

Replaces characters in input with overlay_val starting at start_pos (begins at 1).

For example, overlay('doggie', 'CAT', 2) returns dCATie.

Deletes the characters in input between start_pos and end_pos (count starts at 1), and then insert overlay_val at start_pos.

Returns the collation of the argument

Return val suitably quoted to serve as identifier in a SQL statement.

Return val suitably quoted to serve as string literal in a SQL statement.

Coerce val to a string and then quote it as a literal.

Coerce val to a string and then quote it as a literal. If val is NULL, returns ‘NULL’.

Coerce val to a string and then quote it as a literal. If val is NULL, returns ‘NULL’.

Returns the first match for the Regular Expression regex in input.

Replaces matches for the Regular Expression regex in input with the Regular Expression replace.

Replaces matches for the regular expression regex in input with the regular expression replace using flags.

CockroachDB supports the following flags:

Concatenates input repeat_counter number of times.

For example, repeat('dog', 2) returns dogdog.

Replaces all occurrences of find with replace in input

Reverses the order of the string’s characters.

Returns the last return_set bytes from input.

Returns the last return_set characters from input.

Pads string to length by adding ’ ’ to the right of string. If string is longer than length it is truncated.

Pads string to length by adding fill to the right of string. If string is longer than length it is truncated.

Removes any characters included in trim_chars from the end (right-hand side) of input (applies recursively).

For example, rtrim('doggie', 'ei') returns dogg.

Removes all spaces from the end (right-hand side) of val.

Updates a bit at given index in the bit array.

Updates a bit at given index in the byte array.

Calculates the SHA1 hash value of a set of values.

Calculates the SHA1 hash value of a set of values.

Calculates the SHA256 hash value of a set of values.

Calculates the SHA256 hash value of a set of values.

Calculates the SHA512 hash value of a set of values.

Calculates the SHA512 hash value of a set of values.

Splits input on delimiter and return the value in the return_index_pos position (starting at 1).

For example, split_part('123.456.789.0','.',3)returns 789.

Calculates the position where the string find begins in input.

For example, strpos('doggie', 'gie') returns 4.

Returns a substring of input that matches the regular expression regex.

Returns a substring of input that matches the regular expression regex using escape_char as your escape character instead of </code>.

Returns a substring of input starting at start_pos (count starts at 1).

Returns a substring of input starting at start_pos (count starts at 1) and including up to length characters.

Returns a substring of input that matches the regular expression regex.

Returns a substring of input that matches the regular expression regex using escape_char as your escape character instead of </code>.

Returns a substring of input starting at start_pos (count starts at 1).

Returns a substring of input starting at start_pos (count starts at 1) and including up to length characters.

This function enunciates the value of its argument using English cardinals.

Converts val to its hexadecimal representation.

Converts val to its hexadecimal representation.

Converts val to its hexadecimal representation.

Converts the character string representation of an IP to its byte string representation.

Converts the character string representation of a UUID to its byte string representation.

In input, replaces the first character from find with the first character in replace; repeat for each character in find.

For example, translate('doggie', 'dog', '123'); returns 1233ie.

Converts all characters in val to their to their upper-case equivalents.

Returns the logical time of the current transaction.

This function is reserved for testing purposes by CockroachDB developers and its definition may change without prior notice.

Note that uses of this function disable server-side optimizations and may increase either contention or retry errors, or both.

Runs a consistency check on ranges touching the specified key range. an empty start or end key is treated as the minimum and maximum possible, respectively. stats_only should only be set to false when targeting a small number of ranges to avoid overloading the cluster. Each returned row contains the range ID, the status (a roachpb.CheckConsistencyResponse_Status), and verbose detail.

Example usage: SELECT * FROM crdb_internal.check_consistency(true, ‘\x02’, ‘\x04’)

Returns the cluster ID.

Returns the cluster name.

This function is used only by CockroachDB’s developers for testing purposes.

Generate the key for a row on a particular table and index.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used only by CockroachDB’s developers for testing purposes.

Retrieves the current user’s admin status.

This function is used to fetch the leaseholder corresponding to a request key

Returns the value of the specified locality key.

This function is used only by CockroachDB’s developers for testing purposes.

Returns the version of CockroachDB this node is running.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used only by CockroachDB’s developers for testing purposes.

This function is used to retrieve range statistics information as a JSON object.

This function is used internally to round decimal values during mutations.

This function is used internally to round decimal array values during mutations.

Set the equivalent of the --vmodule flag on the gateway node processing this request; it affords control over the logging verbosity of different files. Example syntax: crdb_internal.set_vmodule('recordio=2,file=1,gfs*=3'). Reset with: crdb_internal.set_vmodule(''). Raising the verbosity can severely affect performance.

Returns the current database.

Returns the current schema.

Returns the valid schemas in the search path.

Returns the current user. This function is provided for compatibility with PostgreSQL.

Returns the node’s version of CockroachDB.

Returns the current transaction’s time with no time zone.

Returns the current transaction’s time with time zone.

This function is the preferred overload and will be evaluated by default.

Returns the current transaction’s time with no time zone.

Returns the current transaction’s time with time zone.

This function is the preferred overload and will be evaluated by default.

Returns the current transaction’s time with no time zone.

This function is the preferred overload and will be evaluated by default.

Returns the current transaction’s time with time zone.

Returns the current transaction’s time with no time zone.

This function is the preferred overload and will be evaluated by default.

Returns the current transaction’s time with time zone.

Returns the row as a JSON object.

Returns the SQL name of a data type that is identified by its type OID and possibly a type modifier. Currently, the type modifier is ignored.

Returns the current encoding name used by the database.

Returns whether or not the current user has privileges for any column of table.

Returns whether or not the current user has privileges for any column of table.

Returns whether or not the user has privileges for any column of table.

Returns whether or not the user has privileges for any column of table.

Returns whether or not the user has privileges for any column of table.

Returns whether or not the user has privileges for any column of table.

Returns whether or not the current user has privileges for column.

Returns whether or not the current user has privileges for column.

Returns whether or not the current user has privileges for column.

Returns whether or not the current user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the user has privileges for column.

Returns whether or not the current user has privileges for database.

Returns whether or not the current user has privileges for database.

Returns whether or not the user has privileges for database.

Returns whether or not the user has privileges for database.

Returns whether or not the user has privileges for database.

Returns whether or not the user has privileges for database.

Returns whether or not the current user has privileges for foreign-data wrapper.

Returns whether or not the current user has privileges for foreign-data wrapper.

Returns whether or not the user has privileges for foreign-data wrapper.

Returns whether or not the user has privileges for foreign-data wrapper.

Returns whether or not the user has privileges for foreign-data wrapper.

Returns whether or not the user has privileges for foreign-data wrapper.

Returns whether or not the current user has privileges for function.

Returns whether or not the current user has privileges for function.

Returns whether or not the user has privileges for function.

Returns whether or not the user has privileges for function.

Returns whether or not the user has privileges for function.

Returns whether or not the user has privileges for function.

Returns whether or not the current user has privileges for language.

Returns whether or not the current user has privileges for language.

Returns whether or not the user has privileges for language.

Returns whether or not the user has privileges for language.

Returns whether or not the user has privileges for language.

Returns whether or not the user has privileges for language.

Returns whether or not the current user has privileges for schema.

Returns whether or not the current user has privileges for schema.

Returns whether or not the user has privileges for schema.

Returns whether or not the user has privileges for schema.

Returns whether or not the user has privileges for schema.

Returns whether or not the user has privileges for schema.

Returns whether or not the current user has privileges for sequence.

Returns whether or not the current user has privileges for sequence.

Returns whether or not the user has privileges for sequence.

Returns whether or not the user has privileges for sequence.

Returns whether or not the user has privileges for sequence.

Returns whether or not the user has privileges for sequence.

Returns whether or not the current user has privileges for foreign server.

Returns whether or not the current user has privileges for foreign server.

Returns whether or not the user has privileges for foreign server.

Returns whether or not the user has privileges for foreign server.

Returns whether or not the user has privileges for foreign server.

Returns whether or not the user has privileges for foreign server.

Returns whether or not the current user has privileges for table.

Returns whether or not the current user has privileges for table.

Returns whether or not the user has privileges for table.

Returns whether or not the user has privileges for table.

Returns whether or not the user has privileges for table.

Returns whether or not the user has privileges for table.

Returns whether or not the current user has privileges for tablespace.

Returns whether or not the current user has privileges for tablespace.

Returns whether or not the user has privileges for tablespace.

Returns whether or not the user has privileges for tablespace.

Returns whether or not the user has privileges for tablespace.

Returns whether or not the user has privileges for tablespace.

Returns whether or not the current user has privileges for type.

Returns whether or not the current user has privileges for type.

Returns whether or not the user has privileges for type.

Returns whether or not the user has privileges for type.

Returns whether or not the user has privileges for type.

Returns whether or not the user has privileges for type.

Converts an integer to an OID.

pg_sleep makes the current session’s process sleep until seconds seconds have elapsed. seconds is a value of type double precision, so fractional-second delays can be specified.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Aggregates the selected values into an array.

Calculates the average of the selected values.

Calculates the average of the selected values.

Calculates the average of the selected values.

Calculates the average of the selected values.

Calculates the bitwise AND of all non-null input values, or null if none.

Calculates the bitwise OR of all non-null input values, or null if none.

Calculates the boolean value of ANDing all selected values.

Calculates the boolean value of ORing all selected values.

Concatenates all selected values.

Concatenates all selected values.

Calculates the correlation coefficient of the selected values.

Calculates the correlation coefficient of the selected values.

Calculates the correlation coefficient of the selected values.

Calculates the correlation coefficient of the selected values.

Calculates the number of selected elements.

Calculates the number of rows.

Calculates the boolean value of ANDing all selected values.

Aggregates values as a JSON or JSONB array.

Aggregates values as a JSON or JSONB array.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the maximum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Identifies the minimum selected value.

Calculates the sum of squared differences from the mean of the selected values.

Calculates the sum of squared differences from the mean of the selected values.

Calculates the sum of squared differences from the mean of the selected values.

Calculates the standard deviation of the selected values.

Calculates the standard deviation of the selected values.

Calculates the standard deviation of the selected values.

Calculates the standard deviation of the selected values.

Calculates the standard deviation of the selected values.

Calculates the standard deviation of the selected values.

Concatenates all selected values using the provided delimiter.

Concatenates all selected values using the provided delimiter.

Calculates the sum of the selected values.

Calculates the sum of the selected values.

Calculates the sum of the selected values.

Calculates the sum of the selected values.

Calculates the sum of the selected values.

Calculates the variance of the selected values.

Calculates the variance of the selected values.

Calculates the variance of the selected values.

Calculates the bitwise XOR of the selected values.

Calculates the bitwise XOR of the selected values.

Calculates the relative rank of the current row: (number of rows preceding or peer with current row) / (total rows).

Calculates the rank of the current row without gaps; this function counts peer groups.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the row that is the first row of the window frame.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the previous row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows before the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the row that is the last row of the window frame.

Returns val evaluated at the following row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the following row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the following row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the following row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.

Returns val evaluated at the following row within current row’s partition; if there is no such row, instead returns null.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such row, instead returns null. n is evaluated with respect to the current row.

Returns val evaluated at the row that is n rows after the current row within its partition; if there is no such, row, instead returns default (which must be of the same type as val). Both n and default are evaluated with respect to the current row.