L2_DISTANCE

L2_DISTANCE is a shorthand version of the VECTOR_DISTANCE function that calculates the Euclidean distance between two vectors. It takes two vectors as input and returns the distance between them as a BINARY_DOUBLE.

Syntax

Description of the illustration l2_distance.gif

Parameters

• expr1 and expr2 must evaluate to vectors that have the same format and number of dimensions.

• L2_DISTANCE returns NULL, if either expr1 or expr2 is NULL.