From 5cbf2bf538d7f3299e0519efdc7f8b48fbab86a0 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Thu, 3 Jun 2004 13:43:01 +0000 Subject: [PATCH] compatted CASTS section, commented out bogus cast geometry::chip referring to missing function git-svn-id: http://svn.osgeo.org/postgis/trunk@577 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis.sql.in | 54 ++++++++++++++------------------------------------ 1 file changed, 15 insertions(+), 39 deletions(-) diff --git a/postgis.sql.in b/postgis.sql.in index 4af5228ff..31dba7206 100644 --- a/postgis.sql.in +++ b/postgis.sql.in @@ -374,7 +374,7 @@ BEGIN #if USE_VERSION >= 75 -- no linkage to system table needed - return "done"; + return ''done.''; #endif -- fix linking to system tables @@ -1924,18 +1924,6 @@ INSERT INTO pg_amproc (amopclaid, amprocnum, amproc) #elif USE_VERSION == 73 --- --- 7.3 explicit casting definitions --- - -CREATE CAST ( chip AS geometry ) WITH FUNCTION geometry(chip) AS IMPLICIT; -CREATE CAST ( geometry AS box3d ) WITH FUNCTION box3d(geometry) AS IMPLICIT; -CREATE CAST ( geometry AS box ) WITH FUNCTION box(geometry) AS IMPLICIT; -CREATE CAST ( box3d AS geometry ) WITH FUNCTION geometry(box3d) AS IMPLICIT; -CREATE CAST ( text AS geometry) WITH FUNCTION geometry(text) AS IMPLICIT; -CREATE CAST ( wkb AS bytea ) WITH FUNCTION bytea(wkb) AS IMPLICIT; -CREATE CAST ( box3d AS box ) WITH FUNCTION box3dtobox(box3d); -CREATE CAST ( geometry AS text ) WITH FUNCTION astext(geometry); CREATEFUNCTION postgisgistcostestimate(internal,internal,internal,internal,internal,internal,internal,internal) @@ -2030,18 +2018,6 @@ UPDATE pg_opclass #elif USE_VERSION == 74 --- --- 7.3 explicit casting definitions --- - -CREATE CAST ( chip AS geometry ) WITH FUNCTION geometry(chip) AS IMPLICIT; -CREATE CAST ( geometry AS box3d ) WITH FUNCTION box3d(geometry) AS IMPLICIT; -CREATE CAST ( geometry AS box ) WITH FUNCTION box(geometry) AS IMPLICIT; -CREATE CAST ( box3d AS geometry ) WITH FUNCTION geometry(box3d) AS IMPLICIT; -CREATE CAST ( text AS geometry) WITH FUNCTION geometry(text) AS IMPLICIT; -CREATE CAST ( wkb AS bytea ) WITH FUNCTION bytea(wkb) AS IMPLICIT; -CREATE CAST ( box3d AS box ) WITH FUNCTION box3dtobox(box3d); -CREATE CAST ( geometry AS text ) WITH FUNCTION astext(geometry); CREATEFUNCTION postgisgistcostestimate(internal,internal,internal,internal,internal,internal,internal,internal) RETURNS opaque @@ -2145,20 +2121,6 @@ CREATE OPERATOR CLASS btree_geometry_ops #elif USE_VERSION == 75 --- - - - - - - - - - - - - - - - - - - - - - - - - - - - --- WKB --- --- 7.3 explicit casting definitions --- - -CREATE CAST ( chip AS geometry ) WITH FUNCTION geometry(chip) AS IMPLICIT; -CREATE CAST ( geometry AS box3d ) WITH FUNCTION box3d(geometry) AS IMPLICIT; -CREATE CAST ( geometry AS box ) WITH FUNCTION box(geometry) AS IMPLICIT; -CREATE CAST ( box3d AS geometry ) WITH FUNCTION geometry(box3d) AS IMPLICIT; -CREATE CAST ( text AS geometry) WITH FUNCTION geometry(text) AS IMPLICIT; -CREATE CAST ( wkb AS bytea ) WITH FUNCTION bytea(wkb) AS IMPLICIT; -CREATE CAST ( box3d AS box ) WITH FUNCTION box3dtobox(box3d); -CREATE CAST ( geometry AS text ) WITH FUNCTION astext(geometry); -- -- 7.2 GiST support functions @@ -2265,6 +2227,20 @@ CREATE OPERATOR CLASS btree_geometry_ops -- --------------------------------------------- +----------------------------------------------------------------------- +-- 7.3+ explicit casting definitions +----------------------------------------------------------------------- +#if USE_VERSION >= 73 +--CREATE CAST ( chip AS geometry ) WITH FUNCTION geometry(chip) AS IMPLICIT; +CREATE CAST ( geometry AS box3d ) WITH FUNCTION box3d(geometry) AS IMPLICIT; +CREATE CAST ( geometry AS box ) WITH FUNCTION box(geometry) AS IMPLICIT; +CREATE CAST ( box3d AS geometry ) WITH FUNCTION geometry(box3d) AS IMPLICIT; +CREATE CAST ( text AS geometry) WITH FUNCTION geometry(text) AS IMPLICIT; +CREATE CAST ( wkb AS bytea ) WITH FUNCTION bytea(wkb) AS IMPLICIT; +CREATE CAST ( box3d AS box ) WITH FUNCTION box3dtobox(box3d); +CREATE CAST ( geometry AS text ) WITH FUNCTION astext(geometry); +#endif + ----------------------------------------------------------------------- -- ADDGEOMETRYCOLUMN -- , , , , , , -- 2.40.0