-- varint64
CREATE FUNCTION varint64_in(cstring)
   RETURNS varint64
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_in(cstring) IS 'Convert a cstring to varint64';

CREATE FUNCTION varint64_out(varint64)
   RETURNS cstring
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_in(cstring) IS 'Convert a varint64 to cstring';

CREATE FUNCTION varint64_recv(internal)
   RETURNS varint64
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION varint64_send(varint64)
   RETURNS bytea
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;

CREATE TYPE varint64 (
   internallength = VARIABLE,
   input = varint64_in,
   output = varint64_out,
   receive = varint64_recv,
   send = varint64_send,
   alignment = int4,
   storage = main
);


-- varuint64
CREATE FUNCTION varuint64_in(cstring)
   RETURNS varuint64
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_in(cstring) IS 'Convert a cstring to varuint64';

CREATE FUNCTION varuint64_out(varuint64)
   RETURNS cstring
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_in(cstring) IS 'Convert a varuint64 to cstring';

CREATE FUNCTION varuint64_recv(internal)
   RETURNS varuint64
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION varuint64_send(varuint64)
   RETURNS bytea
   AS 'varint'
   LANGUAGE C IMMUTABLE STRICT;

CREATE TYPE varuint64 (
   internallength = VARIABLE,
   input = varuint64_in,
   output = varuint64_out,
   receive = varuint64_recv,
   send = varuint64_send,
   alignment = int4,
   storage = main
);


