SQL type definitions and functions for sparse vector data type svec
More...
Functions | |
svec | svec_in (cstring) |
cstring | svec_out (svec) |
svec | svec_recv (internal) |
bytea | svec_send (svec) |
svec | svec_plus (svec, svec) |
svec | svec_minus (svec, svec) |
svec | svec_div (svec, svec) |
svec | svec_mult (svec, svec) |
svec | svec_pow (svec, svec) |
integer | svec_cmp (svec, svec) |
boolean | svec_ge (svec, svec) |
boolean | svec_lt (svec, svec) |
boolean | svec_le (svec, svec) |
boolean | svec_gt (svec, svec) |
boolean | svec_ne (svec, svec) |
boolean | svec_eq (svec, svec) |
boolean | float8arr_eq (float8[], float8[]) |
svec | float8arr_minus_float8arr (float8[], float8[]) |
svec | float8arr_minus_svec (float8[], svec) |
svec | svec_minus_float8arr (svec, float8[]) |
svec | float8arr_plus_float8arr (float8[], float8[]) |
svec | float8arr_plus_svec (float8[], svec) |
svec | svec_plus_float8arr (svec, float8[]) |
svec | float8arr_mult_float8arr (float8[], float8[]) |
svec | float8arr_mult_svec (float8[], svec) |
svec | svec_mult_float8arr (svec, float8[]) |
svec | float8arr_div_float8arr (float8[], float8[]) |
svec | float8arr_div_svec (float8[], svec) |
svec | svec_div_float8arr (svec, float8[]) |
float8 | svec_dot (svec, svec) |
float8 | svec_dot (float8[], float8[]) |
float8 | svec_dot (svec, float8[]) |
float8 | svec_dot (float8[], svec) |
svec | svec_cast_int2 (int2) |
svec | svec_cast_int4 (int4) |
svec | svec_cast_int8 (bigint) |
svec | svec_cast_float4 (float4) |
svec | svec_cast_float8 (float8) |
svec | svec_cast_numeric (numeric) |
float8 [] | float8arr_cast_int2 (int2) |
float8 [] | float8arr_cast_int4 (int4) |
float8 [] | float8arr_cast_int8 (bigint) |
float8 [] | float8arr_cast_float4 (float4) |
float8 [] | float8arr_cast_float8 (float8) |
float8 [] | float8arr_cast_numeric (numeric) |
svec | svec_cast_float8arr (float8[]) |
svec | svec_cast_positions_float8arr (int8[], float8[], int8, float8) |
float8 [] | svec_return_array (svec) |
svec | svec_concat (svec, svec) |
svec | svec_concat_replicate (int4, svec) |
bool | svec_l2_lt (svec, svec) |
bool | svec_l2_le (svec, svec) |
bool | svec_l2_eq (svec, svec) |
bool | svec_l2_ne (svec, svec) |
bool | svec_l2_gt (svec, svec) |
bool | svec_l2_ge (svec, svec) |
integer | svec_l2_cmp (svec, svec) |
float8 [] float8arr_cast_float4 | ( | float4 | ) |
Casts a float4 into a float8 array.
float8 [] float8arr_cast_float8 | ( | float8 | ) |
Casts a float8 into a float8 array.
float8 [] float8arr_cast_int2 | ( | int2 | ) |
Casts an int2 into a float8 array.
float8 [] float8arr_cast_int4 | ( | int4 | ) |
Casts an int4 into a float8 array.
float8 [] float8arr_cast_int8 | ( | bigint | ) |
Casts an int8 into a float8 array.
float8 [] float8arr_cast_numeric | ( | numeric | ) |
Casts a numeric into a float8 array.
svec float8arr_div_float8arr | ( | float8 | [], |
float8 | [] | ||
) |
Divides a float8 array by another, element by element.
svec float8arr_div_svec | ( | float8 | [], |
svec | |||
) |
Divides a float8 array by an SVEC, element by element.
boolean float8arr_eq | ( | float8 | [], |
float8 | [] | ||
) |
Returns true if two float8 arrays are equal
svec float8arr_minus_float8arr | ( | float8 | [], |
float8 | [] | ||
) |
Minus second array from the first array, element by element.
svec float8arr_minus_svec | ( | float8 | [], |
svec | |||
) |
Minus second SVEC from the first array, element by element.
svec float8arr_mult_float8arr | ( | float8 | [], |
float8 | [] | ||
) |
Multiplies two float8 arrays, element by element.
svec float8arr_mult_svec | ( | float8 | [], |
svec | |||
) |
Multiplies an array and an SVEC, element by element.
svec float8arr_plus_float8arr | ( | float8 | [], |
float8 | [] | ||
) |
Adds two arrays together, element by element.
svec float8arr_plus_svec | ( | float8 | [], |
svec | |||
) |
Adds an array and an SVEC, element by element.
svec svec_cast_float4 | ( | float4 | ) |
Casts a float4 into an SVEC.
svec svec_cast_float8 | ( | float8 | ) |
Casts a float8 into an SVEC.
svec svec_cast_float8arr | ( | float8 | [] | ) |
Casts a float8 into an SVEC.
svec svec_cast_int2 | ( | int2 | ) |
Casts an int2 into an SVEC.
svec svec_cast_int4 | ( | int4 | ) |
Casts an int4 into an SVEC.
svec svec_cast_int8 | ( | bigint | ) |
Casts an int8 into an SVEC.
svec svec_cast_numeric | ( | numeric | ) |
Casts a numeric into an SVEC.
svec svec_cast_positions_float8arr | ( | int8 | [], |
float8 | [], | ||
int8 | , | ||
float8 | |||
) |
Casts an array of int8 positions, float8 values into an SVEC.
integer svec_cmp | ( | svec | , |
svec | |||
) |
Compare two SVECs, -1 for left side smaller, 1 for greater, 0 for equal
svec svec_concat | ( | svec | , |
svec | |||
) |
Concatenates two SVECs.
svec svec_concat_replicate | ( | int4 | , |
svec | |||
) |
Replicates n copies of an SVEC and concatenates them together.
svec svec_div | ( | svec | , |
svec | |||
) |
Divides the first SVEC by the second, element by element.
svec svec_div_float8arr | ( | svec | , |
float8 | [] | ||
) |
Divides an SVEC by a float8 array, element by element.
float8 svec_dot | ( | svec | , |
svec | |||
) |
Computes the dot product of two SVECs.
float8 svec_dot | ( | float8 | [], |
float8 | [] | ||
) |
Computes the dot product of two float8 arrays.
float8 svec_dot | ( | svec | , |
float8 | [] | ||
) |
Computes the dot product of an SVEC and a float8 array.
float8 svec_dot | ( | float8 | [], |
svec | |||
) |
Computes the dot product of a float8 array and an SVEC.
boolean svec_eq | ( | svec | , |
svec | |||
) |
Returns true if two SVECs are equal. If the two SVECs are of different size, then will return false.
boolean svec_ge | ( | svec | , |
svec | |||
) |
Returns true if the left SVEC is greater or equal to the right.
boolean svec_gt | ( | svec | , |
svec | |||
) |
Returns true if the left SVEC is greater.
svec svec_in | ( | cstring | ) |
SVEC constructor from CSTRING.
integer svec_l2_cmp | ( | svec | , |
svec | |||
) |
Returns a value indicating the relative values of the l2 norms of two SVECs.
bool svec_l2_eq | ( | svec | , |
svec | |||
) |
Returns true if the l2 norm of the first SVEC is equal to that of the second SVEC.
bool svec_l2_ge | ( | svec | , |
svec | |||
) |
Returns true if the l2 norm of the first SVEC is greater than or equal to that of the second SVEC.
bool svec_l2_gt | ( | svec | , |
svec | |||
) |
Returns true if the l2 norm of the first SVEC is greater than that of the second SVEC.
bool svec_l2_le | ( | svec | , |
svec | |||
) |
Returns true if the l2 norm of the first SVEC is less than or equal to that of the second SVEC.
bool svec_l2_lt | ( | svec | , |
svec | |||
) |
Returns true if the l2 norm of the first SVEC is less than that of the second SVEC.
bool svec_l2_ne | ( | svec | , |
svec | |||
) |
Returns true if the l2 norm of the first SVEC is not equal to that of the second SVEC.
boolean svec_le | ( | svec | , |
svec | |||
) |
Returns true if the left SVEC is less or equal to the right.
boolean svec_lt | ( | svec | , |
svec | |||
) |
Returns true if the left SVEC is less than the right.
svec svec_minus | ( | svec | , |
svec | |||
) |
Minus second SVEC from the first, element by element.
svec svec_minus_float8arr | ( | svec | , |
float8 | [] | ||
) |
Minus second array from the first SVEC, element by element.
svec svec_mult | ( | svec | , |
svec | |||
) |
Multiplies two SVEVs together, element by element.
svec svec_mult_float8arr | ( | svec | , |
float8 | [] | ||
) |
Multiplies an SVEC and an array, element by element.
boolean svec_ne | ( | svec | , |
svec | |||
) |
Returns true if two SVECs are not equal. If the two SVECs are of different size, then will return true.
cstring svec_out | ( | svec | ) |
Converts SVEC to CSTRING.
svec svec_plus | ( | svec | , |
svec | |||
) |
Adds two SVECs together, element by element.
svec svec_plus_float8arr | ( | svec | , |
float8 | [] | ||
) |
Adds an SVEC and an array, element by element.
svec svec_pow | ( | svec | , |
svec | |||
) |
Raises each element of the first SVEC to the power given by second SVEC, which must have dimension 1 (a scalar).
svec svec_recv | ( | internal | ) |
Converts SVEC internal representation to SVEC.
float8 [] svec_return_array | ( | svec | ) |
Casts an SVEC into a float8 array.
bytea svec_send | ( | svec | ) |
Converts SVEC to BYTEA.