Skip to content

Commit 1cc6654

Browse files
ankaneankane
committed
Reordered types in sql files [skip ci]
1 parent b15930c commit 1cc6654

2 files changed

Lines changed: 84 additions & 84 deletions

File tree

‎sql/vector--0.6.2--0.7.0.sql‎

Lines changed: 39 additions & 39 deletions
Original file line numberDiff line numberDiff line change
@@ -22,18 +22,18 @@ CREATE OPERATOR || (
2222
LEFTARG = vector, RIGHTARG = vector, PROCEDURE = vector_concat
2323
);
2424

25-
CREATE FUNCTION ivfflat_bit_support(internal) RETURNS internal
26-
AS 'MODULE_PATHNAME' LANGUAGE C;
27-
2825
CREATE FUNCTION ivfflat_halfvec_support(internal) RETURNS internal
2926
AS 'MODULE_PATHNAME' LANGUAGE C;
3027

31-
CREATE FUNCTION hnsw_bit_support(internal) RETURNS internal
28+
CREATE FUNCTION ivfflat_bit_support(internal) RETURNS internal
3229
AS 'MODULE_PATHNAME' LANGUAGE C;
3330

3431
CREATE FUNCTION hnsw_halfvec_support(internal) RETURNS internal
3532
AS 'MODULE_PATHNAME' LANGUAGE C;
3633

34+
CREATE FUNCTION hnsw_bit_support(internal) RETURNS internal
35+
AS 'MODULE_PATHNAME' LANGUAGE C;
36+
3737
CREATE FUNCTION hnsw_sparsevec_support(internal) RETURNS internal
3838
AS 'MODULE_PATHNAME' LANGUAGE C;
3939

@@ -42,41 +42,6 @@ CREATE OPERATOR CLASS vector_l1_ops
4242
OPERATOR 1 <+> (vector, vector) FOR ORDER BY float_ops,
4343
FUNCTION 1 l1_distance(vector, vector);
4444

45-
CREATE FUNCTION hamming_distance(bit, bit) RETURNS float8
46-
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
47-
48-
CREATE FUNCTION jaccard_distance(bit, bit) RETURNS float8
49-
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
50-
51-
CREATE OPERATOR <~> (
52-
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = hamming_distance,
53-
COMMUTATOR = '<~>'
54-
);
55-
56-
CREATE OPERATOR <%> (
57-
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = jaccard_distance,
58-
COMMUTATOR = '<%>'
59-
);
60-
61-
CREATE OPERATOR CLASS bit_hamming_ops
62-
FOR TYPE bit USING ivfflat AS
63-
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
64-
FUNCTION 1 hamming_distance(bit, bit),
65-
FUNCTION 3 hamming_distance(bit, bit),
66-
FUNCTION 5 ivfflat_bit_support(internal);
67-
68-
CREATE OPERATOR CLASS bit_hamming_ops
69-
FOR TYPE bit USING hnsw AS
70-
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
71-
FUNCTION 1 hamming_distance(bit, bit),
72-
FUNCTION 3 hnsw_bit_support(internal);
73-
74-
CREATE OPERATOR CLASS bit_jaccard_ops
75-
FOR TYPE bit USING hnsw AS
76-
OPERATOR 1 <%> (bit, bit) FOR ORDER BY float_ops,
77-
FUNCTION 1 jaccard_distance(bit, bit),
78-
FUNCTION 3 hnsw_bit_support(internal);
79-
8045
CREATE TYPE halfvec;
8146

8247
CREATE FUNCTION halfvec_in(cstring, oid, integer) RETURNS halfvec
@@ -377,6 +342,41 @@ CREATE OPERATOR CLASS halfvec_l1_ops
377342
FUNCTION 1 l1_distance(halfvec, halfvec),
378343
FUNCTION 3 hnsw_halfvec_support(internal);
379344

345+
CREATE FUNCTION hamming_distance(bit, bit) RETURNS float8
346+
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
347+
348+
CREATE FUNCTION jaccard_distance(bit, bit) RETURNS float8
349+
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
350+
351+
CREATE OPERATOR <~> (
352+
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = hamming_distance,
353+
COMMUTATOR = '<~>'
354+
);
355+
356+
CREATE OPERATOR <%> (
357+
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = jaccard_distance,
358+
COMMUTATOR = '<%>'
359+
);
360+
361+
CREATE OPERATOR CLASS bit_hamming_ops
362+
FOR TYPE bit USING ivfflat AS
363+
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
364+
FUNCTION 1 hamming_distance(bit, bit),
365+
FUNCTION 3 hamming_distance(bit, bit),
366+
FUNCTION 5 ivfflat_bit_support(internal);
367+
368+
CREATE OPERATOR CLASS bit_hamming_ops
369+
FOR TYPE bit USING hnsw AS
370+
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
371+
FUNCTION 1 hamming_distance(bit, bit),
372+
FUNCTION 3 hnsw_bit_support(internal);
373+
374+
CREATE OPERATOR CLASS bit_jaccard_ops
375+
FOR TYPE bit USING hnsw AS
376+
OPERATOR 1 <%> (bit, bit) FOR ORDER BY float_ops,
377+
FUNCTION 1 jaccard_distance(bit, bit),
378+
FUNCTION 3 hnsw_bit_support(internal);
379+
380380
CREATE TYPE sparsevec;
381381

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

‎sql/vector.sql‎

