2a738ccf9a
git-svn-id: http://svn.osgeo.org/postgis/trunk@16327 b70326c6-7e19-0410-871a-916f4a2858ee
80 lines
2.4 KiB
MySQL
80 lines
2.4 KiB
MySQL
-- Bare minimum Legacy functions --
|
|
-- This file that contains what we have determined are
|
|
-- the most common functions used by older apps
|
|
-- You should be able to get by with just to support
|
|
-- older versions of mapserver, geoserver, qgis, gdal, openjump etc.
|
|
#include "sqldefines.h"
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION AsBinary(geometry)
|
|
RETURNS bytea
|
|
AS 'MODULE_PATHNAME','LWGEOM_asBinary'
|
|
LANGUAGE 'c' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION AsBinary(geometry,text)
|
|
RETURNS bytea
|
|
AS 'MODULE_PATHNAME','LWGEOM_asBinary'
|
|
LANGUAGE 'c' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION AsText(geometry)
|
|
RETURNS TEXT
|
|
AS 'MODULE_PATHNAME','LWGEOM_asText'
|
|
LANGUAGE 'c' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION Estimated_Extent(text,text,text) RETURNS box2d AS
|
|
'MODULE_PATHNAME', 'geometry_estimated_extent'
|
|
LANGUAGE 'c' IMMUTABLE STRICT SECURITY DEFINER;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION Estimated_Extent(text,text) RETURNS box2d AS
|
|
'MODULE_PATHNAME', 'geometry_estimated_extent'
|
|
LANGUAGE 'c' IMMUTABLE STRICT SECURITY DEFINER;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION GeomFromText(text, int4)
|
|
RETURNS geometry AS 'SELECT ST_GeomFromText($1, $2)'
|
|
LANGUAGE 'sql' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION GeomFromText(text)
|
|
RETURNS geometry AS 'SELECT ST_GeomFromText($1)'
|
|
LANGUAGE 'sql' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION ndims(geometry)
|
|
RETURNS smallint
|
|
AS 'MODULE_PATHNAME', 'LWGEOM_ndims'
|
|
LANGUAGE 'c' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION SetSRID(geometry,int4)
|
|
RETURNS geometry
|
|
AS 'MODULE_PATHNAME','LWGEOM_set_srid'
|
|
LANGUAGE 'c' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.2.3
|
|
CREATE OR REPLACE FUNCTION SRID(geometry)
|
|
RETURNS int4
|
|
AS 'MODULE_PATHNAME','LWGEOM_get_srid'
|
|
LANGUAGE 'c' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.5.0
|
|
-- hack to allow unknown to cast to geometry
|
|
-- so does not yield function is not unique
|
|
CREATE OR REPLACE FUNCTION ST_AsBinary(text)
|
|
RETURNS bytea
|
|
AS
|
|
$$ SELECT ST_AsBinary($1::geometry);$$
|
|
LANGUAGE 'sql' IMMUTABLE STRICT;
|
|
|
|
-- Deprecation in 1.5.0
|
|
-- hack to allow unknown to cast to geometry
|
|
-- so does not yield function is not unique
|
|
CREATE OR REPLACE FUNCTION ST_AsText(bytea)
|
|
RETURNS text
|
|
AS
|
|
$$ SELECT ST_AsText($1::geometry);$$
|
|
LANGUAGE 'sql' IMMUTABLE STRICT;
|