Support range data types.

Selectivity estimation functions are missing for some range type operators,
which is a TODO.

Jeff Davis

1 files changed, 84 insertions, 0 deletions

diff --git a/src/include/catalog/pg_range.h b/src/include/catalog/pg_range.h
new file mode 100644
index 0000000000..19b437db8d
--- /dev/null
+++ b/src/include/catalog/pg_range.h
@@ -0,0 +1,84 @@
+/*-------------------------------------------------------------------------
+ *
+ * pg_range.h
+ *	  definition of the system "range" relation (pg_range)
+ *	  along with the relation's initial contents.
+ *
+ *
+ * Copyright (c) 2006-2010, PostgreSQL Global Development Group
+ *
+ * src/include/catalog/pg_range.h
+ *
+ * NOTES
+ *	  the genbki.pl script reads this file and generates .bki
+ *	  information from the DATA() statements.
+ *
+ *	  XXX do NOT break up DATA() statements into multiple lines!
+ *		  the scripts are not as smart as you might think...
+ *
+ *-------------------------------------------------------------------------
+ */
+#ifndef PG_RANGE_H
+#define PG_RANGE_H
+
+#include "catalog/genbki.h"
+
+/* ----------------
+ *		pg_range definition.  cpp turns this into
+ *		typedef struct FormData_pg_range
+ * ----------------
+ */
+#define RangeRelationId	3541
+
+CATALOG(pg_range,3541) BKI_WITHOUT_OIDS
+{
+	Oid			rngtypid;		/* OID of owning range type */
+	Oid			rngsubtype;		/* OID of range's subtype */
+	Oid			rngcollation;	/* collation for this range type, or 0 */
+	Oid			rngsubopc;		/* subtype's btree opclass */
+	regproc		rngcanonical;	/* canonicalize range, or 0 */
+	regproc		rngsubdiff;		/* subtype difference as a float8 (for GiST) */
+} FormData_pg_range;
+
+/* ----------------
+ *		Form_pg_range corresponds to a pointer to a tuple with
+ *		the format of pg_range relation.
+ * ----------------
+ */
+typedef FormData_pg_range *Form_pg_range;
+
+/* ----------------
+ *		compiler constants for pg_range
+ * ----------------
+ */
+#define Natts_pg_range					6
+#define Anum_pg_range_rngtypid			1
+#define Anum_pg_range_rngsubtype		2
+#define Anum_pg_range_rngcollation		3
+#define Anum_pg_range_rngsubopc			4
+#define Anum_pg_range_rngcanonical		5
+#define Anum_pg_range_rngsubdiff		6
+
+#define RANGE_DEFAULT_FLAGS		"[)"
+
+/*
+ * prototypes for functions in pg_range.c
+ */
+
+extern void RangeCreate(Oid rangeTypeOid, Oid rangeSubType, Oid rangeCollation,
+			Oid rangeSubOpclass, RegProcedure rangeCanonical,
+			RegProcedure rangeSubDiff);
+extern void RangeDelete(Oid rangeTypeOid);
+
+/* ----------------
+ *		initial contents of pg_range
+ * ----------------
+ */
+DATA(insert ( 3904 23 0 1978 int4range_canonical int4range_subdiff));
+DATA(insert ( 3906 1700 0 10037 - numrange_subdiff));
+DATA(insert ( 3908 1114 0 10054 - tsrange_subdiff));
+DATA(insert ( 3910 1184 0 10047 - tstzrange_subdiff));
+DATA(insert ( 3912 1082 0 10019 daterange_canonical daterange_subdiff));
+DATA(insert ( 3926 20 0 10029 int8range_canonical int8range_subdiff));
+
+#endif   /* PG_RANGE_H */