From 54b115e6b0d4718fcc271219583512988a7cef7d Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Tue, 17 Jan 2012 18:04:58 +0000 Subject: [PATCH] Override geometrytype for geography (#1450). The testusite runs without problems so I didn't also add a geometrytype(text) function [I want the implicit cast!] git-svn-id: http://svn.osgeo.org/postgis/trunk@8856 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/geography.sql.in.c | 6 ++++++ regress/tickets.sql | 3 +++ regress/tickets_expected | 1 + 3 files changed, 10 insertions(+) diff --git a/postgis/geography.sql.in.c b/postgis/geography.sql.in.c index c85e85af6..cb1985cbd 100644 --- a/postgis/geography.sql.in.c +++ b/postgis/geography.sql.in.c @@ -683,6 +683,12 @@ CREATE OR REPLACE FUNCTION ST_AsEWKT(text) $$ SELECT ST_AsEWKT($1::geometry); $$ LANGUAGE 'SQL' IMMUTABLE STRICT; +-- Availability: 2.0.0 +CREATE OR REPLACE FUNCTION GeometryType(geography) + RETURNS text + AS 'MODULE_PATHNAME', 'LWGEOM_getTYPE' + LANGUAGE 'C' IMMUTABLE STRICT; + ----------------------------------------------------------------------------- diff --git a/regress/tickets.sql b/regress/tickets.sql index 095bd1725..56f6d870d 100644 --- a/regress/tickets.sql +++ b/regress/tickets.sql @@ -527,6 +527,9 @@ SELECT '#1478', 'SRID=1;POINT EMPTY'::geometry::text::geometry; SELECT '#745', ST_AsEWKT(ST_Split('POLYGON((-72 42 1,-70 43 1,-71 41 1,-72 42 1))', 'LINESTRING(-10 40 1,-9 41 1)')); +-- #1450 +SELECT '#1450', GeometryType('POINT(0 0)'::geography), GeometryType('POLYGON EMPTY'::geography); + -- Clean up DELETE FROM spatial_ref_sys; diff --git a/regress/tickets_expected b/regress/tickets_expected index bd8f62088..de2316cb5 100644 --- a/regress/tickets_expected +++ b/regress/tickets_expected @@ -175,3 +175,4 @@ ERROR: MultiSurface cannot contain MultiPoint element #1414|CURVEPOLYGON Z EMPTY #1478|01040000200100000000000000 #745|GEOMETRYCOLLECTION(POLYGON((-72 42 1,-70 43 1,-71 41 1,-72 42 1))) +#1450|POINT|POLYGON -- 2.40.0