-- complain if script is sourced in psql, rather than via CREATE EXTENSION

\echo Use "CREATE EXTENSION vector" to load this file. \quit

-- vector type

CREATE TYPE vector;

CREATE FUNCTION vector_in(cstring, oid, integer) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_out(vector) RETURNS cstring

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_typmod_in(cstring[]) RETURNS integer

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_recv(internal, oid, integer) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_send(vector) RETURNS bytea

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE TYPE vector (

INPUT = vector_in,

OUTPUT = vector_out,

TYPMOD_IN = vector_typmod_in,

RECEIVE = vector_recv,

SEND = vector_send,

STORAGE = external

);

-- vector functions

CREATE FUNCTION l2_distance(vector, vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION inner_product(vector, vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION cosine_distance(vector, vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l1_distance(vector, vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_dims(vector) RETURNS integer

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_norm(vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l2_normalize(vector) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION binary_quantize(vector) RETURNS bit

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION subvector(vector, int, int) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- vector private functions

CREATE FUNCTION vector_add(vector, vector) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_sub(vector, vector) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_mul(vector, vector) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_concat(vector, vector) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_lt(vector, vector) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_le(vector, vector) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_eq(vector, vector) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_ne(vector, vector) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_ge(vector, vector) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_gt(vector, vector) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_cmp(vector, vector) RETURNS int4

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_l2_squared_distance(vector, vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_negative_inner_product(vector, vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_spherical_distance(vector, vector) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_accum(double precision[], vector) RETURNS double precision[]

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_avg(double precision[]) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_combine(double precision[], double precision[]) RETURNS double precision[]

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- vector aggregates

CREATE AGGREGATE avg(vector) (

SFUNC = vector_accum,

STYPE = double precision[],

FINALFUNC = vector_avg,

COMBINEFUNC = vector_combine,

INITCOND = '{0}',

PARALLEL = SAFE

);

CREATE AGGREGATE sum(vector) (

SFUNC = vector_add,

STYPE = vector,

COMBINEFUNC = vector_add,

PARALLEL = SAFE

);

-- vector cast functions

CREATE FUNCTION vector(vector, integer, boolean) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_vector(integer[], integer, boolean) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_vector(real[], integer, boolean) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_vector(double precision[], integer, boolean) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_vector(numeric[], integer, boolean) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_to_float4(vector, integer, boolean) RETURNS real[]

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- vector casts

CREATE CAST (vector AS vector)

WITH FUNCTION vector(vector, integer, boolean) AS IMPLICIT;

CREATE CAST (vector AS real[])

WITH FUNCTION vector_to_float4(vector, integer, boolean) AS IMPLICIT;

CREATE CAST (integer[] AS vector)

WITH FUNCTION array_to_vector(integer[], integer, boolean) AS ASSIGNMENT;

CREATE CAST (real[] AS vector)

WITH FUNCTION array_to_vector(real[], integer, boolean) AS ASSIGNMENT;

CREATE CAST (double precision[] AS vector)

WITH FUNCTION array_to_vector(double precision[], integer, boolean) AS ASSIGNMENT;

CREATE CAST (numeric[] AS vector)

WITH FUNCTION array_to_vector(numeric[], integer, boolean) AS ASSIGNMENT;

-- vector operators

CREATE OPERATOR <-> (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = l2_distance,

COMMUTATOR = '<->'

);

CREATE OPERATOR <#> (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_negative_inner_product,

COMMUTATOR = '<#>'

);

CREATE OPERATOR <=> (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = cosine_distance,

COMMUTATOR = '<=>'

);

CREATE OPERATOR <+> (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = l1_distance,

COMMUTATOR = '<+>'

);

CREATE OPERATOR + (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_add,

COMMUTATOR = +

);

CREATE OPERATOR - (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_sub

);

CREATE OPERATOR * (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_mul,

COMMUTATOR = *

);

CREATE OPERATOR || (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_concat

);

CREATE OPERATOR < (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_lt,

COMMUTATOR = > , NEGATOR = >= ,

RESTRICT = scalarltsel, JOIN = scalarltjoinsel

);

CREATE OPERATOR <= (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_le,

COMMUTATOR = >= , NEGATOR = > ,

RESTRICT = scalarlesel, JOIN = scalarlejoinsel

);

CREATE OPERATOR = (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_eq,

COMMUTATOR = = , NEGATOR = <> ,

RESTRICT = eqsel, JOIN = eqjoinsel

);

CREATE OPERATOR <> (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_ne,

COMMUTATOR = <> , NEGATOR = = ,

RESTRICT = eqsel, JOIN = eqjoinsel

);

CREATE OPERATOR >= (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_ge,

COMMUTATOR = <= , NEGATOR = < ,

RESTRICT = scalargesel, JOIN = scalargejoinsel

);

CREATE OPERATOR > (

LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_gt,

COMMUTATOR = < , NEGATOR = <= ,

RESTRICT = scalargtsel, JOIN = scalargtjoinsel

);

-- access methods

CREATE FUNCTION ivfflathandler(internal) RETURNS index_am_handler

AS 'MODULE_PATHNAME' LANGUAGE C;

CREATE ACCESS METHOD ivfflat TYPE INDEX HANDLER ivfflathandler;

COMMENT ON ACCESS METHOD ivfflat IS 'ivfflat index access method';

CREATE FUNCTION hnswhandler(internal) RETURNS index_am_handler

AS 'MODULE_PATHNAME' LANGUAGE C;

CREATE ACCESS METHOD hnsw TYPE INDEX HANDLER hnswhandler;

COMMENT ON ACCESS METHOD hnsw IS 'hnsw index access method';

-- vector opclasses

CREATE OPERATOR CLASS vector_ops

DEFAULT FOR TYPE vector USING btree AS

OPERATOR 1 < ,

OPERATOR 2 <= ,

OPERATOR 3 = ,

OPERATOR 4 >= ,

OPERATOR 5 > ,

FUNCTION 1 vector_cmp(vector, vector);

CREATE OPERATOR CLASS vector_l2_ops

DEFAULT FOR TYPE vector USING ivfflat AS

OPERATOR 1 <-> (vector, vector) FOR ORDER BY float_ops,

FUNCTION 1 vector_l2_squared_distance(vector, vector),

FUNCTION 3 l2_distance(vector, vector);

CREATE OPERATOR CLASS vector_ip_ops

FOR TYPE vector USING ivfflat AS

OPERATOR 1 <#> (vector, vector) FOR ORDER BY float_ops,

FUNCTION 1 vector_negative_inner_product(vector, vector),

FUNCTION 3 vector_spherical_distance(vector, vector),

FUNCTION 4 vector_norm(vector);

CREATE OPERATOR CLASS vector_cosine_ops

FOR TYPE vector USING ivfflat AS

OPERATOR 1 <=> (vector, vector) FOR ORDER BY float_ops,

FUNCTION 1 vector_negative_inner_product(vector, vector),

FUNCTION 2 vector_norm(vector),

FUNCTION 3 vector_spherical_distance(vector, vector),

FUNCTION 4 vector_norm(vector);

CREATE OPERATOR CLASS vector_l2_ops

FOR TYPE vector USING hnsw AS

OPERATOR 1 <-> (vector, vector) FOR ORDER BY float_ops,

FUNCTION 1 vector_l2_squared_distance(vector, vector);

CREATE OPERATOR CLASS vector_ip_ops

FOR TYPE vector USING hnsw AS

OPERATOR 1 <#> (vector, vector) FOR ORDER BY float_ops,

FUNCTION 1 vector_negative_inner_product(vector, vector);

CREATE OPERATOR CLASS vector_cosine_ops

FOR TYPE vector USING hnsw AS

OPERATOR 1 <=> (vector, vector) FOR ORDER BY float_ops,

FUNCTION 1 vector_negative_inner_product(vector, vector),

FUNCTION 2 vector_norm(vector);

CREATE OPERATOR CLASS vector_l1_ops

FOR TYPE vector USING hnsw AS

OPERATOR 1 <+> (vector, vector) FOR ORDER BY float_ops,

FUNCTION 1 l1_distance(vector, vector);

-- bit functions

CREATE FUNCTION hamming_distance(bit, bit) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION jaccard_distance(bit, bit) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- bit private functions

CREATE FUNCTION ivfflat_bit_support(internal) RETURNS internal

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION hnsw_bit_max_dims(internal) RETURNS internal

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- bit operators

CREATE OPERATOR <~> (

LEFTARG = bit, RIGHTARG = bit, PROCEDURE = hamming_distance,

COMMUTATOR = '<~>'

);

CREATE OPERATOR <%> (

LEFTARG = bit, RIGHTARG = bit, PROCEDURE = jaccard_distance,

COMMUTATOR = '<%>'

);

-- bit opclasses

CREATE OPERATOR CLASS bit_hamming_ops

FOR TYPE bit USING ivfflat AS

OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,

FUNCTION 1 hamming_distance(bit, bit),

FUNCTION 3 hamming_distance(bit, bit),

FUNCTION 6 ivfflat_bit_support(internal);

CREATE OPERATOR CLASS bit_hamming_ops

FOR TYPE bit USING hnsw AS

OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,

FUNCTION 1 hamming_distance(bit, bit),

FUNCTION 4 hnsw_bit_max_dims(internal);

CREATE OPERATOR CLASS bit_jaccard_ops

FOR TYPE bit USING hnsw AS

OPERATOR 1 <%> (bit, bit) FOR ORDER BY float_ops,

FUNCTION 1 jaccard_distance(bit, bit),

FUNCTION 4 hnsw_bit_max_dims(internal);

-- halfvec type

CREATE TYPE halfvec;

CREATE FUNCTION halfvec_in(cstring, oid, integer) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_out(halfvec) RETURNS cstring

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_typmod_in(cstring[]) RETURNS integer

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_recv(internal, oid, integer) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_send(halfvec) RETURNS bytea

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE TYPE halfvec (

INPUT = halfvec_in,

OUTPUT = halfvec_out,

TYPMOD_IN = halfvec_typmod_in,

RECEIVE = halfvec_recv,

SEND = halfvec_send,

STORAGE = external

);

-- halfvec functions

CREATE FUNCTION l2_distance(halfvec, halfvec) RETURNS float8

AS 'MODULE_PATHNAME', 'halfvec_l2_distance' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION inner_product(halfvec, halfvec) RETURNS float8

AS 'MODULE_PATHNAME', 'halfvec_inner_product' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION cosine_distance(halfvec, halfvec) RETURNS float8

AS 'MODULE_PATHNAME', 'halfvec_cosine_distance' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l1_distance(halfvec, halfvec) RETURNS float8

AS 'MODULE_PATHNAME', 'halfvec_l1_distance' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_dims(halfvec) RETURNS integer

AS 'MODULE_PATHNAME', 'halfvec_vector_dims' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l2_norm(halfvec) RETURNS float8

AS 'MODULE_PATHNAME', 'halfvec_l2_norm' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l2_normalize(halfvec) RETURNS halfvec

AS 'MODULE_PATHNAME', 'halfvec_l2_normalize' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION binary_quantize(halfvec) RETURNS bit

AS 'MODULE_PATHNAME', 'halfvec_binary_quantize' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION subvector(halfvec, int, int) RETURNS halfvec

AS 'MODULE_PATHNAME', 'halfvec_subvector' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- halfvec private functions

CREATE FUNCTION halfvec_add(halfvec, halfvec) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_sub(halfvec, halfvec) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_mul(halfvec, halfvec) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_concat(halfvec, halfvec) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_lt(halfvec, halfvec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_le(halfvec, halfvec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_eq(halfvec, halfvec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_ne(halfvec, halfvec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_ge(halfvec, halfvec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_gt(halfvec, halfvec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_cmp(halfvec, halfvec) RETURNS int4

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_l2_squared_distance(halfvec, halfvec) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_negative_inner_product(halfvec, halfvec) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_spherical_distance(halfvec, halfvec) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_accum(double precision[], halfvec) RETURNS double precision[]

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_avg(double precision[]) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION ivfflat_halfvec_support(internal) RETURNS internal

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION hnsw_halfvec_max_dims(internal) RETURNS internal

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- halfvec aggregates

CREATE AGGREGATE avg(halfvec) (

SFUNC = halfvec_accum,

STYPE = double precision[],

FINALFUNC = halfvec_avg,

COMBINEFUNC = vector_combine,

INITCOND = '{0}',

PARALLEL = SAFE

);

CREATE AGGREGATE sum(halfvec) (

SFUNC = halfvec_add,

STYPE = halfvec,

COMBINEFUNC = halfvec_add,

PARALLEL = SAFE

);

-- halfvec cast functions

CREATE FUNCTION halfvec(halfvec, integer, boolean) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_to_vector(halfvec, integer, boolean) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_to_halfvec(vector, integer, boolean) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_halfvec(integer[], integer, boolean) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_halfvec(real[], integer, boolean) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_halfvec(double precision[], integer, boolean) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION array_to_halfvec(numeric[], integer, boolean) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_to_float4(halfvec, integer, boolean) RETURNS real[]

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- halfvec casts

CREATE CAST (halfvec AS halfvec)

WITH FUNCTION halfvec(halfvec, integer, boolean) AS IMPLICIT;

CREATE CAST (halfvec AS vector)

WITH FUNCTION halfvec_to_vector(halfvec, integer, boolean) AS ASSIGNMENT;

CREATE CAST (vector AS halfvec)

WITH FUNCTION vector_to_halfvec(vector, integer, boolean) AS IMPLICIT;

CREATE CAST (halfvec AS real[])

WITH FUNCTION halfvec_to_float4(halfvec, integer, boolean) AS ASSIGNMENT;

CREATE CAST (integer[] AS halfvec)

WITH FUNCTION array_to_halfvec(integer[], integer, boolean) AS ASSIGNMENT;

CREATE CAST (real[] AS halfvec)

WITH FUNCTION array_to_halfvec(real[], integer, boolean) AS ASSIGNMENT;

CREATE CAST (double precision[] AS halfvec)

WITH FUNCTION array_to_halfvec(double precision[], integer, boolean) AS ASSIGNMENT;

CREATE CAST (numeric[] AS halfvec)

WITH FUNCTION array_to_halfvec(numeric[], integer, boolean) AS ASSIGNMENT;

-- halfvec operators

CREATE OPERATOR <-> (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = l2_distance,

COMMUTATOR = '<->'

);

CREATE OPERATOR <#> (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_negative_inner_product,

COMMUTATOR = '<#>'

);

CREATE OPERATOR <=> (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = cosine_distance,

COMMUTATOR = '<=>'

);

CREATE OPERATOR <+> (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = l1_distance,

COMMUTATOR = '<+>'

);

CREATE OPERATOR + (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_add,

COMMUTATOR = +

);

CREATE OPERATOR - (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_sub

);

CREATE OPERATOR * (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_mul,

COMMUTATOR = *

);

CREATE OPERATOR || (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_concat

);

CREATE OPERATOR < (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_lt,

COMMUTATOR = > , NEGATOR = >= ,

RESTRICT = scalarltsel, JOIN = scalarltjoinsel

);

CREATE OPERATOR <= (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_le,

COMMUTATOR = >= , NEGATOR = > ,

RESTRICT = scalarlesel, JOIN = scalarlejoinsel

);

CREATE OPERATOR = (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_eq,

COMMUTATOR = = , NEGATOR = <> ,

RESTRICT = eqsel, JOIN = eqjoinsel

);

CREATE OPERATOR <> (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_ne,

COMMUTATOR = <> , NEGATOR = = ,

RESTRICT = eqsel, JOIN = eqjoinsel

);

CREATE OPERATOR >= (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_ge,

COMMUTATOR = <= , NEGATOR = < ,

RESTRICT = scalargesel, JOIN = scalargejoinsel

);

CREATE OPERATOR > (

LEFTARG = halfvec, RIGHTARG = halfvec, PROCEDURE = halfvec_gt,

COMMUTATOR = < , NEGATOR = <= ,

RESTRICT = scalargtsel, JOIN = scalargtjoinsel

);

-- halfvec opclasses

CREATE OPERATOR CLASS halfvec_ops

DEFAULT FOR TYPE halfvec USING btree AS

OPERATOR 1 < ,

OPERATOR 2 <= ,

OPERATOR 3 = ,

OPERATOR 4 >= ,

OPERATOR 5 > ,

FUNCTION 1 halfvec_cmp(halfvec, halfvec);

CREATE OPERATOR CLASS halfvec_l2_ops

FOR TYPE halfvec USING ivfflat AS

OPERATOR 1 <-> (halfvec, halfvec) FOR ORDER BY float_ops,

FUNCTION 1 halfvec_l2_squared_distance(halfvec, halfvec),

FUNCTION 3 l2_distance(halfvec, halfvec),

FUNCTION 6 ivfflat_halfvec_support(internal);

CREATE OPERATOR CLASS halfvec_ip_ops

FOR TYPE halfvec USING ivfflat AS

OPERATOR 1 <#> (halfvec, halfvec) FOR ORDER BY float_ops,

FUNCTION 1 halfvec_negative_inner_product(halfvec, halfvec),

FUNCTION 3 halfvec_spherical_distance(halfvec, halfvec),

FUNCTION 4 l2_norm(halfvec),

FUNCTION 5 l2_normalize(halfvec),

FUNCTION 6 ivfflat_halfvec_support(internal);

CREATE OPERATOR CLASS halfvec_cosine_ops

FOR TYPE halfvec USING ivfflat AS

OPERATOR 1 <=> (halfvec, halfvec) FOR ORDER BY float_ops,

FUNCTION 1 halfvec_negative_inner_product(halfvec, halfvec),

FUNCTION 2 l2_norm(halfvec),

FUNCTION 3 halfvec_spherical_distance(halfvec, halfvec),

FUNCTION 4 l2_norm(halfvec),

FUNCTION 5 l2_normalize(halfvec),

FUNCTION 6 ivfflat_halfvec_support(internal);

CREATE OPERATOR CLASS halfvec_l2_ops

FOR TYPE halfvec USING hnsw AS

OPERATOR 1 <-> (halfvec, halfvec) FOR ORDER BY float_ops,

FUNCTION 1 halfvec_l2_squared_distance(halfvec, halfvec),

FUNCTION 4 hnsw_halfvec_max_dims(internal);

CREATE OPERATOR CLASS halfvec_ip_ops

FOR TYPE halfvec USING hnsw AS

OPERATOR 1 <#> (halfvec, halfvec) FOR ORDER BY float_ops,

FUNCTION 1 halfvec_negative_inner_product(halfvec, halfvec),

FUNCTION 4 hnsw_halfvec_max_dims(internal);

CREATE OPERATOR CLASS halfvec_cosine_ops

FOR TYPE halfvec USING hnsw AS

OPERATOR 1 <=> (halfvec, halfvec) FOR ORDER BY float_ops,

FUNCTION 1 halfvec_negative_inner_product(halfvec, halfvec),

FUNCTION 2 l2_norm(halfvec),

FUNCTION 3 l2_normalize(halfvec),

FUNCTION 4 hnsw_halfvec_max_dims(internal);

CREATE OPERATOR CLASS halfvec_l1_ops

FOR TYPE halfvec USING hnsw AS

OPERATOR 1 <+> (halfvec, halfvec) FOR ORDER BY float_ops,

FUNCTION 1 l1_distance(halfvec, halfvec),

FUNCTION 4 hnsw_halfvec_max_dims(internal);

--- sparsevec type

CREATE TYPE sparsevec;

CREATE FUNCTION sparsevec_in(cstring, oid, integer) RETURNS sparsevec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_out(sparsevec) RETURNS cstring

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_typmod_in(cstring[]) RETURNS integer

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_recv(internal, oid, integer) RETURNS sparsevec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_send(sparsevec) RETURNS bytea

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE TYPE sparsevec (

INPUT = sparsevec_in,

OUTPUT = sparsevec_out,

TYPMOD_IN = sparsevec_typmod_in,

RECEIVE = sparsevec_recv,

SEND = sparsevec_send,

STORAGE = external

);

-- sparsevec functions

CREATE FUNCTION l2_distance(sparsevec, sparsevec) RETURNS float8

AS 'MODULE_PATHNAME', 'sparsevec_l2_distance' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION inner_product(sparsevec, sparsevec) RETURNS float8

AS 'MODULE_PATHNAME', 'sparsevec_inner_product' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION cosine_distance(sparsevec, sparsevec) RETURNS float8

AS 'MODULE_PATHNAME', 'sparsevec_cosine_distance' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l1_distance(sparsevec, sparsevec) RETURNS float8

AS 'MODULE_PATHNAME', 'sparsevec_l1_distance' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l2_norm(sparsevec) RETURNS float8

AS 'MODULE_PATHNAME', 'sparsevec_l2_norm' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION l2_normalize(sparsevec) RETURNS sparsevec

AS 'MODULE_PATHNAME', 'sparsevec_l2_normalize' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- sparsevec private functions

CREATE FUNCTION sparsevec_lt(sparsevec, sparsevec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_le(sparsevec, sparsevec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_eq(sparsevec, sparsevec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_ne(sparsevec, sparsevec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_ge(sparsevec, sparsevec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_gt(sparsevec, sparsevec) RETURNS bool

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_cmp(sparsevec, sparsevec) RETURNS int4

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_l2_squared_distance(sparsevec, sparsevec) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_negative_inner_product(sparsevec, sparsevec) RETURNS float8

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- sparsevec cast functions

CREATE FUNCTION sparsevec(sparsevec, integer, boolean) RETURNS sparsevec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION vector_to_sparsevec(vector, integer, boolean) RETURNS sparsevec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_to_vector(sparsevec, integer, boolean) RETURNS vector

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION halfvec_to_sparsevec(halfvec, integer, boolean) RETURNS sparsevec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION sparsevec_to_halfvec(sparsevec, integer, boolean) RETURNS halfvec

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION hnsw_sparsevec_max_dims(internal) RETURNS internal

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

CREATE FUNCTION hnsw_sparsevec_check_value(internal) RETURNS internal

AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;

-- sparsevec casts

CREATE CAST (sparsevec AS sparsevec)

WITH FUNCTION sparsevec(sparsevec, integer, boolean) AS IMPLICIT;

CREATE CAST (sparsevec AS vector)

WITH FUNCTION sparsevec_to_vector(sparsevec, integer, boolean) AS ASSIGNMENT;

CREATE CAST (vector AS sparsevec)

WITH FUNCTION vector_to_sparsevec(vector, integer, boolean) AS IMPLICIT;

CREATE CAST (sparsevec AS halfvec)

WITH FUNCTION sparsevec_to_halfvec(sparsevec, integer, boolean) AS ASSIGNMENT;

CREATE CAST (halfvec AS sparsevec)

WITH FUNCTION halfvec_to_sparsevec(halfvec, integer, boolean) AS IMPLICIT;

-- sparsevec operators

CREATE OPERATOR <-> (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = l2_distance,

COMMUTATOR = '<->'

);

CREATE OPERATOR <#> (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = sparsevec_negative_inner_product,

COMMUTATOR = '<#>'

);

CREATE OPERATOR <=> (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = cosine_distance,

COMMUTATOR = '<=>'

);

CREATE OPERATOR <+> (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = l1_distance,

COMMUTATOR = '<+>'

);

CREATE OPERATOR < (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = sparsevec_lt,

COMMUTATOR = > , NEGATOR = >= ,

RESTRICT = scalarltsel, JOIN = scalarltjoinsel

);

CREATE OPERATOR <= (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = sparsevec_le,

COMMUTATOR = >= , NEGATOR = > ,

RESTRICT = scalarlesel, JOIN = scalarlejoinsel

);

CREATE OPERATOR = (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = sparsevec_eq,

COMMUTATOR = = , NEGATOR = <> ,

RESTRICT = eqsel, JOIN = eqjoinsel

);

CREATE OPERATOR <> (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = sparsevec_ne,

COMMUTATOR = <> , NEGATOR = = ,

RESTRICT = eqsel, JOIN = eqjoinsel

);

CREATE OPERATOR >= (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = sparsevec_ge,

COMMUTATOR = <= , NEGATOR = < ,

RESTRICT = scalargesel, JOIN = scalargejoinsel

);

CREATE OPERATOR > (

LEFTARG = sparsevec, RIGHTARG = sparsevec, PROCEDURE = sparsevec_gt,

COMMUTATOR = < , NEGATOR = <= ,

RESTRICT = scalargtsel, JOIN = scalargtjoinsel

);

-- sparsevec opclasses

CREATE OPERATOR CLASS sparsevec_ops

DEFAULT FOR TYPE sparsevec USING btree AS

OPERATOR 1 < ,

OPERATOR 2 <= ,

OPERATOR 3 = ,

OPERATOR 4 >= ,

OPERATOR 5 > ,

FUNCTION 1 sparsevec_cmp(sparsevec, sparsevec);

CREATE OPERATOR CLASS sparsevec_l2_ops

FOR TYPE sparsevec USING hnsw AS

OPERATOR 1 <-> (sparsevec, sparsevec) FOR ORDER BY float_ops,

FUNCTION 1 sparsevec_l2_squared_distance(sparsevec, sparsevec),

FUNCTION 4 hnsw_sparsevec_max_dims(internal),

FUNCTION 5 hnsw_sparsevec_check_value(internal);

CREATE OPERATOR CLASS sparsevec_ip_ops

FOR TYPE sparsevec USING hnsw AS

OPERATOR 1 <#> (sparsevec, sparsevec) FOR ORDER BY float_ops,

FUNCTION 1 sparsevec_negative_inner_product(sparsevec, sparsevec),

FUNCTION 4 hnsw_sparsevec_max_dims(internal),

FUNCTION 5 hnsw_sparsevec_check_value(internal);

CREATE OPERATOR CLASS sparsevec_cosine_ops

FOR TYPE sparsevec USING hnsw AS

OPERATOR 1 <=> (sparsevec, sparsevec) FOR ORDER BY float_ops,

FUNCTION 1 sparsevec_negative_inner_product(sparsevec, sparsevec),

FUNCTION 2 l2_norm(sparsevec),

FUNCTION 3 l2_normalize(sparsevec),

FUNCTION 4 hnsw_sparsevec_max_dims(internal),

FUNCTION 5 hnsw_sparsevec_check_value(internal);

CREATE OPERATOR CLASS sparsevec_l1_ops

FOR TYPE sparsevec USING hnsw AS

OPERATOR 1 <+> (sparsevec, sparsevec) FOR ORDER BY float_ops,

FUNCTION 1 l1_distance(sparsevec, sparsevec),

FUNCTION 4 hnsw_sparsevec_max_dims(internal),

FUNCTION 5 hnsw_sparsevec_check_value(internal);