query I SELECT round(('[1,2,3]'::vector <-> '[2,3,4]'::vector):: numeric, 3); ---- 1.732 query I SELECT round(('[1,2,3]'::vector <#> '[2,3,4]'::vector):: numeric, 3); ---- -20.000 query I SELECT round(('[1,2,3]'::vector <=> '[2,3,4]'::vector):: numeric, 3); ---- 0.007 query I SELECT round(('[1,2,3]'::halfvec <-> '[2,3,4]'::halfvec):: numeric, 3); ---- 1.732 query I SELECT round(('[1,2,3]'::halfvec <#> '[2,3,4]'::halfvec):: numeric, 3); ---- -20.000 query I SELECT round(('[1,2,3]'::halfvec <=> '[2,3,4]'::halfvec):: numeric, 3); ---- 0.007 query I SELECT round((quantize_to_scalar8('[1,2,3]'::vector) <-> quantize_to_scalar8('[2,3,4]'::vector)):: numeric, 1); ---- 1.7 query I SELECT round((quantize_to_scalar8('[1,2,3]'::vector) <#> quantize_to_scalar8('[2,3,4]'::vector)):: numeric, 1); ---- -20.0 query I SELECT round((quantize_to_scalar8('[1,2,3]'::vector) <=> quantize_to_scalar8('[2,3,4]'::vector)):: numeric, 2); ---- 0.01 query I SELECT round((quantize_to_scalar8('[1,2,3]'::halfvec) <-> quantize_to_scalar8('[2,3,4]'::halfvec)):: numeric, 1); ---- 1.7 query I SELECT round((quantize_to_scalar8('[1,2,3]'::halfvec) <#> quantize_to_scalar8('[2,3,4]'::halfvec)):: numeric, 1); ---- -20.0 query I SELECT round((quantize_to_scalar8('[1,2,3]'::halfvec) <=> quantize_to_scalar8('[2,3,4]'::halfvec)):: numeric, 2); ---- 0.01