X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=src%2Fpostrr.sql.in;h=c2b48212784d066231cd4f7d8d27d76c81307e4a;hb=0478a7da8a276444f96d4d0a0a13fa9448ce9250;hp=ffdb3a718350859625acbef996c37a5db570c733;hpb=fd01c2e8b891abe2e801e406555642284e6eef36;p=postrr.git diff --git a/src/postrr.sql.in b/src/postrr.sql.in index ffdb3a7..c2b4821 100644 --- a/src/postrr.sql.in +++ b/src/postrr.sql.in @@ -135,6 +135,11 @@ CREATE OR REPLACE FUNCTION RRTimeslice_cmp(rrtimeslice, rrtimeslice) AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_cmp' LANGUAGE 'C' IMMUTABLE STRICT; +CREATE OR REPLACE FUNCTION RRTimeslice_hash(rrtimeslice) + RETURNS integer + AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_hash' + LANGUAGE 'C' IMMUTABLE STRICT; + CREATE OPERATOR = ( LEFTARG = RRTimeslice, RIGHTARG = RRTimeslice, @@ -198,6 +203,11 @@ CREATE OPERATOR CLASS rrtimeslice_ops OPERATOR 5 > , FUNCTION 1 RRTimeslice_cmp(rrtimeslice, rrtimeslice); +CREATE OPERATOR CLASS rrtimeslice_hash_ops + FOR TYPE RRTimeslice USING hash AS + OPERATOR 1 = , + FUNCTION 1 RRTimeslice_hash(rrtimeslice); + CREATE TYPE CData; CREATE OR REPLACE FUNCTION CData_validate(integer)