-- varint64 operator functions
CREATE FUNCTION varint64_lt(varint64, varint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_lt(varint64, varint64) IS 'Returns true if a < b';

CREATE FUNCTION varint64_le(varint64, varint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_le(varint64, varint64) IS 'Returns true if a <= b';

CREATE FUNCTION varint64_eq(varint64, varint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_eq(varint64, varint64) IS 'Returns true if a = b';

CREATE FUNCTION varint64_ne(varint64, varint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_ne(varint64, varint64) IS 'Returns true if a != b';

CREATE FUNCTION varint64_ge(varint64, varint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_ge(varint64, varint64) IS 'Returns true if a >= b';

CREATE FUNCTION varint64_gt(varint64, varint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_gt(varint64, varint64) IS 'Returns true if a > b';


-- varuint64 operator functions
CREATE FUNCTION varuint64_lt(varuint64, varuint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_lt(varuint64, varuint64) IS 'Returns true if a < b';

CREATE FUNCTION varuint64_le(varuint64, varuint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_le(varuint64, varuint64) IS 'Returns true if a <= b';

CREATE FUNCTION varuint64_eq(varuint64, varuint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_eq(varuint64, varuint64) IS 'Returns true if a = b';

CREATE FUNCTION varuint64_ne(varuint64, varuint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_ne(varuint64, varuint64) IS 'Returns true if a != b';

CREATE FUNCTION varuint64_ge(varuint64, varuint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_ge(varuint64, varuint64) IS 'Returns true if a >= b';

CREATE FUNCTION varuint64_gt(varuint64, varuint64) RETURNS bool
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_gt(varuint64, varuint64) IS 'Returns true if a > b';


-- varint64 operators
CREATE OPERATOR < (
   leftarg = varint64, rightarg = varint64, procedure = varint64_lt,
   commutator = > , negator = >= ,
   restrict = scalarltsel, join = scalarltjoinsel
);
CREATE OPERATOR <= (
   leftarg = varint64, rightarg = varint64, procedure = varint64_le,
   commutator = >= , negator = > ,
   restrict = scalarltsel, join = scalarltjoinsel
);
CREATE OPERATOR = (
   leftarg = varint64, rightarg = varint64, procedure = varint64_eq,
   commutator = = , negator = <> ,
   restrict = eqsel, join = eqjoinsel
);
CREATE OPERATOR <> (
   leftarg = varint64, rightarg = varint64, procedure = varint64_ne,
   commutator = <> , negator = = ,
   restrict = neqsel, join = neqjoinsel
);
CREATE OPERATOR >= (
   leftarg = varint64, rightarg = varint64, procedure = varint64_ge,
   commutator = <= , negator = < ,
   restrict = scalargtsel, join = scalargtjoinsel
);
CREATE OPERATOR > (
   leftarg = varint64, rightarg = varint64, procedure = varint64_gt,
   commutator = < , negator = <= ,
   restrict = scalargtsel, join = scalargtjoinsel
);


-- varuint64 operators
CREATE OPERATOR < (
   leftarg = varuint64, rightarg = varuint64, procedure = varuint64_lt,
   commutator = > , negator = >= ,
   restrict = scalarltsel, join = scalarltjoinsel
);
CREATE OPERATOR <= (
   leftarg = varuint64, rightarg = varuint64, procedure = varuint64_le,
   commutator = >= , negator = > ,
   restrict = scalarltsel, join = scalarltjoinsel
);
CREATE OPERATOR = (
   leftarg = varuint64, rightarg = varuint64, procedure = varuint64_eq,
   commutator = = , negator = <> ,
   restrict = eqsel, join = eqjoinsel
);
CREATE OPERATOR <> (
   leftarg = varuint64, rightarg = varuint64, procedure = varuint64_ne,
   commutator = <> , negator = = ,
   restrict = neqsel, join = neqjoinsel
);
CREATE OPERATOR >= (
   leftarg = varuint64, rightarg = varuint64, procedure = varuint64_ge,
   commutator = <= , negator = < ,
   restrict = scalargtsel, join = scalargtjoinsel
);
CREATE OPERATOR > (
   leftarg = varuint64, rightarg = varuint64, procedure = varuint64_gt,
   commutator = < , negator = <= ,
   restrict = scalargtsel, join = scalargtjoinsel
);


-- varint64 cmp function
CREATE FUNCTION varint64_cmp(varint64, varint64) RETURNS int4
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64_cmp(varint64, varint64) IS 'varint64 B-tree comparison operator';

CREATE OPERATOR CLASS varint64_ops
    DEFAULT FOR TYPE varint64 USING btree AS
        OPERATOR        1       < ,
        OPERATOR        2       <= ,
        OPERATOR        3       = ,
        OPERATOR        4       >= ,
        OPERATOR        5       > ,
        FUNCTION        1       varint64_cmp(varint64, varint64);


-- varuint64 cmp function
CREATE FUNCTION varuint64_cmp(varuint64, varuint64) RETURNS int4
   AS 'varint' LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64_cmp(varuint64, varuint64) IS 'varuint64 B-tree comparison operator';

CREATE OPERATOR CLASS varuint64_ops
    DEFAULT FOR TYPE varuint64 USING btree AS
        OPERATOR        1       < ,
        OPERATOR        2       <= ,
        OPERATOR        3       = ,
        OPERATOR        4       >= ,
        OPERATOR        5       > ,
        FUNCTION        1       varuint64_cmp(varuint64, varuint64);


-- varint64 type conversions
CREATE FUNCTION varint64(int2) RETURNS varint64 AS 'varint', 'int2_to_varint64'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64(int2) IS 'Convert a varint64 to an int2';

CREATE FUNCTION varint64(int4) RETURNS varint64 AS 'varint', 'int4_to_varint64'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64(int4) IS 'Convert a varint64 to an int4';

CREATE FUNCTION varint64(int8) RETURNS varint64 AS 'varint', 'int8_to_varint64'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varint64(int8) IS 'Convert a varint64 to an int8';

CREATE FUNCTION int2(varint64) RETURNS int2 AS 'varint', 'varint64_to_int2'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION int2(varint64) IS 'Convert an int2 to varint64';

CREATE FUNCTION int4(varint64) RETURNS int4 AS 'varint', 'varint64_to_int4'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION int4(varint64) IS 'Convert an int4 to varint64';

CREATE FUNCTION int8(varint64) RETURNS int8 AS 'varint', 'varint64_to_int8'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION int8(varint64) IS 'Convert an int8 to varint64';


-- varuint64 type conversions
CREATE FUNCTION varuint64(int2) RETURNS varuint64 AS 'varint', 'int2_to_varuint64'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64(int2) IS 'Convert a varuint64 to an int2';

CREATE FUNCTION varuint64(int4) RETURNS varuint64 AS 'varint', 'int4_to_varuint64'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64(int4) IS 'Convert a varuint64 to an int4';

CREATE FUNCTION varuint64(int8) RETURNS varuint64 AS 'varint', 'int8_to_varuint64'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION varuint64(int8) IS 'Convert a varuint64 to an int8';

CREATE FUNCTION int2(varuint64) RETURNS int2 AS 'varint', 'varuint64_to_int2'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION int2(varuint64) IS 'Convert an int2 to varuint64';

CREATE FUNCTION int4(varuint64) RETURNS int4 AS 'varint', 'varuint64_to_int4'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION int4(varuint64) IS 'Convert an int4 to varuint64';

CREATE FUNCTION int8(varuint64) RETURNS int8 AS 'varint', 'varuint64_to_int8'
  LANGUAGE C IMMUTABLE STRICT;
COMMENT ON FUNCTION int8(varuint64) IS 'Convert an int8 to varuint64';


-- varint64 casts
CREATE CAST (int2 AS varint64) WITH FUNCTION varint64(int2) AS IMPLICIT;
CREATE CAST (int4 AS varint64) WITH FUNCTION varint64(int4) AS IMPLICIT;
CREATE CAST (int8 AS varint64) WITH FUNCTION varint64(int8) AS IMPLICIT;

CREATE CAST (varint64 AS int2) WITH FUNCTION int2(varint64) AS ASSIGNMENT;
CREATE CAST (varint64 AS int4) WITH FUNCTION int4(varint64) AS ASSIGNMENT;
CREATE CAST (varint64 AS int8) WITH FUNCTION int8(varint64) AS IMPLICIT;


-- varuint64 casts
CREATE CAST (int2 AS varuint64) WITH FUNCTION varuint64(int2) AS IMPLICIT;
CREATE CAST (int4 AS varuint64) WITH FUNCTION varuint64(int4) AS IMPLICIT;
CREATE CAST (int8 AS varuint64) WITH FUNCTION varuint64(int8) AS IMPLICIT;

CREATE CAST (varuint64 AS int2) WITH FUNCTION int2(varuint64) AS ASSIGNMENT;
CREATE CAST (varuint64 AS int4) WITH FUNCTION int4(varuint64) AS ASSIGNMENT;
CREATE CAST (varuint64 AS int8) WITH FUNCTION int8(varuint64) AS IMPLICIT;