From 96d94fb1ea7d78e65b4144f813101df9332d06b3 Mon Sep 17 00:00:00 2001 From: Paul Ramsey Date: Fri, 17 Jun 2011 21:26:08 +0000 Subject: [PATCH] Retrieving and storing Geography column data through JDBC does not work (#350) git-svn-id: http://svn.osgeo.org/postgis/trunk@7415 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/geography.sql.in.c | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/postgis/geography.sql.in.c b/postgis/geography.sql.in.c index 2b1431c65..4365de0e5 100644 --- a/postgis/geography.sql.in.c +++ b/postgis/geography.sql.in.c @@ -87,6 +87,24 @@ CREATE OR REPLACE FUNCTION geography(geography, integer, boolean) -- Availability: 1.5.0 CREATE CAST (geography AS geography) WITH FUNCTION geography(geography, integer, boolean) AS IMPLICIT; +-- Availability: 2.0.0 +CREATE OR REPLACE FUNCTION geography(bytea) + RETURNS geography + AS 'MODULE_PATHNAME','LWGEOM_from_bytea' + LANGUAGE 'C' IMMUTABLE STRICT; + +-- Availability: 2.0.0 +CREATE OR REPLACE FUNCTION bytea(geography) + RETURNS bytea + AS 'MODULE_PATHNAME','LWGEOM_to_bytea' + LANGUAGE 'C' IMMUTABLE STRICT; + +-- Availability: 2.0.0 +CREATE CAST (bytea AS geography) WITH FUNCTION geography(bytea) AS IMPLICIT; +-- Availability: 2.0.0 +CREATE CAST (geography AS bytea) WITH FUNCTION bytea(geography) AS IMPLICIT; + + -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_AsText(geography) RETURNS text -- 2.50.1