Lines changed: 45 additions & 45 deletions
Original file line numberDiff line numberDiff line change
@@ -263,18 +263,18 @@ COMMENT ON ACCESS METHOD hnsw IS 'hnsw index access method';
263263

264264
-- access method private functions
265265

266-
CREATE FUNCTION ivfflat_bit_support(internal) RETURNS internal
267-
AS 'MODULE_PATHNAME' LANGUAGE C;
268-
269266
CREATE FUNCTION ivfflat_halfvec_support(internal) RETURNS internal
270267
AS 'MODULE_PATHNAME' LANGUAGE C;
271268

272-
CREATE FUNCTION hnsw_bit_support(internal) RETURNS internal
269+
CREATE FUNCTION ivfflat_bit_support(internal) RETURNS internal
273270
AS 'MODULE_PATHNAME' LANGUAGE C;
274271

275272
CREATE FUNCTION hnsw_halfvec_support(internal) RETURNS internal
276273
AS 'MODULE_PATHNAME' LANGUAGE C;
277274

275+
CREATE FUNCTION hnsw_bit_support(internal) RETURNS internal
276+
AS 'MODULE_PATHNAME' LANGUAGE C;
277+
278278
CREATE FUNCTION hnsw_sparsevec_support(internal) RETURNS internal
279279
AS 'MODULE_PATHNAME' LANGUAGE C;
280280

@@ -331,47 +331,6 @@ CREATE OPERATOR CLASS vector_l1_ops
331331
OPERATOR 1 <+> (vector, vector) FOR ORDER BY float_ops,
332332
FUNCTION 1 l1_distance(vector, vector);
333333

334-
-- bit functions
335-
336-
CREATE FUNCTION hamming_distance(bit, bit) RETURNS float8
337-
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
338-
339-
CREATE FUNCTION jaccard_distance(bit, bit) RETURNS float8
340-
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
341-
342-
-- bit operators
343-
344-
CREATE OPERATOR <~> (
345-
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = hamming_distance,
346-
COMMUTATOR = '<~>'
347-
);
348-
349-
CREATE OPERATOR <%> (
350-
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = jaccard_distance,
351-
COMMUTATOR = '<%>'
352-
);
353-
354-
-- bit opclasses
355-
356-
CREATE OPERATOR CLASS bit_hamming_ops
357-
FOR TYPE bit USING ivfflat AS
358-
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
359-
FUNCTION 1 hamming_distance(bit, bit),
360-
FUNCTION 3 hamming_distance(bit, bit),
361-
FUNCTION 5 ivfflat_bit_support(internal);
362-
363-
CREATE OPERATOR CLASS bit_hamming_ops
364-
FOR TYPE bit USING hnsw AS
365-
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
366-
FUNCTION 1 hamming_distance(bit, bit),
367-
FUNCTION 3 hnsw_bit_support(internal);
368-
369-
CREATE OPERATOR CLASS bit_jaccard_ops
370-
FOR TYPE bit USING hnsw AS
371-
OPERATOR 1 <%> (bit, bit) FOR ORDER BY float_ops,
372-
FUNCTION 1 jaccard_distance(bit, bit),
373-
FUNCTION 3 hnsw_bit_support(internal);
374-
375334
-- halfvec type
376335

377336
CREATE TYPE halfvec;
@@ -688,6 +647,47 @@ CREATE OPERATOR CLASS halfvec_l1_ops
688647
FUNCTION 1 l1_distance(halfvec, halfvec),
689648
FUNCTION 3 hnsw_halfvec_support(internal);
690649

650+
-- bit functions
651+
652+
CREATE FUNCTION hamming_distance(bit, bit) RETURNS float8
653+
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
654+
655+
CREATE FUNCTION jaccard_distance(bit, bit) RETURNS float8
656+
AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
657+
658+
-- bit operators
659+
660+
CREATE OPERATOR <~> (
661+
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = hamming_distance,
662+
COMMUTATOR = '<~>'
663+
);
664+
665+
CREATE OPERATOR <%> (
666+
LEFTARG = bit, RIGHTARG = bit, PROCEDURE = jaccard_distance,
667+
COMMUTATOR = '<%>'
668+
);
669+
670+
-- bit opclasses
671+
672+
CREATE OPERATOR CLASS bit_hamming_ops
673+
FOR TYPE bit USING ivfflat AS
674+
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
675+
FUNCTION 1 hamming_distance(bit, bit),
676+
FUNCTION 3 hamming_distance(bit, bit),
677+
FUNCTION 5 ivfflat_bit_support(internal);
678+
679+
CREATE OPERATOR CLASS bit_hamming_ops
680+
FOR TYPE bit USING hnsw AS
681+
OPERATOR 1 <~> (bit, bit) FOR ORDER BY float_ops,
682+
FUNCTION 1 hamming_distance(bit, bit),
683+
FUNCTION 3 hnsw_bit_support(internal);
684+
685+
CREATE OPERATOR CLASS bit_jaccard_ops
686+
FOR TYPE bit USING hnsw AS
687+
OPERATOR 1 <%> (bit, bit) FOR ORDER BY float_ops,
688+
FUNCTION 1 jaccard_distance(bit, bit),
689+
FUNCTION 3 hnsw_bit_support(internal);
690+
691691
--- sparsevec type
692692

693693
CREATE TYPE sparsevec;

0 commit comments

Comments
 (0)