|
anyarray | array_add (anyarray x, anyarray y) |
| Adds two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. More...
|
|
anyarray | array_sub (anyarray x, anyarray y) |
| Subtracts two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. More...
|
|
anyarray | array_mult (anyarray x, anyarray y) |
| Element-wise product of two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. More...
|
|
anyarray | array_div (anyarray x, anyarray y) |
| Element-wise division of two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. More...
|
|
float8 | array_dot (anyarray x, anyarray y) |
| Dot-product of two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. More...
|
|
bool | array_contains (anyarray x, anyarray y) |
| Checks whether one array contains the other. More...
|
|
anyelement | array_max (anyarray x) |
| This function finds the maximum value in the array. NULLs are ignored. Return type is the same as the input type. More...
|
|
anyelement | array_min (anyarray x) |
| This function finds the minimum value in the array. NULLs are ignored. Return type is the same as the input type. More...
|
|
anyelement | array_sum (anyarray x) |
| This function finds the sum of the values in the array. NULLs are ignored. Return type is the same as the input type. More...
|
|
float8 | array_sum_big (anyarray x) |
| This function finds the sum of the values in the array. NULLs are ignored. Return type is always FLOAT8 regardless of input. This function is meant to replace array_sum in the cases when sum may overflow the array type. More...
|
|
float8 | array_mean (anyarray x) |
| TThis function finds the mean of the values in the array. NULLs are ignored. Return type is the same as the input type. More...
|
|
float8 | array_stddev (anyarray x) |
| This function finds the standard deviation of the values in the array. NULLs are ignored. Return type is the same as the input type. More...
|
|
float8[] | array_of_float (int4 k) |
| This function creates an array of set size (the argument value) of FLOAT8, initializing the values to 0.0;. More...
|
|
int8[] | array_of_bigint (int4 k) |
| This function creates an array of set size (the argument value) of BIGINT, initializing the values to 0;. More...
|
|
anyarray | array_fill (anyarray x, anyelement k) |
| This functions set every values in the array to some desired value (provided as the argument). More...
|
|
anyarray | array_scalar_mult (anyarray x, anyelement k) |
| This function takes an array as the input and executes element with multiplication by the scalar provided as the second argument, returning the resulting array. It requires that all the values are NON-NULL. Return type is the same as the input type. More...
|
|
anyarray | array_sqrt (anyarray x) |
| This function takes an array as the input and finds square root of each element in the array, returning the resulting array. It requires that all the values are NON-NULL. Return type is the same as the input type. This means that if the input if of the size INT, the results would also be rounded. More...
|
|
float8[] | normalize (float8[] x) |
| Array normalization function. More...
|
|
aggregate anyarray | array_agg (anyelement) |
| ARRAY_AGG aggregate for compatibility with GPDB < 4.1 and Postgres < 9.0 This is a slower solution than the built in array_agg that appears in later GPDB and Postgres versions.
|
|
- Date
- April 2011
Definition in file array_ops.sql_in.