X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=src%2Fpostrr.sql.in;h=01cd65f8a6be9b2c49339c629f6f0efcc72a6f4e;hb=ec00d193ed161a58be46f62fed81adfc5612cfde;hp=c2b48212784d066231cd4f7d8d27d76c81307e4a;hpb=0478a7da8a276444f96d4d0a0a13fa9448ce9250;p=postrr.git

diff --git a/src/postrr.sql.in b/src/postrr.sql.in
index c2b4821..01cd65f 100644
--- a/src/postrr.sql.in
+++ b/src/postrr.sql.in
@@ -100,50 +100,59 @@ CREATE CAST (rrtimeslice AS rrtimeslice)
 	WITH FUNCTION RRTimeslice(rrtimeslice, integer, boolean)
 	AS IMPLICIT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_eq(rrtimeslice, rrtimeslice)
+CREATE OR REPLACE FUNCTION Tstamp(rrtimeslice)
+	RETURNS timestamp
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_to_timestamp'
+	LANGUAGE 'C' IMMUTABLE STRICT;
+
+CREATE CAST (rrtimeslice AS timestamp)
+	WITH FUNCTION Tstamp(rrtimeslice);
+	-- EXPLICIT
+
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_eq(rrtimeslice, rrtimeslice)
 	RETURNS boolean
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_eq'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_eq'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_ne(rrtimeslice, rrtimeslice)
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_ne(rrtimeslice, rrtimeslice)
 	RETURNS boolean
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_ne'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_ne'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_lt(rrtimeslice, rrtimeslice)
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_lt(rrtimeslice, rrtimeslice)
 	RETURNS boolean
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_lt'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_lt'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_le(rrtimeslice, rrtimeslice)
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_le(rrtimeslice, rrtimeslice)
 	RETURNS boolean
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_le'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_le'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_gt(rrtimeslice, rrtimeslice)
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_gt(rrtimeslice, rrtimeslice)
 	RETURNS boolean
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_gt'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_gt'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_ge(rrtimeslice, rrtimeslice)
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_ge(rrtimeslice, rrtimeslice)
 	RETURNS boolean
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_ge'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_ge'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_cmp(rrtimeslice, rrtimeslice)
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_cmp(rrtimeslice, rrtimeslice)
 	RETURNS integer
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_cmp'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_cmp'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION RRTimeslice_hash(rrtimeslice)
+CREATE OR REPLACE FUNCTION rrtimeslice_seq_hash(rrtimeslice)
 	RETURNS integer
-	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_hash'
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'rrtimeslice_seq_hash'
 	LANGUAGE 'C' IMMUTABLE STRICT;
 
 CREATE OPERATOR = (
 	LEFTARG    = RRTimeslice,
 	RIGHTARG   = RRTimeslice,
-	PROCEDURE  = RRTimeslice_eq,
+	PROCEDURE  = rrtimeslice_seq_eq,
 	COMMUTATOR = =,
 	NEGATOR    = <>,
 	RESTRICT   = eqsel
@@ -152,7 +161,7 @@ CREATE OPERATOR = (
 CREATE OPERATOR <> (
 	LEFTARG    = RRTimeslice,
 	RIGHTARG   = RRTimeslice,
-	PROCEDURE  = RRTimeslice_ne,
+	PROCEDURE  = rrtimeslice_seq_ne,
 	COMMUTATOR = <>,
 	NEGATOR    = =,
 	RESTRICT   = neqsel
@@ -161,7 +170,7 @@ CREATE OPERATOR <> (
 CREATE OPERATOR < (
 	LEFTARG    = RRTimeslice,
 	RIGHTARG   = RRTimeslice,
-	PROCEDURE  = RRTimeslice_lt,
+	PROCEDURE  = rrtimeslice_seq_lt,
 	COMMUTATOR = >,
 	NEGATOR    = <=,
 	RESTRICT   = scalarltsel
@@ -170,7 +179,7 @@ CREATE OPERATOR < (
 CREATE OPERATOR <= (
 	LEFTARG    = RRTimeslice,
 	RIGHTARG   = RRTimeslice,
-	PROCEDURE  = RRTimeslice_le,
+	PROCEDURE  = rrtimeslice_seq_le,
 	COMMUTATOR = >=,
 	NEGATOR    = <,
 	RESTRICT   = scalarltsel
@@ -179,7 +188,7 @@ CREATE OPERATOR <= (
 CREATE OPERATOR > (
 	LEFTARG    = RRTimeslice,
 	RIGHTARG   = RRTimeslice,
-	PROCEDURE  = RRTimeslice_gt,
+	PROCEDURE  = rrtimeslice_seq_gt,
 	COMMUTATOR = <,
 	NEGATOR    = >=,
 	RESTRICT   = scalargtsel
@@ -188,7 +197,7 @@ CREATE OPERATOR > (
 CREATE OPERATOR >= (
 	LEFTARG    = RRTimeslice,
 	RIGHTARG   = RRTimeslice,
-	PROCEDURE  = RRTimeslice_ge,
+	PROCEDURE  = rrtimeslice_seq_ge,
 	COMMUTATOR = <=,
 	NEGATOR    = >,
 	RESTRICT   = scalargtsel
@@ -201,12 +210,12 @@ CREATE OPERATOR CLASS rrtimeslice_ops
 		OPERATOR 3 = ,
 		OPERATOR 4 >= ,
 		OPERATOR 5 > ,
-		FUNCTION 1 RRTimeslice_cmp(rrtimeslice, rrtimeslice);
+		FUNCTION 1 rrtimeslice_seq_cmp(rrtimeslice, rrtimeslice);
 
 CREATE OPERATOR CLASS rrtimeslice_hash_ops
 	FOR TYPE RRTimeslice USING hash AS
 		OPERATOR 1 = ,
-		FUNCTION 1 RRTimeslice_hash(rrtimeslice);
+		FUNCTION 1 rrtimeslice_seq_hash(rrtimeslice);
 
 CREATE TYPE CData;
 
@@ -271,6 +280,20 @@ CREATE CAST (integer AS cdata)
 	WITH FUNCTION CData(integer, integer, boolean)
 	AS ASSIGNMENT;
 
+CREATE OR REPLACE FUNCTION Float8(cdata)
+	RETURNS double precision
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'cdata_to_float8'
+	LANGUAGE 'C' IMMUTABLE STRICT;
+
+CREATE CAST (cdata AS double precision)
+	WITH FUNCTION Float8(cdata);
+	-- EXPLICIT
+
+CREATE OR REPLACE FUNCTION CData_update(cdata, cdata)
+	RETURNS cdata
+	AS 'postrr-@POSTRR_MAJOR_VERSION@.@POSTRR_MINOR_VERSION@', 'cdata_update'
+	LANGUAGE 'C' IMMUTABLE;
+
 COMMIT;
 
 SET client_min_messages TO DEFAULT;