Alphabetical SQL Functions List

function name category name function description abs docid\ saa2re dvaqcs gtjp3ps math functions returns the absolute value of a specified floating point number abs docid\ nhymyoadealtcppijauc5 matrix functions returns the magnitude of one dimensional matrix or vector acos docid\ saa2re dvaqcs gtjp3ps math functions returns the inverse cosine of a specified floating point number acosh docid\ saa2re dvaqcs gtjp3ps math functions returns the hyperbolic arc cosine of a specified floating point number add months docid\ hem zd qwquv8dfnvnqz8 date and time functions adds the specified number of months to the date any value docid\ roka1ck6hndmod1smej1s aggregate functions returns an arbitrary, non null value from the input column approx count distinct docid\ roka1ck6hndmod1smej1s aggregate functions approximate distinct count by using hyper log log (95% confidence interval that the value is within 4 5%) approx sum docid\ roka1ck6hndmod1smej1s aggregate functions allows the aggregation engine to use a faster, non deterministic ordering to summate floating point columns array\[] docid\ xuk0z8dmxpgmogszpdw6w array functions postgresql® compliant constructor the type of the array is deduced from the elements array agg docid\ xa9jf8l59tk 4facsfczh sorted aggregate functions returns an array containing every row from the expression array append docid\ xuk0z8dmxpgmogszpdw6w array functions add value to the back of an array array argmax docid\ xuk0z8dmxpgmogszpdw6w array functions returns the corresponding argmax of the array as a bigint index array argmin docid\ xuk0z8dmxpgmogszpdw6w array functions returns the corresponding argmin of the array as a bigint index array cat docid\ xuk0z8dmxpgmogszpdw6w array functions concatenate 2 arrays into a new one array cat distinct docid\ xuk0z8dmxpgmogszpdw6w array functions concatenates two or more arrays in the order of the input arguments array cap docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions restrict the length of an array to a maximum number of elements array compact docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions removes null values from the array array concat agg docid\ xa9jf8l59tk 4facsfczh sorted aggregate functions returns an array that concatenates arrays across rows array contains docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions returns true if the array contains the specified value array distinct docid\ xuk0z8dmxpgmogszpdw6w array functions removes duplicates from an array while preserving the first occurrence order array length docid\ xuk0z8dmxpgmogszpdw6w array functions return the number of elements of a given array array max docid\ xuk0z8dmxpgmogszpdw6w array functions returns the corresponding maximum of the array array min docid\ xuk0z8dmxpgmogszpdw6w array functions returns the corresponding minimum of the array array position docid\ xuk0z8dmxpgmogszpdw6w array functions returns the position of the first matching scalar in the array array positions docid\ xuk0z8dmxpgmogszpdw6w array functions returns all elements stored in the right array and returns their respective positions in the left array array prepend docid\ xuk0z8dmxpgmogszpdw6w array functions add value to the front of an array array remove docid\ xuk0z8dmxpgmogszpdw6w array functions r emove value from the array array replace docid\ xuk0z8dmxpgmogszpdw6w array functions r eplace value by another in an array array sort docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions sort and return the input array based on the natural ordering of its elements or the specified lambda function array sum docid\ xuk0z8dmxpgmogszpdw6w array functions returns the sum of the array the array must be one dimensional and contain numeric values null values do not contribute to the sum array to string docid\ xuk0z8dmxpgmogszpdw6w array functions converts array to a list of elements separated by 'delimiter' ascii docid\ ja8cont33tonx ktruedj character and binary functions returns the ascii code value of the leftmost character of the character value asin docid\ saa2re dvaqcs gtjp3ps math functions returns the inverse sine of a specified floating point number asinh docid\ saa2re dvaqcs gtjp3ps math functions returns the hyperbolic arc sine of a specified floating point number atan docid\ saa2re dvaqcs gtjp3ps math functions returns the inverse tangent of a specified floating point number atan2 docid\ saa2re dvaqcs gtjp3ps math functions returns the inverse tangent of two numeric, floating point values atanh docid\ saa2re dvaqcs gtjp3ps math functions returns the hyperbolic arc tangent of a specified floating point number avg docid\ roka1ck6hndmod1smej1s aggregate functions average, or arithmetic mean, over the set bicdf docid\ saa2re dvaqcs gtjp3ps math functions the cumulative distribution function of the standard bivariate normal distribution bigint docid\ iteimff9ycez0ctcfgqb scalar data conversion functions casts the argument to a value of type bigint binary docid\ iteimff9ycez0ctcfgqb scalar data conversion functions parses a hexadecimal string (such as 0x54ab) to create a binary value letters can be of either case bipdf docid\ saa2re dvaqcs gtjp3ps math functions the probability density function of the standard bivariate normal distribution bit length docid\ ja8cont33tonx ktruedj character and binary functions returns the length of the character value in bits bitand docid\ saa2re dvaqcs gtjp3ps math functions alias for the bitfunc syntax bitfunc('and', x, y) bitfunc docid\ saa2re dvaqcs gtjp3ps math functions performs a variety of bit operations can be any of these string literals 'and' , 'or' , or 'xor' bitnot docid\ saa2re dvaqcs gtjp3ps math functions returns the bitwise negation of integral x bitor docid\ saa2re dvaqcs gtjp3ps math functions alias for the bitfunc syntax bitfunc('or', x, y) bitxor docid\ saa2re dvaqcs gtjp3ps math functions alias for the bitfunc syntax bitfunc('xor', x, y) booland docid\ saa2re dvaqcs gtjp3ps math functions alias for the boolfunc syntax boolfunc('and', x, y) boolean docid\ iteimff9ycez0ctcfgqb scalar data conversion functions parses a string to create a boolean value the string must contain either true or false it is case insensitive boolfunc docid\ saa2re dvaqcs gtjp3ps math functions performs a boolean logical evaluation on arguments x and y can be any of these string literals 'and' , 'or' , or 'xor' boolnot docid\ saa2re dvaqcs gtjp3ps math functions returns the logical negation of the boolfunc function boolor docid\ saa2re dvaqcs gtjp3ps math functions alias for the boolfunc syntax boolfunc('or', x, y) boolxor docid\ saa2re dvaqcs gtjp3ps math functions alias for the boolfunc syntax boolfunc('xor', x, y) btrim docid\ ja8cont33tonx ktruedj character and binary functions alias for trim byte docid\ iteimff9ycez0ctcfgqb scalar data conversion functions casts the argument to a value of type byte cancel docid\ sxjfpnzfaa2gpkwiq3lv7 query management cancels a running query based on its specific query identifier case docid\ d5nz44sy24y5 bp ygu7d conditional functions case operates similarly to conditional scripting in other programming languages, allowing it to function like an if / then / else statement or as a switch statement case when docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions returns the result value based on whether an expression is true cast to array docid\ xuk0z8dmxpgmogszpdw6w array functions casts the elements of the array to another type cast to tuple docid\ mrrm7nwt xwcg zvmy6 p tuple functions converts a tuple into another tuple of a different type cbrt docid\ saa2re dvaqcs gtjp3ps math functions returns the cube root of the numeric value x cdf docid\ saa2re dvaqcs gtjp3ps math functions the cumulative distribution function of the standard normal distribution returns the probability that a random sample is less than or equal to the specified value ceil docid\ saa2re dvaqcs gtjp3ps math functions returns the nearest integer greater than or equal to x ceiling docid\ saa2re dvaqcs gtjp3ps math functions alias for ceil century docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the number of centuries char docid\ xuk0z8dmxpgmogszpdw6w array functions converts array to its string representation char docid\ iteimff9ycez0ctcfgqb scalar data conversion functions creates a string version of the numeric value char docid\ mrrm7nwt xwcg zvmy6 p tuple functions converts a tuple to its string representation char length docid\ ja8cont33tonx ktruedj character and binary functions alias for length character length docid\ ja8cont33tonx ktruedj character and binary functions alias for length chr docid\ ja8cont33tonx ktruedj character and binary functions converts an integer value to a string coalesce docid\ d5nz44sy24y5 bp ygu7d conditional functions evaluates to the first argument that is not null, or null if all arguments are null commit docid\ d5nz44sy24y5 bp ygu7d system functions returns the most recent commit hash of the database to which the client is currently connected concat docid\ ja8cont33tonx ktruedj character and binary functions concatenates two values, which must both be either binary, hash, or string data types this function is equivalent to the || operator convert local timestamp to utc docid\ iwtcunl3t9rlghwvu2dsx time zone functions the function converts a timestamp in a specified local time zone to the utc time zone convert utc timestamp to local docid\ iwtcunl3t9rlghwvu2dsx time zone functions the function converts a timestamp from the utc time zone to a specified local time zone corr docid\ roka1ck6hndmod1smej1s aggregate functions alias for correlation correlation docid\ roka1ck6hndmod1smej1s aggregate functions sample correlation correlationp docid\ roka1ck6hndmod1smej1s aggregate functions population correlation cos docid\ saa2re dvaqcs gtjp3ps math functions returns the cosine of x cosh docid\ saa2re dvaqcs gtjp3ps math functions returns the hyperbolic cosine of x cot docid\ saa2re dvaqcs gtjp3ps math functions returns the cotangent of x count docid\ roka1ck6hndmod1smej1s aggregate functions number of rows in the set covar pop docid\ roka1ck6hndmod1smej1s aggregate functions alias for covariancep covar samp docid\ roka1ck6hndmod1smej1s aggregate functions alias for covariance covariance docid\ roka1ck6hndmod1smej1s aggregate functions sample covariance covariancep docid\ roka1ck6hndmod1smej1s aggregate functions population covariance cross entropy loss docid\ xuk0z8dmxpgmogszpdw6w array functions returns the cross entropy loss of two arrays cross entropy loss docid\ nhymyoadealtcppijauc5 matrix functions returns the cross entropy loss of two one dimensional matrixes or vectors cume dist docid\ knh6ndwnm hzuab9dwzrz window aggregate functions returns a number 0 < n 1 and can be used to calculate the percentage of values less than or equal to the current value in the group curdate docid\ hem zd qwquv8dfnvnqz8 date and time functions alias for current date current database docid\ d5nz44sy24y5 bp ygu7d system functions alias for database current date docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the current date in the format yyyy mm dd current groups docid\ d5nz44sy24y5 bp ygu7d system functions returns the fully qualified names of groups in the database current node docid\ d5nz44sy24y5 bp ygu7d system functions returns the name of the sql node where the current query executes the name of the node corresponds to the name column in the sys nodes system catalog table current node id docid\ d5nz44sy24y5 bp ygu7d system functions returns the identifier of the sql node where the current query executes current schema docid\ d5nz44sy24y5 bp ygu7d system functions returns the name of the current schema current session id docid\ d5nz44sy24y5 bp ygu7d system functions returns the universally unique identifier (uuid) of the current session current system docid\ d5nz44sy24y5 bp ygu7d system functions returns the name of the system current time docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the current time as a time value (e g , hh\ mm\ ss mm ) current timestamp docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the current date and time as a timestamp value (e g , yyyy mm dd hh🇲🇲ss mmm) current user docid\ d5nz44sy24y5 bp ygu7d system functions returns the user for the current connection database docid\ d5nz44sy24y5 bp ygu7d system functions returns the name of the database to which the client is currently connected date docid\ iteimff9ycez0ctcfgqb scalar data conversion functions parses a string in the form 'yyyy mm dd' to create a date extra characters are ignored date part docid\ hem zd qwquv8dfnvnqz8 date and time functions alias for extract date trunc docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the date or timestamp entered, truncated to the specified precision dateadd docid\ hem zd qwquv8dfnvnqz8 date and time functions adds a specified number value (as a signed integer) to a specified date part of an input date value, and then returns that modified value datediff docid\ hem zd qwquv8dfnvnqz8 date and time functions this function returns an int representing the difference between two date or time values in a specified date or time unit day docid\ hem zd qwquv8dfnvnqz8 date and time functions alias for day of month day of month docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the day of month portion of a timestamp or date as an integer day of week docid\ hem zd qwquv8dfnvnqz8 date and time functions returns an integer, in the range of 1 to 7, that represents the day of the week day of year docid\ hem zd qwquv8dfnvnqz8 date and time functions returns an integer in the range 1 to 366 that represents the day of the year days docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type days to be used in date calculations decade docid\ hem zd qwquv8dfnvnqz8 date and time functions the decade is the year divided by 10 decimal docid\ iteimff9ycez0ctcfgqb scalar data conversion functions casts the argument to a value of type decimal degrees docid\ saa2re dvaqcs gtjp3ps math functions returns the corresponding angle in degrees for x in radians delta docid\ knh6ndwnm hzuab9dwzrz window aggregate functions computes the finite difference between successive values of expression under the specified ordering this is a backwards difference, which means that, at degree one, the value for a given row is the difference between the value of expression for that row and the previous row dense rank docid\ knh6ndwnm hzuab9dwzrz window aggregate functions assigns a number to each row in the result set with equal values having the same number there will be no gaps between ranks derivative docid\ knh6ndwnm hzuab9dwzrz window aggregate functions computes the difference quotient between successive values of expression with respect to expression2 det docid\ nhymyoadealtcppijauc5 matrix functions returns the determinant of the matrix as a double div docid\ saa2re dvaqcs gtjp3ps math functions returns the result of x divided by y if y is zero, returns null dot docid\ nhymyoadealtcppijauc5 matrix functions returns dot product of two one dimensional matrixes/vectors double docid\ iteimff9ycez0ctcfgqb scalar data conversion functions casts the argument to a value of type double dow docid\ hem zd qwquv8dfnvnqz8 date and time functions alias for day of week doy docid\ hem zd qwquv8dfnvnqz8 date and time functions alias for day of year eigen docid\ nhymyoadealtcppijauc5 matrix functions returns eigenvalues and eigenvalues of a square matrix as a vector of pairs element at docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions returns the element value of the array or tuple at the specified index endswith docid\ ja8cont33tonx ktruedj character and binary functions returns true if x ends with y and false otherwise eomonth docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the last day of the timestamp or date epoch docid\ hem zd qwquv8dfnvnqz8 date and time functions the number of seconds after 1970 01 01 00 00 00 utc erf docid\ saa2re dvaqcs gtjp3ps math functions the error function is used for measurements that follow a normal distribution erfc docid\ saa2re dvaqcs gtjp3ps math functions the complement of the error function erfc(x) = 1 erf(x) exp docid\ saa2re dvaqcs gtjp3ps math functions returns the exponential of x (e raised to the power of x) explode outer docid\ od i nse3vcplc3nixzgc special data pipeline transformation functions expands a one dimensional or multidimensional array into its elements with one element per row of output from the system extract docid\ hem zd qwquv8dfnvnqz8 date and time functions extract a component from a timestamp or date filter docid\ od i nse3vcplc3nixzgc special data pipeline transformation functions filters elements in an array based on the logic in a lambda expression first value docid\ knh6ndwnm hzuab9dwzrz window aggregate functions returns the first value in the ordered result set flatten docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions transforms an n dimensional array into an n 1 dimensional array float docid\ iteimff9ycez0ctcfgqb scalar data conversion functions casts the argument to a value of type float floor docid\ saa2re dvaqcs gtjp3ps math functions returns the nearest integer less than or equal to x frobenius docid\ nhymyoadealtcppijauc5 matrix functions and operators returns the frobenius norm of a matrix gamma docid\ saa2re dvaqcs gtjp3ps math functions gamma function https //en wikipedia org/wiki/gamma function greatest docid\ d5nz44sy24y5 bp ygu7d conditional functions returns the largest non null value of all the arguments, or null if all the arguments are null hash docid\ iteimff9ycez0ctcfgqb scalar data conversion functions creates a fixed length binary value, with length \<length> , from a string, i e 0x1234abcd zero extended if the string does not have enough bytes, truncated if it has too many hexbinx docid\ saa2re dvaqcs gtjp3ps math functions returns the x coordinate of the center of the nearest hexagonal bin to the point (x, y) hexbiny docid\ saa2re dvaqcs gtjp3ps math functions returns the y coordinate of the center of the nearest hexagonal bin to the point (x, y) hinge loss docid\ xuk0z8dmxpgmogszpdw6w array functions returns the hinge loss of two arrays hinge loss docid\ nhymyoadealtcppijauc5 matrix functions returns the hinge loss of two one dimensional matrixes or vectors hll sketch create docid\ phb7ceh0zkhenc5beasgb hyperloglog functions creates an hll sketch from the data on a specified aggregated column returns a hash((2^log2k) + 8) data representation of the sketch that you can store in a separate column hll sketch get estimate docid\ phb7ceh0zkhenc5beasgb hyperloglog functions the scalar function converts a sketch into a distinct count estimate of a sketch value returns the distinct count estimate as a bigint hll sketch get estimate bound docid\ phb7ceh0zkhenc5beasgb hyperloglog functions takes a hll sketch column or an integral log2k literal value and returns the resulting bounding 95 percent confidence interval error proportion as a double hll sketch to string docid\ phb7ceh0zkhenc5beasgb hyperloglog functions the hll sketch to string scalar function takes a hll sketch column or value and returns a string summary of the sketch hll sketch union (aggregate function) docid\ phb7ceh0zkhenc5beasgb hyperloglog functions merges multiple sketches in a single column into a unified sketch all sketches must have the same precision this function is an aggregate function and operates on a column hll sketch union (scalar function) docid\ phb7ceh0zkhenc5beasgb hyperloglog functions merges two sketches into a new combined sketch this function is a scalar function and operates row wise the scalar function merges two sketch columns with heterogeneous precisions into a sketch with the lower of the two precisions hour docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the hour portion of a timestamp as an integer hours docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type hours identity matrix docid\ nhymyoadealtcppijauc5 matrix functions returns an identity matrix of the specified dimension ierf docid\ saa2re dvaqcs gtjp3ps math functions the inverse of the erf error function ierfc docid\ saa2re dvaqcs gtjp3ps math functions the inverse of the complement of the error function if docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions returns t if the expression x evaluates to true , or the function returns f if x evaluates to false if null docid\ d5nz44sy24y5 bp ygu7d conditional functions alias for coalesce initcap docid\ ja8cont33tonx ktruedj character and binary functions for each word in the provided string, capitalize the first character if it is alphabetic instr docid\ ja8cont33tonx ktruedj character and binary functions returns the index position of the first occurrence where the character value char substring appears in the character value char by ignoring case integer docid\ iteimff9ycez0ctcfgqb scalar data conversion functions casts the argument to a value of type integer inverse docid\ nhymyoadealtcppijauc5 matrix functions returns inverse of a square, invertible matrix ip docid\ ezupx17nbsz6c4g5e7o o network type functions casts an ip data type from an ipv4 data type expression ipv4 docid\ ezupx17nbsz6c4g5e7o o network type functions casts an ipv4 address from an ipv6 address isdate docid\ hem zd qwquv8dfnvnqz8 date and time functions returns true if the input argument can be successfully cast to a date is ipv4 docid\ ezupx17nbsz6c4g5e7o o network type functions t ests whether the database can convert the ip value to the ipv4 data type isodow docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the day of the week based on iso 8601, which ranges from monday (1) to sunday (7) json extract path text docid\ ja8cont33tonx ktruedj character and binary functions returns the value for the key value pair referenced by a series of path elements in a json string kill docid\ sxjfpnzfaa2gpkwiq3lv7 query management cancels a running query based on its specific query identifier kurtosis docid\ roka1ck6hndmod1smej1s aggregate functions the sample over the set kurtosisp docid\ roka1ck6hndmod1smej1s aggregate functions the population over the set lag docid\ knh6ndwnm hzuab9dwzrz window aggregate functions returns the row, which is the specified number backward from the current row default is 1 if offset is omitted lag vectors docid\ vrwcjklivsomyas4ude8b data preparation groups lagged columns generated by the multi lags or multi lags zerofill functions into vector columns lags docid\ vrwcjklivsomyas4ude8b data preparation generates a series of lagged columns for a single variable in one statement lags zerofill docid\ vrwcjklivsomyas4ude8b data preparation generates lagged columns for a single variable and replaces null values with 0 last value docid\ knh6ndwnm hzuab9dwzrz window aggregate functions returns the last value in the ordered result set lcase docid\ ja8cont33tonx ktruedj character and binary functions alias for lower lead docid\ knh6ndwnm hzuab9dwzrz window aggregate functions returns the row, which is the specified number forward from the current row default is 1 if offset is omitted leakyrelu docid\ saa2re dvaqcs gtjp3ps math functions returns the leaky rectified linear unit function of x least docid\ d5nz44sy24y5 bp ygu7d conditional functions returns the smallest non null value of all arguments, or null if all arguments are null left docid\ ja8cont33tonx ktruedj character and binary functions return the number of characters in the string equal to the value integer if the integer is negative, the function returns all but the last integer characters left shift docid\ saa2re dvaqcs gtjp3ps math functions returns x shifted to the left by y bits length docid\ ja8cont33tonx ktruedj character and binary functions for character data types, this value is in terms of characters for binary data types, this value is in terms of bytes ln docid\ saa2re dvaqcs gtjp3ps math functions returns the natural logarithm of x locate docid\ ja8cont33tonx ktruedj character and binary functions alias for position returns the index position of the first occurrence of the character value substring in the character value string log docid\ saa2re dvaqcs gtjp3ps math functions returns the base 10 logarithm of x the optional base argument specifies the numeral system to use if unspecified, the function defaults to base 10 log gamma docid\ saa2re dvaqcs gtjp3ps math functions the natural logarithm of the absolute value of the gamma function log loss docid\ xuk0z8dmxpgmogszpdw6w array functions returns the log loss of two arrays log loss docid\ nhymyoadealtcppijauc5 matrix functions returns the log loss of two one dimensional matrixes or vectors log2 docid\ saa2re dvaqcs gtjp3ps math functions returns the base 2 logarithm of x logits loss docid\ xuk0z8dmxpgmogszpdw6w array functions returns the logits loss of two arrays logits loss docid\ nhymyoadealtcppijauc5 matrix functions returns the logits loss of two one dimensional matrixes or vectors lookup docid\ sqe54e3n2rmv0mfbh7pme special data pipeline transformation functions look up and load data in an external data source lower docid\ ja8cont33tonx ktruedj character and binary functions alias for lcase convert string to lowercase lpad docid\ ja8cont33tonx ktruedj character and binary functions pad the input text to the specified length with the pad string on the left side ltrim docid\ ja8cont33tonx ktruedj character and binary functions removes leading blanks from the string value string lupq decomp docid\ nhymyoadealtcppijauc5 matrix functions returns lupq decomposition of a square matrix a as a tuple of 4 matrixes where paq = lu map keys docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions returns the keys in the specified json string map values docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions returns the values in the specified json string matrix dim docid\ nhymyoadealtcppijauc5 matrix functions returns the dimensions of the specified matrix as a tuple of (row, col) integers make matrix ixj docid\ nhymyoadealtcppijauc5 matrix functions creates an ixj matrix with elements e 00 , … , e ij makedatetime docid\ hem zd qwquv8dfnvnqz8 date and time functions returns a timestamp consisting of the specified date and time matrix from text docid\ nhymyoadealtcppijauc5 matrix functions creates a matrix from the specified string matrix trace docid\ nhymyoadealtcppijauc5 matrix functions returns trace of a square matrix as a double max docid\ roka1ck6hndmod1smej1s aggregate functions maximum value in the specified column md5 docid\ ja8cont33tonx ktruedj character and binary functions returns the hexadecimal string (all lowercase) representing the md5 hash of char metadata docid\ vqvrmdyk8josxmkfsyprc special data pipeline transformation functions extracts the metadata value for the specified key from available metadata for the pipeline microseconds docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type microseconds mid docid\ ja8cont33tonx ktruedj character and binary functions alias for substring millisecond docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the millisecond portion of a timestamp as an integer milliseconds docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type milliseconds min docid\ roka1ck6hndmod1smej1s aggregate functions minimum value in the specified column minute docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the minute portion of a timestamp or date as an integer minutes docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type minutes mod docid\ saa2re dvaqcs gtjp3ps math functions returns the remainder from x divided by y month docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the month portion of a timestamp or date as an integer month name docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the calendar name in english of the month for the specified date months docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type months to be used in date calculations months between docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the difference between the two dates or timestamps in months as a double msecs docid\ hem zd qwquv8dfnvnqz8 date and time functions the seconds field, including fractional parts the function multiplies the seconds part of the value by 1,000 multi lags docid\ vrwcjklivsomyas4ude8b data preparation generates lagged columns for multiple variables at once multi lags zerofill docid\ vrwcjklivsomyas4ude8b data preparation generates lagged columns for multiple variables and replaces null values with 0 murmur3 docid\ d5nz44sy24y5 bp ygu7d conditional functions returns a 32 bit murmurhash3 hash of the input value as an integer data type https //github com/aappleby/smhasher/blob/master/readme md nanos to timestamp docid\ hem zd qwquv8dfnvnqz8 date and time functions convert a number of nanoseconds into a timestamp equivalent to the duration after the epoch time nanoseconds docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type nanoseconds next day docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the closest date after a specified date that lies on a specific day of the week now docid\ hem zd qwquv8dfnvnqz8 date and time functions alias for current timestamp nth value docid\ knh6ndwnm hzuab9dwzrz window aggregate functions returns the nth value in the ordered result set null if docid\ d5nz44sy24y5 bp ygu7d conditional functions returns the null value if two arguments are equal; otherwise, returns the first argument null matrix docid\ nhymyoadealtcppijauc5 matrix functions returns a null matrix of the given (row, col) dimensions octet length docid\ ja8cont33tonx ktruedj character and binary functions returns the length in bytes of a character or binary value parse delimited array docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions converts a string of text data representing an array into a char\[] percent rank docid\ knh6ndwnm hzuab9dwzrz window aggregate functions the value returned is 0 < n ≤ 1 and can be used to calculate the percentage of values less than the current group, excluding the highest value percentile docid\ knh6ndwnm hzuab9dwzrz window aggregate functions returns the value that corresponds to the specified percentile (0 ≤ n ≤ 1) within the group pi docid\ saa2re dvaqcs gtjp3ps math functions returns the constant value of π pmod docid\ saa2re dvaqcs gtjp3ps math functions returns the smallest non negative equivalence class of x % y position docid\ ja8cont33tonx ktruedj character and binary functions alias for locate power docid\ saa2re dvaqcs gtjp3ps math functions returns x raised to the power of y probit docid\ saa2re dvaqcs gtjp3ps math functions the inverse of the cumulative distribution function product docid\ roka1ck6hndmod1smej1s aggregate functions product over the set qr decomp docid\ nhymyoadealtcppijauc5 matrix functions returns qr decomposition of a matrix as a tuple of 2 matrixes quarter docid\ hem zd qwquv8dfnvnqz8 date and time functions returns an integer between 1 and 4 that represents the quarter of the year in which the specified date falls radians docid\ saa2re dvaqcs gtjp3ps math functions returns the corresponding angle in radians for x in degrees rand docid\ saa2re dvaqcs gtjp3ps math functions takes no argument and returns a random double value in the range \[0, 1) rand uuid docid\ d5nz44sy24y5 bp ygu7d other functions and expressions generates a random uuid value (version 4) rank docid\ knh6ndwnm hzuab9dwzrz window aggregate functions assigns a number to each row in the result set with equal values having the same number there can be gaps between ranks ratio to report docid\ knh6ndwnm hzuab9dwzrz window aggregate functions computes the ratio of a value to the sum of the set of values record uuid docid\ ekn3kd8le8nvgcgsdl1w0 other transformation functions returns string that represents a unique identifier for the record in a specified pipeline for a specified file group or topic reduce docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions applies a merge function to a starting value and all elements in the array, and then reduces the array to a single value optionally, specify a finish function for the returned single value regexp count docid\ ja8cont33tonx ktruedj character and binary functions searches a string for all occurrences of a regular expression pattern regexp instr docid\ ja8cont33tonx ktruedj character and binary functions searches a string using a regular expression pattern and returns an integer representing the start position or end position of the substring that matches regexp replace docid\ ja8cont33tonx ktruedj character and binary functions searches a string for all occurrences of a regular expression pattern regexp substr docid\ ja8cont33tonx ktruedj character and binary functions returns one substring from a string that matches a specified regular expression pattern relu docid\ saa2re dvaqcs gtjp3ps math functions returns the rectified linear unit function of x repeat docid\ ja8cont33tonx ktruedj character and binary functions repeats the character value char a number of times equal to num replace docid\ ja8cont33tonx ktruedj character and binary functions replaces all occurrences of substr to remove in the character value string with substr to replace reverse docid\ ja8cont33tonx ktruedj character and binary functions reverse the input string right docid\ ja8cont33tonx ktruedj character and binary functions return the number of trailing characters in the string equal to the value integer right shift docid\ saa2re dvaqcs gtjp3ps math functions returns x shifted to the right by y bits round docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the specified date or timestamp, rounded to the specified precision round docid\ saa2re dvaqcs gtjp3ps math functions returns x rounded to the nearest integer row number docid\ knh6ndwnm hzuab9dwzrz window aggregate functions assigns a unique number to each row in the result set rpad docid\ ja8cont33tonx ktruedj character and binary functions pad the input text to the specified length with the pad string on the right side rsubstring docid\ ja8cont33tonx ktruedj character and binary functions returns the substring from the right side of a string, based on a specified length rtrim docid\ ja8cont33tonx ktruedj character and binary functions removes leading blanks from the string value string second docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the seconds portion of a timestamp as an integer seconds docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type seconds sha1 docid\ ja8cont33tonx ktruedj character and binary functions uses the sha 1 https //en wikipedia org/wiki/sha 1# text=in%20cryptography%2c%20sha%2d1%20(,rendered%20as%2040%20hexadecimal%20digits cryptographic hash function to convert a string into a 40 character string representing the hexadecimal value of a 160 bit checksum show docid\ d5nz44sy24y5 bp ygu7d system functions the show function enables you to explore the database and its metadata for user defined items sign docid\ saa2re dvaqcs gtjp3ps math functions returns the positive (+1), zero (0), or negative ( 1) sign of x sin docid\ saa2re dvaqcs gtjp3ps math functions returns the sine of x sinh docid\ saa2re dvaqcs gtjp3ps math functions returns the hyperbolic sine of x skew docid\ roka1ck6hndmod1smej1s aggregate functions the sample over the set smallint docid\ iteimff9ycez0ctcfgqb scalar data conversion functions casts the argument to a value of type smallint softmax docid\ xuk0z8dmxpgmogszpdw6w array functions returns the softmax of the array softmax docid\ nhymyoadealtcppijauc5 matrix functions returns the softmax of a one dimensional matrix or vector space docid\ ja8cont33tonx ktruedj character and binary functions returns a string of repeated spaces equal to the number value, repeat split part docid\ ja8cont33tonx ktruedj character and binary functions split the value string based on the delimiter value the function returns a substring from the split operation based on the index value (starting from 1) split to array docid\ ja8cont33tonx ktruedj character and binary functions splits a string into an array of substrings sqrt docid\ saa2re dvaqcs gtjp3ps math functions returns the square root of x square docid\ saa2re dvaqcs gtjp3ps math functions returns the square of x st addpoint docid waxmx64wjb9bhjibuf8b geospatial linestring function adds a point to the given linestring at the specified 0 indexed location st angle docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement calculates the angle between two lines st area docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the area of the specified geospatial object in the specified unit of measurement st asbinary docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions returns the well known binary (wkb) representation of the specified geography alias of st aswkb st asewkt docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions returns a string that represents geographic coordinates of a specified point in the specified format st asgeojson docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions alias of st asbinary st aslatlontext docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions returns the geojson representation of the specified geography using the ietf standards https //datatracker ietf org/doc/html/rfc7946 st astext docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions alias of st astext st aswkb docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions alias of st astext st aswkt docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions alias of st aswkt and st ewkt returns the wkt representation of the specified geography st azimuth docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the azimuth of the line from point1 to point2 in radians st boundingdiagonal docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the diagonal linestring from the minimum point to the maximum point of the bounding box that st envelope returns st buffer docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a geography that contains all points where the distance from the geography is less than or equal to the specified distance st centroid docid 9nnprzt3hqeet7csvwwxe geospatial point constructors the geographic center of mass is calculated by taking the average of all points on a three dimensional sphere, projecting the resultant point onto the sphere, and converting it back to latitude and longitude coordinates st closestpoint docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the two dimensional point of one specified geospatial object that is closest to a second specified geospatial object st clusterdbscan docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns the cluster number for each input geography, based on a two dimensional implementation of the density based spatial clustering of applications with noise (dbscan) algorithm https //en wikipedia org/wiki/dbscan st contains docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the first geographic argument, geo1, contains the second geographic argument, geo2 st containsproperly docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if geo2 lies entirely in the interior of geo1, and does not intersect or touch the boundary or exterior points st convexhull docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators the convex hull is the smallest convex geometry that encloses the input geometry st coorddim docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions alias for st ndims or st ndimension returns an integer of the coordinate dimension of the specified geography st coveredby docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if no point in geo1 is outside of geo2 st covers docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if no point in geo2 is outside of geo1 st crosses docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if two geospatial objects meet these criteria the intersection of the geospatial interiors is not empty the intersection is not equal to geo1 or geo2 neither geospatial object is a single point st differencearray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns an array containing any geospatial objects that are present in the first specified geospatial argument that are not found in the second geospatial argument st dimension docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns an integer that represents the dimension of the specified geography st disjoint docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the specified geographies have no intersection, including boundaries both geographic arguments can be different types st distance docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the minimum distance between the specified arguments st distance docid\ z sg ji6rbv01v5wtlzz2 geospatial spatiotemporal measurement returns the two dimensional interpolated minimum simultaneous distance between two linestring timestamp array pairs in the specified unit of measurement st distancesphere docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the minimum distance between the specified arguments using a spherical computation st distancespheroid docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the minimum distance between the specified arguments using a spheroid computation st dwithin docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the geographies are within a specified distance in meters st endpoint docid waxmx64wjb9bhjibuf8b geospatial linestring function returns the endpoint of a specified linestring the returned value is a point st envelope docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a polygon that represents the minimum bounding box for the specified geography st equals docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if both geographies are spatially equal st euclideandistance3d docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the minimum distance between two geospatial points with altitude values st expand docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the bounding box of a specified geospatial value, which is expanded by a specified length st exteriorring docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a linestring that represents the exterior ring of a provided polygon value st flipcoordinates docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a new geographic object with the x and y coordinates switched using the specified argument st force2d docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators convert a geographic object into a two dimensional geography st forceccw docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors creates a standardized polygon from an existing one ocient® defines standardized as the exterior being counterclockwise (ccw) and all holes being clockwise (cw) oriented st geogpoint docid 9nnprzt3hqeet7csvwwxe geospatial point constructors creates and returns a polygon geography with a single point, defined by the longitude and latitude specified for the function st geohash docid\ ln31h9xuiniz 9q3nd0m geospatial conversion functions returns a string that represents the geohash of the input point st geometrytype docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns a string representing the geometry type of the input value st hausdorffdistance docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the hausdorff distance between two geographies in a specified measurement st interiorringn docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a linestring representing the interior ring of the specified polygon, which is specified by its index (1 indexed) st intersectall docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the intersection of all geographies in the specified array all geographies in the array must be the same type st intersection docid\ m7egwhp4eqnp5gr81gvwq geospatial spatiotemporal operators returns a tuple that represents the intersection of a spatiotemporal linestring with a static geography st intersectionarray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a geography that represents the point set intersection of two geographies st intersects docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the specified geographies have an intersection, including boundaries st isccw docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships alias for st ispolygonccw st isclosed docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if an input polygon has an exterior that is counter clockwise st isempty docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns true if the specified geography value is empty, such as 'polygon empty' st ispolygonccw docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if an input linestring has starting and ending points that are equal st ispolygoncw docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if an input polygon has an exterior that is clockwise st isring docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the specified linestring is closed and does not intersect itself st issimple docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships for linestring values, this function returns false if any line segments intersect anywhere besides the endpoints for polygon values, the function returns false if either the exterior ring or any interior hole is not simple st isvalid docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the specified geospatial value is a well formed and valid geography according to the ogc standards https //www ogc org/standard/sfa/ st length docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the length of the specified line in the specified measurement unit st length2d docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement alias for st length st linefromewkt docid\ ja2bwo8hlbgf8s2gffhvk geospatial linestring constructor creates a linestring from the specified char st linefromgeojson docid\ ja2bwo8hlbgf8s2gffhvk geospatial linestring constructor creates a linestring represented by the specified geojson st linefromtext docid\ ja2bwo8hlbgf8s2gffhvk geospatial linestring constructor creates a linestring from a specified char the char must be a linestring value in wkt format st linefromwkb docid\ ja2bwo8hlbgf8s2gffhvk geospatial linestring constructor creates a linestring from the specified binary the binary value must be a linestring in wkb format st linegetalltimesatpoint docid\ m7egwhp4eqnp5gr81gvwq geospatial spatiotemporal operators returns a timestamp array of all times when the specified linestring value intersects the specified point value st linegetpointattime docid\ m7egwhp4eqnp5gr81gvwq geospatial spatiotemporal operators returns a point within the bounds of the specified linestring that corresponds to the interpolated point at the specified timestamp value st linegettimeatpoint docid\ m7egwhp4eqnp5gr81gvwq geospatial spatiotemporal operators returns the interpolated time of the specified point on the specified linestring that is paired with a timestamp array st lineinterpolatepoint docid waxmx64wjb9bhjibuf8b geospatial linestring function returns a point along a linestring based on a specified fraction of its total length st linelocatepoint docid waxmx64wjb9bhjibuf8b geospatial linestring function similar to st lineinterpolatepoint, this function computes a fraction based on where a specified point is located along the length of a specified linestring st linestring docid\ ja2bwo8hlbgf8s2gffhvk geospatial linestring constructor creates a linestring based on the specified inputs st linesubstring docid waxmx64wjb9bhjibuf8b geospatial linestring function returns a linestring that is a substring of a specified line that starts and ends at the specified fractions of its total length st longestline docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the longest linestring between two given geospatial arguments st longestline docid\ m7egwhp4eqnp5gr81gvwq geospatial spatiotemporal operators with the specified two linestring timestamp array pairs, this function returns a two point linestring that represents the maximum distance between points at a concurrent time st makeenvelope docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a polygon with vertices that represent the minimum bounding box for the specified coordinates st makeline docid\ ja2bwo8hlbgf8s2gffhvk geospatial linestring constructor alias for st linestring st makepoint docid 9nnprzt3hqeet7csvwwxe geospatial point constructors alias for st point st makepolygon docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors alias for st polygon st maxdistance docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns maximum distance between the specified arguments st maxdistance docid\ z sg ji6rbv01v5wtlzz2 geospatial spatiotemporal measurement returns the two dimensional interpolated maximum cotemporal distance between two linestring timestamp array pairs in the specified unit of measurement st memsize docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns an integer representing the number of bytes in memory required to store the specified geography st minimumboundingcircle docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the smallest circle polygon that contains the specified geographic object st multidifferencearray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns an array of geographies that represents the parts of the union of the geographies in the first array that do not intersect with the union of geographies in the second array st minimumdistancetosurface docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement calculates the shortest distance between any point along a euclidean line segment in three dimensional space and the surface of the earth st multiintersectionarray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators when you specify two arrays of geospatial objects, this function returns an array of any intersections st multisymdifferencearray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators when you specify two arrays of geospatial objects, this function returns an array of any geospatial values that do not intersect st multiunionarray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators when you specify two arrays of geospatial objects, this function returns one array that represents a union of all geographies in both arrays st ndimension docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions alias for st coorddim st ndims docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions alias for st coorddim st npoints docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns an integer representing the number of point values in a specified geography st nrings docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the number of rings of the specified polygon, including both interior and exterior rings st numinteriorring docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the number of interior rings of the specified polygon st numinteriorrings docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the number of interior rings of the specified polygon st numpoints docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns an integer representing the number of point values in a specified geography st overlaps docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if both geographic arguments are of the same dimension and they intersect each other, but neither contains the other st perimeter docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement returns the length of the exterior (outer ring) of the polygon in the specified unit of measurement st perimeter2d docid\ vgbw5fb dtz1vzsb6lria geospatial spatial measurement alias for st perimeter st point docid 9nnprzt3hqeet7csvwwxe geospatial point constructors creates a point from the specified input arguments st pointfromewkt docid 9nnprzt3hqeet7csvwwxe geospatial point constructors alias for st point creates a point using an ewkt formatted char as an input argument st pointfromgeohash docid 9nnprzt3hqeet7csvwwxe geospatial point constructors creates a point represented by the specified geohash st pointfromgeojson docid 9nnprzt3hqeet7csvwwxe geospatial point constructors creates a point represented by the specified geojson value as an input argument st pointfromtext docid 9nnprzt3hqeet7csvwwxe geospatial point constructors alias for st point(char) st pointfromwkb docid 9nnprzt3hqeet7csvwwxe geospatial point constructors alias for st point(binary) st pointinsidecircle docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the geographic object is inside a circle that is centered at the specified point coordinates and with the specified radius st pointn docid waxmx64wjb9bhjibuf8b geospatial linestring function returns the point value at a specified index of the given linestring st pointonsurface docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a point guaranteed to intersect the specified geospatial object st polygon docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors creates a polygon st polygonfromewkt docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors creates a polygon using an ewkt formatted char as an input argument alias for the st polygon constructor st polygonfromgeojson docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors creates a polygon from the specified point, point array, linestring, or polygon geography st polygonfromtext docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors alias for st polygon(char) st polygonfromwkb docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors alias for st polygon(binary) st project docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a point by projecting a distance and an azimuth value from the specified starting point value st reduceprecision docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a new geospatial object with all point values rounded to the specified decimal precision st relate docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns the de 9im https //postgis net/workshops/postgis intro/de9im html intersection string that represents the nature of the intersection with the specified geographies st removepoint docid waxmx64wjb9bhjibuf8b geospatial linestring functions removes a point value at a specified index from the specified line st removerepeatedpoints docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a new geospatial object with no repeated point values st reverse docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a new geospatial object with the vertexes reversed st segmentize docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a geospatial object that the function modifies to have no segment longer than the specified max segment length in meters st setpoint docid waxmx64wjb9bhjibuf8b geospatial linestring functions replaces a point value in a given linestring at a specified index the function returns the altered linestring with the replaced point st shortestline docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns the shortest linestring between two specified geospatial arguments st shortestline docid\ m7egwhp4eqnp5gr81gvwq geospatial spatiotemporal operators when you specify two linestring timestamp array pairs, this function returns a linestring with two points that represents the minimum distance between points at a concurrent time st simplify docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a simplified version of the specified geography, which is either a point or linestring st simplifyarray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a polygon array that represents a simplified version of the specified geography, which is either a point, linestring, or polygon st snaptogrid docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a new geography value with all point values rounded to the specified precisions st srid docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns the epsg code of the spatial reference identifier (srid) of the input geography st startpoint docid waxmx64wjb9bhjibuf8b geospatial linestring functions returns the starting point value of the line st symdifferencearray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators returns a geographic array that contains the parts that are not common between two geographic objects, geo1 and geo2 st totalsecondsinintersection docid\ z sg ji6rbv01v5wtlzz2 geospatial spatiotemporal measurement returns the total number of seconds spent in the intersection result calculated by the spatiotemporal version of st intersection st touches docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships returns true if the only point values in common between the two geographic arguments lie in the union of their boundaries st unionarray docid\ pifo3jqjej4vo8mp3zkyd geospatial spatial operators performs a union of the input geography values to produce a geographic array st wholeearth docid 6s1zu ro01da1k 1py5xk geospatial polygon constructors returns the database internal representation of the whole earth polygon st within docid\ j48pdvqo xrpcwp eecyi geospatial spatial relationships alias for st contains st x docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns the x value of the specified point st xmax docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns the maximum x value of the specified geography st xmin docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns the minimum x value of the specified geography st y docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns the y value of the specified point st ymax docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns the maximum y value of specified geography st ymin docid 9c9mesl ut uqgh8qmpq9 geospatial attribute functions returns the minimum y value of specified geography startswith docid\ ja8cont33tonx ktruedj character and binary functions returns true if string starts with substring and false otherwise stddev docid\ roka1ck6hndmod1smej1s aggregate functions alias for stdev stddev pop docid\ roka1ck6hndmod1smej1s aggregate functions alias for stdevp stddev samp docid\ roka1ck6hndmod1smej1s aggregate functions alias for stdev stdev docid\ roka1ck6hndmod1smej1s aggregate functions sample standard deviation stdevp docid\ roka1ck6hndmod1smej1s aggregate functions population standard deviation string agg docid\ xa9jf8l59tk 4facsfczh sorted aggregate functions returns a string concatenated from every row from the expression the delimiter argument is optional string to array docid\ xuk0z8dmxpgmogszpdw6w array functions converts the string representation of an array (e g , 'int\[1,2,null]' ) into an array string to tuple docid\ mrrm7nwt xwcg zvmy6 p tuple functions converts the string representation of a tuple (e g 'tuple<\<int,bigint,char>>(1,2,null)' ) into a tuple strpos docid\ ja8cont33tonx ktruedj character and binary functions equivalent to using locate as locate(substring, string) note the reversed argument order substr docid\ ja8cont33tonx ktruedj character and binary functions alias for substring substring docid\ ja8cont33tonx ktruedj character and binary functions returns the substring of a character or binary value subnet docid\ ezupx17nbsz6c4g5e7o o network type functions c omputes the prefix from an ip or ipv4 value and the size of the prefix sum docid\ roka1ck6hndmod1smej1s aggregate functions sum over the set svd decomp docid\ nhymyoadealtcppijauc5 matrix functions returns svd decomposition of a matrix as a tuple of 3 matrixes swep docid\ roka1ck6hndmod1smej1s aggregate functions the population over the set tan docid\ saa2re dvaqcs gtjp3ps math functions returns the tangent of x tanh docid\ saa2re dvaqcs gtjp3ps math functions returns the hyperbolic tangent of x time docid\ iteimff9ycez0ctcfgqb scalar data conversion functions parses the string to create a time value the string must be in the form 'hh\ mm\[ sssssssss]' timestamp docid\ iteimff9ycez0ctcfgqb scalar data conversion functions parses a string and makes a timestamp value the string must be in the format 'yyyy mm dd\[ hh\ mm]\[ sssssssss]' timestamp to nanos docid\ hem zd qwquv8dfnvnqz8 date and time functions convert timestamp into nanoseconds after epoch as bigint to array length docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions create the specified number of copies of any json object in an array to base docid\ saa2re dvaqcs gtjp3ps math functions converts an integer value to its string representation in a specified base (radix) to char docid\ ja8cont33tonx ktruedj character and binary functions converts a numeric, date, or timestamp value into a char date type to date docid\ naengoslrgk2ikpyh6lkc formatting functions converts a character value with the specified format to a date type to number docid\ naengoslrgk2ikpyh6lkc formatting functions converts a character value with the specified format to a decimal type to timestamp docid\ naengoslrgk2ikpyh6lkc formatting functions converts a character value with the specified format to a timestamp type transform docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions transforms an array based on the logic in a lambda expression translate docid\ ja8cont33tonx ktruedj character and binary functions replaces specified characters in a provided string with a separate set of characters transpose docid\ nhymyoadealtcppijauc5 matrix functions returns transpose of the matrix trim docid\ ja8cont33tonx ktruedj character and binary functions alias for btrim trim leading and trailing blanks from the string trunc docid\ saa2re dvaqcs gtjp3ps math functions returns x truncated to y decimal places truncate docid\ saa2re dvaqcs gtjp3ps math functions alias for trunc tuple() docid\ mrrm7nwt xwcg zvmy6 p tuple functions construct a tuple with the specified elements types of the tuple are inferred from the inner elements tuple<<>> docid\ mrrm7nwt xwcg zvmy6 p tuple functions construct a tuple with the specified elements null is also supported as an element type\[] docid\ xuk0z8dmxpgmogszpdw6w array functions construct an array of sql type type giving the elements ucase docid\ ja8cont33tonx ktruedj character and binary functions alias for upper unnest docid\ xuk0z8dmxpgmogszpdw6w array functions expand each element in an input array out to an individual row upper docid\ ja8cont33tonx ktruedj character and binary functions convert string to upper case usecs docid\ hem zd qwquv8dfnvnqz8 date and time functions the seconds part of a time value, including fractional parts, returned as an integer the function multiplies the seconds part of the value by 1,000,000 uuid docid\ iteimff9ycez0ctcfgqb scalar data conversion functions parses the string and makes a universally unique identifier (uuid) value the string must be a valid uuid uuid generate docid\ d5nz44sy24y5 bp ygu7d other functions and expressions generates a random uuid value (version 4) var pop docid\ roka1ck6hndmod1smej1s aggregate functions alias for variancep var samp docid\ roka1ck6hndmod1smej1s aggregate functions alias for variance variance docid\ roka1ck6hndmod1smej1s aggregate functions sample variance variancep docid\ roka1ck6hndmod1smej1s aggregate functions population variance vector argmax docid\ nhymyoadealtcppijauc5 matrix functions returns the argmax of a one dimensional matrix or vector vector argmin docid\ nhymyoadealtcppijauc5 matrix functions returns the argmin of a one dimensional matrix or vector vector max docid\ nhymyoadealtcppijauc5 matrix functions returns the maximum of elements in a one dimensional matrix/vector vector min docid\ nhymyoadealtcppijauc5 matrix functions returns the minimum of elements in a one dimensional matrix/vector vector sum docid\ nhymyoadealtcppijauc5 matrix functions returns the sum of elements in a one dimensional matrix/vector version docid\ d5nz44sy24y5 bp ygu7d system functions returns the version of the database to which the client is currently connected week docid\ hem zd qwquv8dfnvnqz8 date and time functions returns the iso 8601 week number, as an integer, of the specified timestamp or date value weeks docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type weeks to be used in date calculations width bucket docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions creates n equal width buckets in the range \[min,max) as a histogram year docid\ hem zd qwquv8dfnvnqz8 date and time functions extracts the year portion of a timestamp or date as an integer years docid\ iteimff9ycez0ctcfgqb scalar data conversion functions converts an integral value to an interval value of type years zero matrix docid\ nhymyoadealtcppijauc5 matrix functions returns a zero matrix of the specified (row, col) dimensions zip with docid\ ti3mdibvgmuudmlqu9xpl special data pipeline transformation functions merges two or more input arrays, element wise, into a single array using the trailing combining function zn docid\ d5nz44sy24y5 bp ygu7d conditional functions if x is null, returns 0 otherwise, returns x zscore docid\ knh6ndwnm hzuab9dwzrz window aggregate functions zscore of the sample based on the stddev() function zscorep docid\ knh6ndwnm hzuab9dwzrz window aggregate functions zscore of the sample based on the stddevp() function