pg_ddate--1.0.sql

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

CREATE TYPE ddate;

CREATE OR REPLACE FUNCTION ddate_in(cstring)
RETURNS ddate
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_out(ddate)
RETURNS cstring
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_recv(internal)
RETURNS ddate
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_send(ddate)
RETURNS bytea
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE TYPE ddate (
    internallength = 4,
    input = ddate_in,
    output = ddate_out,
    receive = ddate_recv,
    send = ddate_send,
    alignment = int4,
    storage = plain
);

CREATE OR REPLACE FUNCTION date_to_ddate(date)
RETURNS ddate
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_to_date(ddate)
RETURNS date
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE CAST (date AS ddate) WITH FUNCTION date_to_ddate(date) AS IMPLICIT;
CREATE CAST (ddate AS date) WITH FUNCTION ddate_to_date(ddate) AS IMPLICIT;

CREATE OR REPLACE FUNCTION ddate_eq(ddate, ddate)
RETURNS boolean
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_ne(ddate, ddate)
RETURNS boolean
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_lt(ddate, ddate)
RETURNS boolean
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_le(ddate, ddate)
RETURNS boolean
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_gt(ddate, ddate)
RETURNS boolean
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_ge(ddate, ddate)
RETURNS boolean
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION ddate_cmp(ddate, ddate)
RETURNS integer
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OPERATOR = (
    leftarg = ddate,
    rightarg = ddate,
    procedure = ddate_eq,
    commutator = =,
    negator = <>,
    restrict = eqsel,
    join = eqjoinsel,
    hashes,
    merges
);

CREATE OPERATOR <> (
    leftarg = ddate,
    rightarg = ddate,
    procedure = ddate_ne,
    commutator = <>,
    negator = =,
    restrict = neqsel,
    join = neqjoinsel
);

CREATE OPERATOR < (
    leftarg = ddate,
    rightarg = ddate,
    procedure = ddate_lt,
    commutator = >,
    negator = >=,
    restrict = scalarltsel,
    join = scalarltjoinsel
);

CREATE OPERATOR <= (
    leftarg = ddate,
    rightarg = ddate,
    procedure = ddate_le,
    commutator = >=,
    negator = >,
    restrict = scalarltsel,
    join = scalarltjoinsel
);

CREATE OPERATOR > (
    leftarg = ddate,
    rightarg = ddate,
    procedure = ddate_gt,
    commutator = <,
    negator = <=,
    restrict = scalargtsel,
    join = scalargtjoinsel
);

CREATE OPERATOR >= (
    leftarg = ddate,
    rightarg = ddate,
    procedure = ddate_ge,
    commutator = <=,
    negator = <,
    restrict = scalargtsel,
    join = scalargtjoinsel
);

CREATE OPERATOR CLASS ddate_ops
DEFAULT FOR TYPE ddate USING btree AS
    OPERATOR 1 <,
    OPERATOR 2 <=,
    OPERATOR 3 =,
    OPERATOR 4 >=,
    OPERATOR 5 >,
    FUNCTION 1 ddate_cmp(ddate, ddate);

CREATE OR REPLACE FUNCTION ddate_now()
RETURNS ddate
AS 'MODULE_PATHNAME'
LANGUAGE C VOLATILE;

CREATE OR REPLACE FUNCTION ddate_regexeq(ddate, text)
RETURNS boolean
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE STRICT;

CREATE OPERATOR ~ (
    leftarg = ddate,
    rightarg = text,
    procedure = ddate_regexeq,
    restrict = regexeqsel,
    join = regexeqjoinsel
);