From aaa4dbc0ffd74835694357de04c5b53d0ecab3c6 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 16 May 2012 08:29:14 +0000 Subject: [PATCH] #1820 part fix 9.2 language is case sensitive if quoted -- change 'C' and 'SQL' to 'c' and 'sql' git-svn-id: http://svn.osgeo.org/postgis/trunk@9735 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/geography.sql.in.c | 172 ++-- postgis/geometry_estimate.c | 1 + postgis/legacy.sql.in.c | 482 +++++------ postgis/legacy_minimal.sql.in.c | 20 +- postgis/long_xact.c | 2 +- postgis/long_xact.sql.in.c | 2 +- postgis/lwgeom_triggers.c | 1 + postgis/postgis.sql.in.c | 790 +++++++++--------- raster/rt_pg/rtpostgis.sql.in.c | 290 +++---- .../rt_pg/rtpostgis_upgrade_cleanup.sql.in.c | 6 +- topology/sql/populate.sql.in.c | 4 +- topology/sql/topogeometry/type.sql.in.c | 4 +- topology/topology.sql.in.c | 6 +- 13 files changed, 891 insertions(+), 889 deletions(-) diff --git a/postgis/geography.sql.in.c b/postgis/geography.sql.in.c index 0c782e97b..4f96cd455 100644 --- a/postgis/geography.sql.in.c +++ b/postgis/geography.sql.in.c @@ -17,43 +17,43 @@ CREATE OR REPLACE FUNCTION geography_typmod_in(cstring[]) RETURNS integer AS 'MODULE_PATHNAME','geography_typmod_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_typmod_out(integer) RETURNS cstring AS 'MODULE_PATHNAME','postgis_typmod_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_in(cstring, oid, integer) RETURNS geography AS 'MODULE_PATHNAME','geography_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_out(geography) RETURNS cstring AS 'MODULE_PATHNAME','geography_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geography_recv(internal, oid, integer) RETURNS geography AS 'MODULE_PATHNAME','geography_recv' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geography_send(geography) RETURNS bytea AS 'MODULE_PATHNAME','geography_send' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_analyze(internal) RETURNS bool AS 'MODULE_PATHNAME','geography_analyze' - LANGUAGE 'C' VOLATILE STRICT; + LANGUAGE 'c' VOLATILE STRICT; -- Availability: 1.5.0 CREATE TYPE geography ( @@ -76,7 +76,7 @@ CREATE TYPE geography ( CREATE OR REPLACE FUNCTION geography(geography, integer, boolean) RETURNS geography AS 'MODULE_PATHNAME','geography_enforce_typmod' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE CAST (geography AS geography) WITH FUNCTION geography(geography, integer, boolean) AS IMPLICIT; @@ -85,13 +85,13 @@ CREATE CAST (geography AS geography) WITH FUNCTION geography(geography, integer, CREATE OR REPLACE FUNCTION geography(bytea) RETURNS geography AS 'MODULE_PATHNAME','LWGEOM_from_bytea' - LANGUAGE 'C' IMMUTABLE STRICT; + 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; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE CAST (bytea AS geography) WITH FUNCTION geography(bytea) AS IMPLICIT; @@ -102,49 +102,49 @@ CREATE CAST (geography AS bytea) WITH FUNCTION bytea(geography) AS IMPLICIT; CREATE OR REPLACE FUNCTION ST_AsText(geography) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asText' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_AsText(text) RETURNS text AS $$ SELECT ST_AsText($1::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_GeographyFromText(text) RETURNS geography AS 'MODULE_PATHNAME','geography_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_GeogFromText(text) RETURNS geography AS 'MODULE_PATHNAME','geography_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_GeogFromWKB(bytea) RETURNS geography AS 'MODULE_PATHNAME','geography_from_binary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_typmod_dims(integer) RETURNS integer AS 'MODULE_PATHNAME','postgis_typmod_dims' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_typmod_srid(integer) RETURNS integer AS 'MODULE_PATHNAME','postgis_typmod_srid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_typmod_type(integer) RETURNS text AS 'MODULE_PATHNAME','postgis_typmod_type' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE VIEW geography_columns AS @@ -172,7 +172,7 @@ CREATE OR REPLACE VIEW geography_columns AS CREATE OR REPLACE FUNCTION geography(geometry) RETURNS geography AS 'MODULE_PATHNAME','geography_from_geometry' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE CAST (geometry AS geography) WITH FUNCTION geography(geometry) AS IMPLICIT; @@ -181,7 +181,7 @@ CREATE CAST (geometry AS geography) WITH FUNCTION geography(geometry) AS IMPLICI CREATE OR REPLACE FUNCTION geometry(geography) RETURNS geometry AS 'MODULE_PATHNAME','geometry_from_geography' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE CAST (geography AS geometry) WITH FUNCTION geometry(geography) ; @@ -194,61 +194,61 @@ CREATE CAST (geography AS geometry) WITH FUNCTION geometry(geography) ; CREATE OR REPLACE FUNCTION geography_gist_consistent(internal,geography,int4) RETURNS bool AS 'MODULE_PATHNAME' ,'gserialized_gist_consistent' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_compress(internal) RETURNS internal AS 'MODULE_PATHNAME','gserialized_gist_compress' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_penalty(internal,internal,internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_penalty' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_picksplit(internal, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_picksplit' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_union(bytea, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_union' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_same(box2d, box2d, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_same' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_decompress(internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_decompress' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_selectivity (internal, oid, internal, int4) RETURNS float8 AS 'MODULE_PATHNAME', 'geography_gist_selectivity' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gist_join_selectivity(internal, oid, internal, smallint) RETURNS float8 AS 'MODULE_PATHNAME', 'geography_gist_selectivity' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_overlaps(geography, geography) RETURNS boolean AS 'MODULE_PATHNAME' ,'gserialized_overlaps' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OPERATOR && ( @@ -285,32 +285,32 @@ CREATE OPERATOR CLASS gist_geography_ops CREATE OR REPLACE FUNCTION geography_lt(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_lt' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geography_le(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_le' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geography_gt(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_gt' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geography_ge(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_ge' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geography_eq(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_eq' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geography_cmp(geography, geography) RETURNS integer AS 'MODULE_PATHNAME', 'geography_cmp' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- -- Sorting operators for Btree @@ -370,13 +370,13 @@ CREATE OPERATOR CLASS btree_geography_ops CREATE OR REPLACE FUNCTION ST_AsSVG(geog geography,rel int4 DEFAULT 0,maxdecimaldigits int4 DEFAULT 15) RETURNS text AS 'MODULE_PATHNAME','geography_as_svg' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_AsSVG(text) RETURNS text AS $$ SELECT ST_AsSVG($1::geometry,0,15); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- -- GML OUTPUT @@ -386,14 +386,14 @@ CREATE OR REPLACE FUNCTION ST_AsSVG(text) CREATE OR REPLACE FUNCTION _ST_AsGML(int4, geography, int4, int4, text) RETURNS text AS 'MODULE_PATHNAME','geography_as_gml' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography -- Change 2.0.0 to use base function CREATE OR REPLACE FUNCTION ST_AsGML(text) RETURNS text AS $$ SELECT _ST_AsGML(2,$1::geometry,15,0, NULL); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsGML (geography, precision, option) / version=2 -- Availability: 1.5.0 @@ -401,14 +401,14 @@ CREATE OR REPLACE FUNCTION ST_AsGML(text) CREATE OR REPLACE FUNCTION ST_AsGML(geog geography, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0) RETURNS text AS 'SELECT _ST_AsGML(2, $1, $2, $3, null)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsGML(version, geography, precision, option, prefix) -- Changed: 2.0.0 to use default args and allow named args CREATE OR REPLACE FUNCTION ST_AsGML(version int4, geog geography, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0, nprefix text DEFAULT NULL) RETURNS text AS $$ SELECT _ST_AsGML($1, $2, $3, $4, $5);$$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- -- KML OUTPUT @@ -418,21 +418,21 @@ CREATE OR REPLACE FUNCTION ST_AsGML(version int4, geog geography, maxdecimaldigi CREATE OR REPLACE FUNCTION _ST_AsKML(int4, geography, int4, text) RETURNS text AS 'MODULE_PATHNAME','geography_as_kml' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- AsKML(geography,precision) / version=2 -- Changed: 2.0.0 to use default args and named args CREATE OR REPLACE FUNCTION ST_AsKML(geog geography, maxdecimaldigits int4 DEFAULT 15) RETURNS text AS 'SELECT _ST_AsKML(2, $1, $2, null)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography -- Deprecated 2.0.0 CREATE OR REPLACE FUNCTION ST_AsKML(text) RETURNS text AS $$ SELECT _ST_AsKML(2, $1::geometry, 15, null); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsKML(version, geography, precision, prefix) -- Availability: 2.0.0 nprefix added @@ -440,7 +440,7 @@ CREATE OR REPLACE FUNCTION ST_AsKML(text) CREATE OR REPLACE FUNCTION ST_AsKML(version int4, geog geography, maxdecimaldigits int4 DEFAULT 15, nprefix text DEFAULT null) RETURNS text AS 'SELECT _ST_AsKML($1, $2, $3, $4)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- -- GeoJson Output @@ -449,28 +449,28 @@ CREATE OR REPLACE FUNCTION ST_AsKML(version int4, geog geography, maxdecimaldigi CREATE OR REPLACE FUNCTION _ST_AsGeoJson(int4, geography, int4, int4) RETURNS text AS 'MODULE_PATHNAME','geography_as_geojson' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography -- Deprecated in 2.0.0 CREATE OR REPLACE FUNCTION ST_AsGeoJson(text) RETURNS text AS $$ SELECT _ST_AsGeoJson(1, $1::geometry,15,0); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsGeoJson(geography, precision, options) / version=1 -- Changed: 2.0.0 to use default args and named args CREATE OR REPLACE FUNCTION ST_AsGeoJson(geog geography, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0) RETURNS text AS $$ SELECT _ST_AsGeoJson(1, $1, $2, $3); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsGeoJson(version, geography, precision,options) -- Changed: 2.0.0 to use default args and named args CREATE OR REPLACE FUNCTION ST_AsGeoJson(gj_version int4, geog geography, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0) RETURNS text AS $$ SELECT _ST_AsGeoJson($1, $2, $3, $4); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -- Measurement Functions @@ -482,7 +482,7 @@ CREATE OR REPLACE FUNCTION ST_AsGeoJson(gj_version int4, geog geography, maxdeci CREATE OR REPLACE FUNCTION _ST_Distance(geography, geography, float8, boolean) RETURNS float8 AS 'MODULE_PATHNAME','geography_distance' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Stop calculation and return immediately once distance is less than tolerance @@ -490,113 +490,113 @@ CREATE OR REPLACE FUNCTION _ST_Distance(geography, geography, float8, boolean) CREATE OR REPLACE FUNCTION _ST_DWithin(geography, geography, float8, boolean) RETURNS boolean AS 'MODULE_PATHNAME','geography_dwithin' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Distance(geography, geography, boolean) RETURNS float8 AS 'SELECT _ST_Distance($1, $2, 0.0, $3)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Currently defaulting to spheroid calculations -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Distance(geography, geography) RETURNS float8 AS 'SELECT _ST_Distance($1, $2, 0.0, true)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_Distance(text, text) RETURNS float8 AS $$ SELECT ST_Distance($1::geometry, $2::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Only expands the bounding box, the actual geometry will remain unchanged, use with care. -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION _ST_Expand(geography, float8) RETURNS geography AS 'MODULE_PATHNAME','geography_expand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_DWithin(geography, geography, float8, boolean) RETURNS boolean AS 'SELECT $1 && _ST_Expand($2,$3) AND $2 && _ST_Expand($1,$3) AND _ST_DWithin($1, $2, $3, $4)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Currently defaulting to spheroid calculations -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_DWithin(geography, geography, float8) RETURNS boolean AS 'SELECT $1 && _ST_Expand($2,$3) AND $2 && _ST_Expand($1,$3) AND _ST_DWithin($1, $2, $3, true)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_DWithin(text, text, float8) RETURNS boolean AS $$ SELECT ST_DWithin($1::geometry, $2::geometry, $3); $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Area(geog geography, use_spheroid boolean DEFAULT true) RETURNS float8 AS 'MODULE_PATHNAME','geography_area' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_Area(text) RETURNS float8 AS $$ SELECT ST_Area($1::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Length(geog geography, use_spheroid boolean DEFAULT true) RETURNS float8 AS 'MODULE_PATHNAME','geography_length' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_Length(text) RETURNS float8 AS $$ SELECT ST_Length($1::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_Project(geog geography, distance float8, azimuth float8) RETURNS geography AS 'MODULE_PATHNAME','geography_project' - LANGUAGE 'C' IMMUTABLE + LANGUAGE 'c' IMMUTABLE COST 100; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_Azimuth(geog1 geography, geog2 geography) RETURNS float8 AS 'MODULE_PATHNAME','geography_azimuth' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_Perimeter(geog geography, use_spheroid boolean DEFAULT true) RETURNS float8 AS 'MODULE_PATHNAME','geography_perimeter' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION _ST_PointOutside(geography) RETURNS geography AS 'MODULE_PATHNAME','geography_point_outside' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Only implemented for polygon-over-point -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION _ST_Covers(geography, geography) RETURNS boolean AS 'MODULE_PATHNAME','geography_covers' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Only implemented for polygon-over-point @@ -604,110 +604,110 @@ CREATE OR REPLACE FUNCTION _ST_Covers(geography, geography) CREATE OR REPLACE FUNCTION ST_Covers(geography, geography) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Covers($1, $2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_Covers(text, text) RETURNS boolean AS $$ SELECT ST_Covers($1::geometry, $2::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE ; + LANGUAGE 'sql' IMMUTABLE ; -- Only implemented for polygon-over-point -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_CoveredBy(geography, geography) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Covers($2, $1)' - LANGUAGE 'SQL' IMMUTABLE ; + LANGUAGE 'sql' IMMUTABLE ; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_CoveredBy(text, text) RETURNS boolean AS $$ SELECT ST_CoveredBy($1::geometry, $2::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE ; + LANGUAGE 'sql' IMMUTABLE ; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Intersects(geography, geography) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Distance($1, $2, 0.0, false) < 0.00001' - LANGUAGE 'SQL' IMMUTABLE ; + LANGUAGE 'sql' IMMUTABLE ; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_Intersects(text, text) RETURNS boolean AS $$ SELECT ST_Intersects($1::geometry, $2::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE ; + LANGUAGE 'sql' IMMUTABLE ; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION _ST_BestSRID(geography, geography) RETURNS integer AS 'MODULE_PATHNAME','geography_bestsrid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION _ST_BestSRID(geography) RETURNS integer AS 'SELECT _ST_BestSRID($1,$1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Buffer(geography, float8) RETURNS geography AS 'SELECT geography(ST_Transform(ST_Buffer(ST_Transform(geometry($1), _ST_BestSRID($1)), $2), 4326))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_Buffer(text, float8) RETURNS geometry AS $$ SELECT ST_Buffer($1::geometry, $2); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Intersection(geography, geography) RETURNS geography AS 'SELECT geography(ST_Transform(ST_Intersection(ST_Transform(geometry($1), _ST_BestSRID($1, $2)), ST_Transform(geometry($2), _ST_BestSRID($1, $2))), 4326))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_Intersection(text, text) RETURNS geometry AS $$ SELECT ST_Intersection($1::geometry, $2::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_AsBinary(geography) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_asBinary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_AsBinary(geography,text) RETURNS bytea AS $$ SELECT ST_AsBinary($1::geometry, $2); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_AsEWKT(geography) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asEWKT' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography CREATE OR REPLACE FUNCTION ST_AsEWKT(text) RETURNS text AS $$ SELECT ST_AsEWKT($1::geometry); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + 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; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_Summary(geography) RETURNS text AS 'MODULE_PATHNAME', 'LWGEOM_summary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------------- diff --git a/postgis/geometry_estimate.c b/postgis/geometry_estimate.c index e363430fd..44dafea31 100644 --- a/postgis/geometry_estimate.c +++ b/postgis/geometry_estimate.c @@ -21,6 +21,7 @@ #include "utils/array.h" #include "utils/lsyscache.h" #include "utils/syscache.h" +#include "utils/rel.h" #include "../postgis_config.h" #include "liblwgeom.h" diff --git a/postgis/legacy.sql.in.c b/postgis/legacy.sql.in.c index cb099747e..30c5b11bf 100644 --- a/postgis/legacy.sql.in.c +++ b/postgis/legacy.sql.in.c @@ -9,54 +9,54 @@ CREATE OR REPLACE FUNCTION addbbox(geometry) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_addBBOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION dropbbox(geometry) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_dropBBOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION hasbbox(geometry) RETURNS bool AS 'MODULE_PATHNAME', 'LWGEOM_hasBBOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 -- never deprecated but don't think anyone uses it CREATE OR REPLACE FUNCTION getsrid(geometry) RETURNS int4 AS 'MODULE_PATHNAME','LWGEOM_get_srid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeometryFromText(text, int4) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeometryFromText(text) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomFromWKB(bytea) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_WKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomFromWKB(bytea, int) RETURNS geometry AS 'SELECT ST_SetSRID(ST_GeomFromWKB($1), $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION noop(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_noop' - LANGUAGE 'C' VOLATILE STRICT; + LANGUAGE 'c' VOLATILE STRICT; -- ESRI ArcSDE compatibility functions -- -- We are remiving these because we don't @@ -69,36 +69,36 @@ CREATE OR REPLACE FUNCTION SE_EnvelopesIntersect(geometry,geometry) AS $$ SELECT $1 && $2 $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION SE_Is3D(geometry) RETURNS bool AS 'MODULE_PATHNAME', 'LWGEOM_hasz' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION SE_IsMeasured(geometry) RETURNS bool AS 'MODULE_PATHNAME', 'LWGEOM_hasm' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: Z(geometry) CREATE OR REPLACE FUNCTION SE_Z(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_z_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: M(geometry) CREATE OR REPLACE FUNCTION SE_M(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_m_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: locate_between_measures(geometry, float8, float8) CREATE OR REPLACE FUNCTION SE_LocateBetween(geometry, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_locate_between_m' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: locate_along_measure(geometry, float8) CREATE OR REPLACE FUNCTION SE_LocateAlong(geometry, float8) @@ -111,85 +111,85 @@ CREATE OR REPLACE FUNCTION SE_LocateAlong(geometry, float8) CREATE OR REPLACE FUNCTION st_box2d(geometry) RETURNS box2d AS 'MODULE_PATHNAME','LWGEOM_to_BOX2D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_box3d(geometry) RETURNS box3d AS 'MODULE_PATHNAME','LWGEOM_to_BOX3D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_box(geometry) RETURNS box AS 'MODULE_PATHNAME','LWGEOM_to_BOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_box2d(box3d) RETURNS box2d AS 'MODULE_PATHNAME','BOX3D_to_BOX2D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_box3d(box2d) RETURNS box3d AS 'MODULE_PATHNAME','BOX2D_to_BOX3D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_box(box3d) RETURNS box AS 'MODULE_PATHNAME','BOX3D_to_BOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_text(geometry) RETURNS text AS 'MODULE_PATHNAME','LWGEOM_to_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry(box2d) RETURNS geometry AS 'MODULE_PATHNAME','BOX2D_to_LWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry(box3d) RETURNS geometry AS 'MODULE_PATHNAME','BOX3D_to_LWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry(text) RETURNS geometry AS 'MODULE_PATHNAME','parse_WKT_lwgeom' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry(bytea) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_bytea' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_bytea(geometry) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_to_bytea' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_box3d_in(cstring) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_box3d_out(box3d) RETURNS cstring AS 'MODULE_PATHNAME', 'BOX3D_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- START MANAGEMENT FUNCTIONS -- These are legacy management functions with no place in our 2.0 world @@ -207,7 +207,7 @@ AS $$ SELECT 'rename_geometry_table_constraint() is obsoleted'::text $$ -LANGUAGE 'SQL' IMMUTABLE; +LANGUAGE 'sql' IMMUTABLE; ----------------------------------------------------------------------- -- FIX_GEOMETRY_COLUMNS() @@ -392,80 +392,80 @@ LANGUAGE 'plpgsql' VOLATILE; /** CREATE OR REPLACE FUNCTION st_geometry_analyze(internal) RETURNS bool AS 'MODULE_PATHNAME', 'geometry_analyze' - LANGUAGE 'C' VOLATILE STRICT; + LANGUAGE 'c' VOLATILE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_in(cstring) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_out(geometry) RETURNS cstring AS 'MODULE_PATHNAME','LWGEOM_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_recv(internal) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_recv' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_send(geometry) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_send' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_spheroid_in(cstring) RETURNS spheroid AS 'MODULE_PATHNAME','ellipsoid_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_spheroid_out(spheroid) RETURNS cstring AS 'MODULE_PATHNAME','ellipsoid_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; **/ -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_lt(geometry, geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_lt' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_le(geometry, geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_le' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_gt(geometry, geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_gt' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_ge(geometry, geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_ge' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_eq(geometry, geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_eq' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION st_geometry_cmp(geometry, geometry) RETURNS integer AS 'MODULE_PATHNAME', 'lwgeom_cmp' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- end functions that in theory should never have been used @@ -478,68 +478,68 @@ CREATE OR REPLACE FUNCTION st_geometry_cmp(geometry, geometry) CREATE OR REPLACE FUNCTION Affine(geometry,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_affine' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.1.2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Affine(geometry,float8,float8,float8,float8,float8,float8) RETURNS geometry AS 'SELECT st_affine($1, $2, $3, 0, $4, $5, 0, 0, 0, 1, $6, $7, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.1.2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION RotateZ(geometry,float8) RETURNS geometry AS 'SELECT st_affine($1, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0, 1, 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.1.2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Rotate(geometry,float8) RETURNS geometry AS 'SELECT st_rotateZ($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.1.2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION RotateX(geometry,float8) RETURNS geometry AS 'SELECT st_affine($1, 1, 0, 0, 0, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.1.2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION RotateY(geometry,float8) RETURNS geometry AS 'SELECT st_affine($1, cos($2), 0, sin($2), 0, 1, 0, -sin($2), 0, cos($2), 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.1.0 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Scale(geometry,float8,float8,float8) RETURNS geometry AS 'SELECT st_affine($1, $2, 0, 0, 0, $3, 0, 0, 0, $4, 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.1.0 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Scale(geometry,float8,float8) RETURNS geometry AS 'SELECT st_scale($1, $2, $3, 1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Translate(geometry,float8,float8,float8) RETURNS geometry AS 'SELECT st_affine($1, 1, 0, 0, 0, 1, 0, 0, 0, 1, $2, $3, $4)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Translate(geometry,float8,float8) RETURNS geometry AS 'SELECT st_translate($1, $2, $3, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.1.0 @@ -548,7 +548,7 @@ CREATE OR REPLACE FUNCTION TransScale(geometry,float8,float8,float8,float8) RETURNS geometry AS 'SELECT st_affine($1, $4, 0, 0, 0, $5, 0, 0, 0, 1, $2 * $4, $3 * $5, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- END Affine functions @@ -556,19 +556,19 @@ CREATE OR REPLACE FUNCTION TransScale(geometry,float8,float8,float8,float8) CREATE OR REPLACE FUNCTION AddPoint(geometry, geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_addpoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AddPoint(geometry, geometry, integer) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_addpoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Area(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_area_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- this is an alias for 'area(geometry)' -- there is nothing such an 'area3d'... @@ -576,96 +576,96 @@ CREATE OR REPLACE FUNCTION Area(geometry) CREATE OR REPLACE FUNCTION Area2D(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_area_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsEWKB(geometry) RETURNS BYTEA AS 'MODULE_PATHNAME','WKBFromLWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsEWKB(geometry,text) RETURNS bytea AS 'MODULE_PATHNAME','WKBFromLWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsEWKT(geometry) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asEWKT' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- AsGML(geom) / precision=15 version=2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsGML(geometry) RETURNS TEXT AS 'SELECT _ST_AsGML(2, $1, 15, 0, null)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsGML(geometry, int4) RETURNS TEXT AS 'SELECT _ST_AsGML(2, $1, $2, 0, null)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- AsKML(geom, precision) / version=2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsKML(geometry, int4) RETURNS TEXT AS 'SELECT _ST_AsKML(2, ST_transform($1,4326), $2, null)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- AsKML(geom) / precision=15 version=2 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsKML(geometry) RETURNS TEXT AS 'SELECT _ST_AsKML(2, ST_Transform($1,4326), 15, null)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- AsKML(version, geom, precision) -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsKML(int4, geometry, int4) RETURNS TEXT AS 'SELECT _ST_AsKML($1, ST_Transform($2,4326), $3, null)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsHEXEWKB(geometry) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asHEXEWKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsHEXEWKB(geometry, text) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asHEXEWKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsSVG(geometry) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asSVG' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsSVG(geometry,int4) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asSVG' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION AsSVG(geometry,int4,int4) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asSVG' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION azimuth(geometry,geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_azimuth' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION BdPolyFromText(text, integer) @@ -724,127 +724,127 @@ LANGUAGE 'plpgsql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION boundary(geometry) RETURNS geometry AS 'MODULE_PATHNAME','boundary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION buffer(geometry,float8,integer) RETURNS geometry AS 'SELECT ST_Buffer($1, $2, $3)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION buffer(geometry,float8) RETURNS geometry AS 'MODULE_PATHNAME','buffer' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION BuildArea(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_BuildArea' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- This is also available w/out GEOS CREATE OR REPLACE FUNCTION Centroid(geometry) RETURNS geometry AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Contains(geometry,geometry) RETURNS boolean AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION convexhull(geometry) RETURNS geometry AS 'MODULE_PATHNAME','convexhull' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION crosses(geometry,geometry) RETURNS boolean AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION distance(geometry,geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_mindistance2d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION difference(geometry,geometry) RETURNS geometry AS 'MODULE_PATHNAME','difference' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Dimension(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_dimension' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION disjoint(geometry,geometry) RETURNS boolean AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION distance_sphere(geometry,geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_distance_sphere' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION distance_spheroid(geometry,geometry,spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_distance_ellipsoid' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Dump(geometry) RETURNS SETOF geometry_dump AS 'MODULE_PATHNAME', 'LWGEOM_dump' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION DumpRings(geometry) RETURNS SETOF geometry_dump AS 'MODULE_PATHNAME', 'LWGEOM_dump_rings' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Envelope(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_envelope' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Expand(box2d,float8) RETURNS box2d AS 'MODULE_PATHNAME', 'BOX2D_expand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Expand(box3d,float8) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_expand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Expand(geometry,float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_expand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE AGGREGATE Extent( sfunc = ST_combine_bbox, @@ -890,57 +890,57 @@ LANGUAGE 'plpgsql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION EndPoint(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_endpoint_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION ExteriorRing(geometry) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_exteriorring_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Force_2d(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- an alias for force_3dz -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Force_3d(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_3dz' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Force_3dm(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_3dm' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Force_3dz(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_3dz' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Force_4d(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_4d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Force_Collection(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_collection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION ForceRHR(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_clockwise_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomCollFromText(text, int4) @@ -951,7 +951,7 @@ CREATE OR REPLACE FUNCTION GeomCollFromText(text, int4) THEN GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomCollFromText(text) @@ -962,7 +962,7 @@ CREATE OR REPLACE FUNCTION GeomCollFromText(text) THEN GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomCollFromWKB(bytea, int) @@ -973,7 +973,7 @@ CREATE OR REPLACE FUNCTION GeomCollFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomCollFromWKB(bytea) @@ -984,69 +984,69 @@ CREATE OR REPLACE FUNCTION GeomCollFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeometryN(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_geometryn_collection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomUnion(geometry,geometry) RETURNS geometry AS 'MODULE_PATHNAME','geomunion' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 -- replaced with postgis_getbbox CREATE OR REPLACE FUNCTION getbbox(geometry) RETURNS box2d AS 'MODULE_PATHNAME','LWGEOM_to_BOX2D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION intersects(geometry,geometry) RETURNS boolean AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION IsRing(geometry) RETURNS boolean AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION IsSimple(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'issimple' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION length_spheroid(geometry, spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_length_ellipsoid_linestring' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION length2d_spheroid(geometry, spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_length2d_ellipsoid' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION length3d_spheroid(geometry, spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_length_ellipsoid_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineMerge(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'linemerge' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 @@ -1059,19 +1059,19 @@ CREATE OR REPLACE FUNCTION locate_along_measure(geometry, float8) CREATE OR REPLACE FUNCTION MakeBox2d(geometry, geometry) RETURNS box2d AS 'MODULE_PATHNAME', 'BOX2D_construct' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MakePolygon(geometry, geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MakePolygon(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPolyFromWKB(bytea) @@ -1081,13 +1081,13 @@ CREATE OR REPLACE FUNCTION MPolyFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION multi(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_multi' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPolyFromWKB(bytea, int) @@ -1097,7 +1097,7 @@ CREATE OR REPLACE FUNCTION MultiPolyFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPolyFromWKB(bytea) @@ -1107,37 +1107,37 @@ CREATE OR REPLACE FUNCTION MultiPolyFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION InteriorRingN(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_interiorringn_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION intersection(geometry,geometry) RETURNS geometry AS 'MODULE_PATHNAME','intersection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION IsClosed(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_isclosed' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION IsEmpty(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_isempty' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION IsValid(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'isvalid' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- this is a fake (for back-compatibility) -- uses 3d if 3d is available, 2d otherwise @@ -1145,36 +1145,36 @@ CREATE OR REPLACE FUNCTION IsValid(geometry) CREATE OR REPLACE FUNCTION length3d(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_length_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION length2d(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_length2d_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION length(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_length_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION line_interpolate_point(geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_line_interpolate_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION line_locate_point(geometry, geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_line_locate_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION line_substring(geometry, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_line_substring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineFromText(text) @@ -1184,7 +1184,7 @@ CREATE OR REPLACE FUNCTION LineFromText(text) THEN GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineFromText(text, int4) @@ -1194,13 +1194,13 @@ CREATE OR REPLACE FUNCTION LineFromText(text, int4) THEN GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineFromMultiPoint(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_line_from_mpoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineFromWKB(bytea, int) @@ -1210,7 +1210,7 @@ CREATE OR REPLACE FUNCTION LineFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineFromWKB(bytea) @@ -1220,20 +1220,20 @@ CREATE OR REPLACE FUNCTION LineFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineStringFromText(text) RETURNS geometry AS 'SELECT LineFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LineStringFromText(text, int4) RETURNS geometry AS 'SELECT LineFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LinestringFromWKB(bytea, int) @@ -1243,7 +1243,7 @@ CREATE OR REPLACE FUNCTION LinestringFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION LinestringFromWKB(bytea) @@ -1253,31 +1253,31 @@ CREATE OR REPLACE FUNCTION LinestringFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION locate_between_measures(geometry, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_locate_between_m' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION M(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_m_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MakeBox3d(geometry, geometry) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_construct' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION makeline_garray (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makeline_garray' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE AGGREGATE makeline ( @@ -1291,43 +1291,43 @@ CREATE AGGREGATE makeline ( CREATE OR REPLACE FUNCTION MakeLine(geometry, geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makeline' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MakePoint(float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MakePoint(float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MakePoint(float8, float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MakePointM(float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint3dm' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- This should really be deprecated -- 2011-01-04 robe CREATE OR REPLACE FUNCTION max_distance(geometry,geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_maxdistance2d_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION mem_size(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_mem_size' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MLineFromText(text, int4) @@ -1338,7 +1338,7 @@ CREATE OR REPLACE FUNCTION MLineFromText(text, int4) THEN GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MLineFromText(text) @@ -1348,7 +1348,7 @@ CREATE OR REPLACE FUNCTION MLineFromText(text) THEN GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MLineFromWKB(bytea, int) @@ -1358,7 +1358,7 @@ CREATE OR REPLACE FUNCTION MLineFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MLineFromWKB(bytea) @@ -1368,7 +1368,7 @@ CREATE OR REPLACE FUNCTION MLineFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPointFromText(text, int4) @@ -1378,7 +1378,7 @@ CREATE OR REPLACE FUNCTION MPointFromText(text, int4) THEN GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPointFromText(text) @@ -1388,7 +1388,7 @@ CREATE OR REPLACE FUNCTION MPointFromText(text) THEN GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPointFromWKB(bytea, int) @@ -1398,7 +1398,7 @@ CREATE OR REPLACE FUNCTION MPointFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPointFromWKB(bytea) @@ -1408,7 +1408,7 @@ CREATE OR REPLACE FUNCTION MPointFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPolyFromText(text, int4) @@ -1418,7 +1418,7 @@ CREATE OR REPLACE FUNCTION MPolyFromText(text, int4) THEN GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPolyFromText(text) @@ -1428,7 +1428,7 @@ CREATE OR REPLACE FUNCTION MPolyFromText(text) THEN GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MPolyFromWKB(bytea, int) @@ -1438,7 +1438,7 @@ CREATE OR REPLACE FUNCTION MPolyFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiLineFromWKB(bytea, int) @@ -1448,7 +1448,7 @@ CREATE OR REPLACE FUNCTION MultiLineFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION MultiLineFromWKB(bytea, int) @@ -1458,7 +1458,7 @@ CREATE OR REPLACE FUNCTION MultiLineFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiLineFromWKB(bytea) @@ -1468,37 +1468,37 @@ CREATE OR REPLACE FUNCTION MultiLineFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiLineStringFromText(text) RETURNS geometry AS 'SELECT ST_MLineFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiLineStringFromText(text, int4) RETURNS geometry AS 'SELECT MLineFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPointFromText(text) RETURNS geometry AS 'SELECT MPointFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPointFromText(text) RETURNS geometry AS 'SELECT MPointFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPointFromText(text, int4) RETURNS geometry AS 'SELECT MPointFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPointFromWKB(bytea, int) @@ -1508,7 +1508,7 @@ CREATE OR REPLACE FUNCTION MultiPointFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPointFromWKB(bytea) @@ -1518,61 +1518,61 @@ CREATE OR REPLACE FUNCTION MultiPointFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPolygonFromText(text, int4) RETURNS geometry AS 'SELECT MPolyFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION MultiPolygonFromText(text) RETURNS geometry AS 'SELECT MPolyFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION NumInteriorRing(geometry) RETURNS integer AS 'MODULE_PATHNAME','LWGEOM_numinteriorrings_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION NumInteriorRings(geometry) RETURNS integer AS 'MODULE_PATHNAME','LWGEOM_numinteriorrings_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION npoints(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_npoints' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION nrings(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_nrings' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION NumGeometries(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_numgeometries_collection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION NumPoints(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_numpoints_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION overlaps(geometry,geometry) RETURNS boolean AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- this is a fake (for back-compatibility) -- uses 3d if 3d is available, 2d otherwise @@ -1580,19 +1580,19 @@ CREATE OR REPLACE FUNCTION overlaps(geometry,geometry) CREATE OR REPLACE FUNCTION perimeter3d(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_perimeter_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION perimeter2d(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_perimeter2d_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION point_inside_circle(geometry,float8,float8,float8) RETURNS bool AS 'MODULE_PATHNAME', 'LWGEOM_inside_circle_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PointFromText(text) @@ -1602,7 +1602,7 @@ CREATE OR REPLACE FUNCTION PointFromText(text) THEN GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PointFromText(text, int4) @@ -1612,7 +1612,7 @@ CREATE OR REPLACE FUNCTION PointFromText(text, int4) THEN GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PointFromWKB(bytea) @@ -1622,7 +1622,7 @@ CREATE OR REPLACE FUNCTION PointFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PointFromWKB(bytea, int) @@ -1632,20 +1632,20 @@ CREATE OR REPLACE FUNCTION PointFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PointN(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_pointn_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PointOnSurface(geometry) RETURNS geometry AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 @@ -1656,7 +1656,7 @@ CREATE OR REPLACE FUNCTION PolyFromText(text) THEN GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PolyFromText(text, int4) RETURNS geometry @@ -1665,7 +1665,7 @@ CREATE OR REPLACE FUNCTION PolyFromText(text, int4) THEN GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PolyFromWKB(bytea, int) @@ -1675,7 +1675,7 @@ CREATE OR REPLACE FUNCTION PolyFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PolyFromWKB(bytea) @@ -1685,19 +1685,19 @@ CREATE OR REPLACE FUNCTION PolyFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PolygonFromText(text, int4) RETURNS geometry AS 'SELECT PolyFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PolygonFromText(text) RETURNS geometry AS 'SELECT PolyFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PolygonFromWKB(bytea, int) @@ -1707,7 +1707,7 @@ CREATE OR REPLACE FUNCTION PolygonFromWKB(bytea, int) THEN GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION PolygonFromWKB(bytea) @@ -1717,197 +1717,197 @@ CREATE OR REPLACE FUNCTION PolygonFromWKB(bytea) THEN GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Polygonize_GArray (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'polygonize_garray' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION relate(geometry,geometry) RETURNS text AS 'MODULE_PATHNAME','relate_full' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION relate(geometry,geometry,text) RETURNS boolean AS 'MODULE_PATHNAME','relate_pattern' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION RemovePoint(geometry, integer) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_removepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION reverse(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_reverse' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Segmentize(geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_segmentize2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION SetPoint(geometry, integer, geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_setpoint_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.1.0 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION shift_longitude(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_longitude_shift' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Simplify(geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_simplify2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- SnapToGrid(input, size) # xsize=ysize=size, offsets=0 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION SnapToGrid(geometry, float8, float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_snaptogrid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION SnapToGrid(geometry, float8) RETURNS geometry AS 'SELECT ST_SnapToGrid($1, 0, 0, $2, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- SnapToGrid(input, point_offsets, xsize, ysize, zsize, msize) -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION SnapToGrid(geometry, geometry, float8, float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_snaptogrid_pointoff' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- SnapToGrid(input, xsize, ysize) # offsets=0 -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION SnapToGrid(geometry, float8, float8) RETURNS geometry AS 'SELECT ST_SnapToGrid($1, 0, 0, $2, $3)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 -- this should be deprecated (do not think anyone has ever used it) CREATE OR REPLACE FUNCTION ST_MakeLine_GArray (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makeline_garray' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION StartPoint(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_startpoint_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION symdifference(geometry,geometry) RETURNS geometry AS 'MODULE_PATHNAME','symdifference' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION symmetricdifference(geometry,geometry) RETURNS geometry AS 'MODULE_PATHNAME','symdifference' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION summary(geometry) RETURNS text AS 'MODULE_PATHNAME', 'LWGEOM_summary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION transform(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME','transform' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION touches(geometry,geometry) RETURNS boolean AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION within(geometry,geometry) RETURNS boolean AS 'SELECT ST_Within($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION X(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_x_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION xmax(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_xmax' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION xmin(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_xmin' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Y(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_y_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION ymax(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_ymax' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION ymin(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_ymin' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION Z(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_z_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION zmax(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_zmax' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION zmin(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_zmin' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION zmflag(geometry) RETURNS smallint AS 'MODULE_PATHNAME', 'LWGEOM_zmflag' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- end old ogc names that have been replaced with new SQL-MM names -- @@ -1923,38 +1923,38 @@ CREATE AGGREGATE accum ( CREATE OR REPLACE FUNCTION collect(geometry, geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_collect' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION combine_bbox(box2d,geometry) RETURNS box2d AS 'MODULE_PATHNAME', 'BOX2D_combine' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION combine_bbox(box3d,geometry) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_combine' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION ST_Polygonize_GArray (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'polygonize_garray' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Deprecation in 1.4.0 CREATE OR REPLACE FUNCTION ST_unite_garray (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME','pgis_union_geometry_array' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION unite_garray (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'pgis_union_geometry_array' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE AGGREGATE Extent3d( @@ -1986,26 +1986,26 @@ CREATE AGGREGATE MemGeomUnion ( CREATE OR REPLACE FUNCTION ST_Length3D(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_length_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Renamed in 2.0.0 to ST_3DLength_spheroid CREATE OR REPLACE FUNCTION ST_Length_spheroid3D(geometry, spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_length_ellipsoid_linestring' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Renamed in 2.0.0 to ST_3DPerimeter CREATE OR REPLACE FUNCTION ST_Perimeter3D(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_perimeter_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Renamed in 2.0.0 to ST_3DMakeBox CREATE OR REPLACE FUNCTION ST_MakeBox3D(geometry, geometry) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_construct' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Renamed in 2.0.0 to ST_3DExtent CREATE AGGREGATE ST_Extent3D( diff --git a/postgis/legacy_minimal.sql.in.c b/postgis/legacy_minimal.sql.in.c index 09c83d40e..b19ff65bd 100644 --- a/postgis/legacy_minimal.sql.in.c +++ b/postgis/legacy_minimal.sql.in.c @@ -9,55 +9,55 @@ CREATE OR REPLACE FUNCTION AsBinary(geometry) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_asBinary' - LANGUAGE 'C' IMMUTABLE STRICT; + 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; + 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; + 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; + 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; + 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; + 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; + 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; + 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; + 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; + LANGUAGE 'c' IMMUTABLE STRICT; diff --git a/postgis/long_xact.c b/postgis/long_xact.c index afaf042dd..0e0886c38 100644 --- a/postgis/long_xact.c +++ b/postgis/long_xact.c @@ -15,7 +15,7 @@ #include "executor/spi.h" /* this is what you need to work with SPI */ #include "commands/trigger.h" /* ... and triggers */ #include "utils/lsyscache.h" /* for get_namespace_name() */ - +#include "utils/rel.h" #include "../postgis_config.h" #include "lwgeom_pg.h" diff --git a/postgis/long_xact.sql.in.c b/postgis/long_xact.sql.in.c index 07ec0ca76..da8daa3e6 100644 --- a/postgis/long_xact.sql.in.c +++ b/postgis/long_xact.sql.in.c @@ -187,7 +187,7 @@ CREATE OR REPLACE FUNCTION CheckAuth(text, text) RETURNS INT AS $$ SELECT CheckAuth('', $1, $2) $$ - LANGUAGE 'SQL'; + LANGUAGE 'sql'; CREATE OR REPLACE FUNCTION CheckAuthTrigger() RETURNS trigger AS diff --git a/postgis/lwgeom_triggers.c b/postgis/lwgeom_triggers.c index 9f62afcb4..636e64833 100644 --- a/postgis/lwgeom_triggers.c +++ b/postgis/lwgeom_triggers.c @@ -16,6 +16,7 @@ #include "../postgis_config.h" #include "lwgeom_pg.h" +#include "utils/rel.h" Datum cache_bbox(PG_FUNCTION_ARGS); diff --git a/postgis/postgis.sql.in.c b/postgis/postgis.sql.in.c index cac35f6c5..3ed4543c2 100644 --- a/postgis/postgis.sql.in.c +++ b/postgis/postgis.sql.in.c @@ -33,12 +33,12 @@ BEGIN; CREATE OR REPLACE FUNCTION spheroid_in(cstring) RETURNS spheroid AS 'MODULE_PATHNAME','ellipsoid_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION spheroid_out(spheroid) RETURNS cstring AS 'MODULE_PATHNAME','ellipsoid_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE TYPE spheroid ( alignment = double, @@ -53,39 +53,39 @@ CREATE TYPE spheroid ( CREATE OR REPLACE FUNCTION geometry_in(cstring) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_out(geometry) RETURNS cstring AS 'MODULE_PATHNAME','LWGEOM_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_typmod_in(cstring[]) RETURNS integer AS 'MODULE_PATHNAME','geometry_typmod_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_typmod_out(integer) RETURNS cstring AS 'MODULE_PATHNAME','postgis_typmod_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_analyze(internal) RETURNS bool AS 'MODULE_PATHNAME', 'geometry_analyze_2d' - LANGUAGE 'C' VOLATILE STRICT; + LANGUAGE 'c' VOLATILE STRICT; CREATE OR REPLACE FUNCTION geometry_recv(internal) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_recv' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_send(geometry) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_send' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE TYPE geometry ( internallength = variable, @@ -107,7 +107,7 @@ CREATE TYPE geometry ( CREATE OR REPLACE FUNCTION geometry(geometry, integer, boolean) RETURNS geometry AS 'MODULE_PATHNAME','geometry_enforce_typmod' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE CAST (geometry AS geometry) WITH FUNCTION geometry(geometry, integer, boolean) AS IMPLICIT; @@ -121,25 +121,25 @@ CREATE CAST (geometry AS geometry) WITH FUNCTION geometry(geometry, integer, boo CREATE OR REPLACE FUNCTION ST_X(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_x_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: Y(geometry) CREATE OR REPLACE FUNCTION ST_Y(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_y_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Z(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_z_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_M(geometry) RETURNS float8 AS 'MODULE_PATHNAME','LWGEOM_m_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ------------------------------------------- ------------------------------------------------------------------- @@ -147,12 +147,12 @@ CREATE OR REPLACE FUNCTION ST_M(geometry) CREATE OR REPLACE FUNCTION box3d_in(cstring) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box3d_out(box3d) RETURNS cstring AS 'MODULE_PATHNAME', 'BOX3D_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE TYPE box3d ( alignment = double, @@ -168,12 +168,12 @@ CREATE TYPE box3d ( CREATE OR REPLACE FUNCTION box2d_in(cstring) RETURNS box2d AS 'MODULE_PATHNAME','BOX2D_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box2d_out(box2d) RETURNS cstring AS 'MODULE_PATHNAME','BOX2D_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE TYPE box2d ( internallength = 65, @@ -193,13 +193,13 @@ CREATE TYPE box2d ( CREATE OR REPLACE FUNCTION box2df_in(cstring) RETURNS box2df AS 'MODULE_PATHNAME','box2df_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION box2df_out(box2df) RETURNS cstring AS 'MODULE_PATHNAME','box2df_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE TYPE box2df ( @@ -223,13 +223,13 @@ CREATE TYPE box2df ( CREATE OR REPLACE FUNCTION gidx_in(cstring) RETURNS gidx AS 'MODULE_PATHNAME','gidx_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION gidx_out(gidx) RETURNS cstring AS 'MODULE_PATHNAME','gidx_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE TYPE gidx ( @@ -246,32 +246,32 @@ CREATE TYPE gidx ( CREATE OR REPLACE FUNCTION geometry_lt(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_lt' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_le(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_le' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_gt(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_gt' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_ge(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_ge' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_eq(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'lwgeom_eq' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_cmp(geom1 geometry, geom2 geometry) RETURNS integer AS 'MODULE_PATHNAME', 'lwgeom_cmp' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- -- Sorting operators for Btree @@ -329,61 +329,61 @@ CREATE OPERATOR CLASS btree_geometry_ops CREATE OR REPLACE FUNCTION geometry_gist_distance_2d(internal,geometry,int4) RETURNS float8 AS 'MODULE_PATHNAME' ,'gserialized_gist_distance_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_consistent_2d(internal,geometry,int4) RETURNS bool AS 'MODULE_PATHNAME' ,'gserialized_gist_consistent_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_compress_2d(internal) RETURNS internal AS 'MODULE_PATHNAME','gserialized_gist_compress_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_penalty_2d(internal,internal,internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_penalty_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_picksplit_2d(internal, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_picksplit_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_union_2d(bytea, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_union_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_same_2d(geom1 geometry, geom2 geometry, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_same_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_decompress_2d(internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_decompress_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_sel_2d (internal, oid, internal, int4) RETURNS float8 AS 'MODULE_PATHNAME', 'geometry_gist_sel_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_joinsel_2d(internal, oid, internal, smallint) RETURNS float8 AS 'MODULE_PATHNAME', 'geometry_gist_joinsel_2d' - LANGUAGE 'C'; + LANGUAGE 'c'; ----------------------------------------------------------------------------- -- GEOMETRY Operators @@ -397,7 +397,7 @@ CREATE OR REPLACE FUNCTION geometry_gist_joinsel_2d(internal, oid, internal, sma CREATE OR REPLACE FUNCTION geometry_overlaps(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME' ,'gserialized_overlaps_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR && ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overlaps, @@ -410,7 +410,7 @@ CREATE OPERATOR && ( CREATE OR REPLACE FUNCTION geometry_same(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME' ,'gserialized_same_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR ~= ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_same, @@ -421,13 +421,13 @@ CREATE OPERATOR ~= ( CREATE OR REPLACE FUNCTION geometry_distance_centroid(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME' ,'gserialized_distance_centroid_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_distance_box(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME' ,'gserialized_distance_box_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; #if POSTGIS_PGSQL_VERSION >= 91 CREATE OPERATOR <-> ( @@ -445,13 +445,13 @@ CREATE OPERATOR <#> ( CREATE OR REPLACE FUNCTION geometry_contains(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_contains_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_within(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_within_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR @ ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_within, @@ -469,7 +469,7 @@ CREATE OPERATOR ~ ( CREATE OR REPLACE FUNCTION geometry_left(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_left_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR << ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_left, @@ -481,7 +481,7 @@ CREATE OPERATOR << ( CREATE OR REPLACE FUNCTION geometry_overleft(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_overleft_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR &< ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overleft, @@ -493,7 +493,7 @@ CREATE OPERATOR &< ( CREATE OR REPLACE FUNCTION geometry_below(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_below_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR <<| ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_below, @@ -505,7 +505,7 @@ CREATE OPERATOR <<| ( CREATE OR REPLACE FUNCTION geometry_overbelow(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_overbelow_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR &<| ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overbelow, @@ -517,7 +517,7 @@ CREATE OPERATOR &<| ( CREATE OR REPLACE FUNCTION geometry_overright(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_overright_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR &> ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overright, @@ -529,7 +529,7 @@ CREATE OPERATOR &> ( CREATE OR REPLACE FUNCTION geometry_right(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_right_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR >> ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_right, @@ -541,7 +541,7 @@ CREATE OPERATOR >> ( CREATE OR REPLACE FUNCTION geometry_overabove(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_overabove_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR |&> ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_overabove, @@ -553,7 +553,7 @@ CREATE OPERATOR |&> ( CREATE OR REPLACE FUNCTION geometry_above(geom1 geometry, geom2 geometry) RETURNS bool AS 'MODULE_PATHNAME', 'gserialized_above_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OPERATOR |>> ( LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_above, @@ -603,55 +603,55 @@ CREATE OPERATOR CLASS gist_geometry_ops_2d CREATE OR REPLACE FUNCTION geometry_gist_consistent_nd(internal,geometry,int4) RETURNS bool AS 'MODULE_PATHNAME' ,'gserialized_gist_consistent' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_compress_nd(internal) RETURNS internal AS 'MODULE_PATHNAME','gserialized_gist_compress' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_penalty_nd(internal,internal,internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_penalty' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_picksplit_nd(internal, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_picksplit' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_union_nd(bytea, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_union' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_same_nd(geometry, geometry, internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_same' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION geometry_gist_decompress_nd(internal) RETURNS internal AS 'MODULE_PATHNAME' ,'gserialized_gist_decompress' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 2.0.0 --CREATE OR REPLACE FUNCTION geometry_gist_selectivity_nd (internal, oid, internal, int4) -- RETURNS float8 -- AS 'MODULE_PATHNAME', 'geometry_gist_selectivity_nd' --- LANGUAGE 'C'; +-- LANGUAGE 'c'; -- Availability: 2.0.0 --CREATE OR REPLACE FUNCTION geography_gist_join_selectivity_nd(internal, oid, internal, smallint) -- RETURNS float8 -- AS 'MODULE_PATHNAME', 'geometry_gist_join_selectivity_nd' --- LANGUAGE 'C'; +-- LANGUAGE 'c'; -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -- N-D GEOMETRY Operators @@ -661,7 +661,7 @@ CREATE OR REPLACE FUNCTION geometry_gist_decompress_nd(internal) CREATE OR REPLACE FUNCTION geometry_overlaps_nd(geometry, geometry) RETURNS boolean AS 'MODULE_PATHNAME' ,'gserialized_overlaps' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OPERATOR &&& ( @@ -697,25 +697,25 @@ CREATE OPERATOR CLASS gist_geometry_ops_nd CREATE OR REPLACE FUNCTION ST_Affine(geometry,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_affine' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Affine(geometry,float8,float8,float8,float8,float8,float8) RETURNS geometry AS 'SELECT ST_Affine($1, $2, $3, 0, $4, $5, 0, 0, 0, 1, $6, $7, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Rotate(geometry,float8) RETURNS geometry AS 'SELECT ST_Affine($1, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0, 1, 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_Rotate(geometry,float8,float8,float8) RETURNS geometry AS 'SELECT ST_Affine($1, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0, 1, $3 - cos($2) * $3 + sin($2) * $4, $4 - sin($2) * $3 - cos($2) * $4, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_Rotate(geometry,float8,geometry) @@ -727,56 +727,56 @@ CREATE OR REPLACE FUNCTION ST_Rotate(geometry,float8,geometry) CREATE OR REPLACE FUNCTION ST_RotateZ(geometry,float8) RETURNS geometry AS 'SELECT ST_Rotate($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_RotateX(geometry,float8) RETURNS geometry AS 'SELECT ST_Affine($1, 1, 0, 0, 0, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_RotateY(geometry,float8) RETURNS geometry AS 'SELECT ST_Affine($1, cos($2), 0, sin($2), 0, 1, 0, -sin($2), 0, cos($2), 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Translate(geometry,float8,float8,float8) RETURNS geometry AS 'SELECT ST_Affine($1, 1, 0, 0, 0, 1, 0, 0, 0, 1, $2, $3, $4)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Translate(geometry,float8,float8) RETURNS geometry AS 'SELECT ST_Translate($1, $2, $3, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Scale(geometry,float8,float8,float8) RETURNS geometry AS 'SELECT ST_Affine($1, $2, 0, 0, 0, $3, 0, 0, 0, $4, 0, 0, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Scale(geometry,float8,float8) RETURNS geometry AS 'SELECT ST_Scale($1, $2, $3, 1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Transscale(geometry,float8,float8,float8,float8) RETURNS geometry AS 'SELECT ST_Affine($1, $4, 0, 0, 0, $5, 0, 0, 0, 1, $2 * $4, $3 * $5, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Shift_Longitude(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_longitude_shift' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------------- -- BOX3D FUNCTIONS @@ -786,37 +786,37 @@ CREATE OR REPLACE FUNCTION ST_Shift_Longitude(geometry) CREATE OR REPLACE FUNCTION ST_XMin(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_xmin' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_YMin(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_ymin' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_ZMin(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_zmin' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_XMax(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_xmax' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_YMax(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_ymax' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_ZMax(box3d) RETURNS FLOAT8 AS 'MODULE_PATHNAME','BOX3D_zmax' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------------- -- BOX2D FUNCTIONS @@ -826,26 +826,26 @@ CREATE OR REPLACE FUNCTION ST_ZMax(box3d) CREATE OR REPLACE FUNCTION ST_expand(box2d,float8) RETURNS box2d AS 'MODULE_PATHNAME', 'BOX2D_expand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_getbbox(geometry) RETURNS box2d AS 'MODULE_PATHNAME','LWGEOM_to_BOX2D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MakeBox2d(geom1 geometry, geom2 geometry) RETURNS box2d AS 'MODULE_PATHNAME', 'BOX2D_construct' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Combine_BBox(box2d,geometry) RETURNS box2d AS 'MODULE_PATHNAME', 'BOX2D_combine' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; ----------------------------------------------------------------------- -- ESTIMATED_EXTENT( , , ) @@ -853,7 +853,7 @@ CREATE OR REPLACE FUNCTION ST_Combine_BBox(box2d,geometry) -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_estimated_extent(text,text,text) RETURNS box2d AS 'MODULE_PATHNAME', 'geometry_estimated_extent' - LANGUAGE 'C' IMMUTABLE STRICT SECURITY DEFINER; + LANGUAGE 'c' IMMUTABLE STRICT SECURITY DEFINER; ----------------------------------------------------------------------- -- ESTIMATED_EXTENT(
, ) @@ -861,7 +861,7 @@ CREATE OR REPLACE FUNCTION ST_estimated_extent(text,text,text) RETURNS box2d AS -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_estimated_extent(text,text) RETURNS box2d AS 'MODULE_PATHNAME', 'geometry_estimated_extent' - LANGUAGE 'C' IMMUTABLE STRICT SECURITY DEFINER; + LANGUAGE 'c' IMMUTABLE STRICT SECURITY DEFINER; ----------------------------------------------------------------------- -- FIND_EXTENT( ,
, ) @@ -911,19 +911,19 @@ LANGUAGE 'plpgsql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION postgis_addbbox(geometry) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_addBBOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_dropbbox(geometry) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_dropBBOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_hasbbox(geometry) RETURNS bool AS 'MODULE_PATHNAME', 'LWGEOM_hasBBOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ------------------------------------------------------------------------ @@ -933,25 +933,25 @@ CREATE OR REPLACE FUNCTION postgis_hasbbox(geometry) CREATE OR REPLACE FUNCTION ST_mem_size(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_mem_size' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_summary(geometry) RETURNS text AS 'MODULE_PATHNAME', 'LWGEOM_summary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Npoints(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_npoints' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_nrings(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_nrings' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ------------------------------------------------------------------------ -- Measures @@ -960,19 +960,19 @@ CREATE OR REPLACE FUNCTION ST_nrings(geometry) CREATE OR REPLACE FUNCTION ST_3DLength(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_length_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Length2d(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_length2d_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: length2d(geometry) CREATE OR REPLACE FUNCTION ST_Length(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_length2d_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- this is a fake (for back-compatibility) -- uses 3d if 3d is available, 2d otherwise @@ -980,59 +980,59 @@ CREATE OR REPLACE FUNCTION ST_Length(geometry) CREATE OR REPLACE FUNCTION ST_3DLength_spheroid(geometry, spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_length_ellipsoid_linestring' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_length_spheroid(geometry, spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_length_ellipsoid_linestring' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_length2d_spheroid(geometry, spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_length2d_ellipsoid' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_3DPerimeter(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_perimeter_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_perimeter2d(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_perimeter2d_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: perimeter2d(geometry) CREATE OR REPLACE FUNCTION ST_Perimeter(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_perimeter2d_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 -- Deprecation in 1.3.4 CREATE OR REPLACE FUNCTION ST_area2d(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'LWGEOM_area_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: area(geometry) CREATE OR REPLACE FUNCTION ST_Area(geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_area_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_distance_spheroid(geom1 geometry, geom2 geometry,spheroid) RETURNS FLOAT8 AS 'MODULE_PATHNAME','LWGEOM_distance_ellipsoid' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Minimum distance. 2d only. @@ -1041,20 +1041,20 @@ CREATE OR REPLACE FUNCTION ST_distance_spheroid(geom1 geometry, geom2 geometry,s CREATE OR REPLACE FUNCTION ST_Distance(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_mindistance2d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_point_inside_circle(geometry,float8,float8,float8) RETURNS bool AS 'MODULE_PATHNAME', 'LWGEOM_inside_circle_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_azimuth(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_azimuth' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ------------------------------------------------------------------------ -- MISC @@ -1063,176 +1063,176 @@ CREATE OR REPLACE FUNCTION ST_azimuth(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_force_2d(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_force_3dz(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_3dz' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_force_3d(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_3dz' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_force_3dm(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_3dm' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_force_4d(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_4d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_force_collection(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_collection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_CollectionExtract(geometry, integer) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_CollectionExtract' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_CollectionHomogenize(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_CollectionHomogenize' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Multi(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_multi' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Expand(box3d,float8) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_expand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Expand(geometry,float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_expand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: envelope(geometry) CREATE OR REPLACE FUNCTION ST_Envelope(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_envelope' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Reverse(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_reverse' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_ForceRHR(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_force_clockwise_poly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_noop(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_noop' - LANGUAGE 'C' VOLATILE STRICT; + LANGUAGE 'c' VOLATILE STRICT; -- Deprecation in 1.5.0 CREATE OR REPLACE FUNCTION ST_zmflag(geometry) RETURNS smallint AS 'MODULE_PATHNAME', 'LWGEOM_zmflag' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_NDims(geometry) RETURNS smallint AS 'MODULE_PATHNAME', 'LWGEOM_ndims' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AsEWKT(geometry) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asEWKT' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AsEWKB(geometry) RETURNS BYTEA AS 'MODULE_PATHNAME','WKBFromLWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AsHEXEWKB(geometry) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asHEXEWKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AsHEXEWKB(geometry, text) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asHEXEWKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AsEWKB(geometry,text) RETURNS bytea AS 'MODULE_PATHNAME','WKBFromLWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_AsLatLonText(geometry, text) RETURNS text AS 'MODULE_PATHNAME','LWGEOM_to_latlon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_AsLatLonText(geometry) RETURNS text AS $$ SELECT ST_AsLatLonText($1, '') $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomFromEWKB(bytea) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOMFromWKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeomFromEWKB(bytea) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOMFromWKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION GeomFromEWKT(text) RETURNS geometry AS 'MODULE_PATHNAME','parse_WKT_lwgeom' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeomFromEWKT(text) RETURNS geometry AS 'MODULE_PATHNAME','parse_WKT_lwgeom' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION postgis_cache_bbox() RETURNS trigger AS 'MODULE_PATHNAME', 'cache_bbox' - LANGUAGE 'C'; + LANGUAGE 'c'; ------------------------------------------------------------------------ -- CONSTRUCTORS @@ -1242,112 +1242,112 @@ CREATE OR REPLACE FUNCTION postgis_cache_bbox() CREATE OR REPLACE FUNCTION ST_MakePoint(float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MakePoint(float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MakePoint(float8, float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.3.4 CREATE OR REPLACE FUNCTION ST_MakePointM(float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint3dm' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_3DMakeBox(geom1 geometry, geom2 geometry) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_construct' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION ST_MakeLine (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makeline_garray' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_LineFromMultiPoint(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_line_from_mpoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MakeLine(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makeline' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AddPoint(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_addpoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AddPoint(geom1 geometry, geom2 geometry, integer) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_addpoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_RemovePoint(geometry, integer) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_removepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_SetPoint(geometry, integer, geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_setpoint_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 -- Availability: 2.0.0 - made srid optional CREATE OR REPLACE FUNCTION ST_MakeEnvelope(float8, float8, float8, float8, integer DEFAULT 0) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_MakeEnvelope' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MakePolygon(geometry, geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MakePolygon(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoly' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_BuildArea(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_BuildArea' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION ST_Polygonize (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'polygonize_garray' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_LineMerge(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'linemerge' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; @@ -1360,13 +1360,13 @@ CREATE TYPE geometry_dump AS ( CREATE OR REPLACE FUNCTION ST_Dump(geometry) RETURNS SETOF geometry_dump AS 'MODULE_PATHNAME', 'LWGEOM_dump' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_DumpRings(geometry) RETURNS SETOF geometry_dump AS 'MODULE_PATHNAME', 'LWGEOM_dump_rings' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- _ST_DumpPoints() @@ -2286,13 +2286,13 @@ LANGUAGE 'plpgsql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION postgis_transform_geometry(geometry,text,text,int) RETURNS geometry AS 'MODULE_PATHNAME','transform_geom' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent of old function: transform(geometry,integer) CREATE OR REPLACE FUNCTION ST_Transform(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME','transform' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- @@ -2301,11 +2301,11 @@ CREATE OR REPLACE FUNCTION ST_Transform(geometry,integer) CREATE OR REPLACE FUNCTION postgis_version() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION postgis_proj_version() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- -- IMPORTANT: @@ -2319,25 +2319,25 @@ CREATE OR REPLACE FUNCTION postgis_scripts_installed() RETURNS text CREATE OR REPLACE FUNCTION postgis_lib_version() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; -- a new lib will require a new session + LANGUAGE 'c' IMMUTABLE; -- a new lib will require a new session -- NOTE: from 1.1.0 to 1.5.x this was the same of postgis_lib_version() -- NOTE: from 2.0.0 up it includes postgis_svn_revision() CREATE OR REPLACE FUNCTION postgis_scripts_released() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION postgis_geos_version() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION postgis_svn_version() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION postgis_libxml_version() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION postgis_scripts_build_date() RETURNS text AS _POSTGIS_SQL_SELECT_POSTGIS_BUILD_DATE @@ -2345,7 +2345,7 @@ CREATE OR REPLACE FUNCTION postgis_scripts_build_date() RETURNS text CREATE OR REPLACE FUNCTION postgis_lib_build_date() RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION postgis_full_version() RETURNS text AS $$ @@ -2468,69 +2468,69 @@ LANGUAGE 'plpgsql' IMMUTABLE; CREATE OR REPLACE FUNCTION box2d(geometry) RETURNS box2d AS 'MODULE_PATHNAME','LWGEOM_to_BOX2D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box3d(geometry) RETURNS box3d AS 'MODULE_PATHNAME','LWGEOM_to_BOX3D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box(geometry) RETURNS box AS 'MODULE_PATHNAME','LWGEOM_to_BOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box2d(box3d) RETURNS box2d AS 'MODULE_PATHNAME','BOX3D_to_BOX2D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box3d(box2d) RETURNS box3d AS 'MODULE_PATHNAME','BOX2D_to_BOX3D' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box(box3d) RETURNS box AS 'MODULE_PATHNAME','BOX3D_to_BOX' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION text(geometry) RETURNS text AS 'MODULE_PATHNAME','LWGEOM_to_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- this is kept for backward-compatibility -- Deprecation in 1.2.3 CREATE OR REPLACE FUNCTION box3dtobox(box3d) RETURNS box AS 'SELECT box($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry(box2d) RETURNS geometry AS 'MODULE_PATHNAME','BOX2D_to_LWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry(box3d) RETURNS geometry AS 'MODULE_PATHNAME','BOX3D_to_LWGEOM' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry(text) RETURNS geometry AS 'MODULE_PATHNAME','parse_WKT_lwgeom' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry(bytea) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_bytea' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION bytea(geometry) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_to_bytea' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- 7.3+ explicit casting definitions CREATE CAST (geometry AS box2d) WITH FUNCTION box2d(geometry) AS IMPLICIT; @@ -2555,41 +2555,41 @@ CREATE CAST (geometry AS bytea) WITH FUNCTION bytea(geometry) AS IMPLICIT; CREATE OR REPLACE FUNCTION ST_Simplify(geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_simplify2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- ST_SnapToGrid(input, xoff, yoff, xsize, ysize) -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_SnapToGrid(geometry, float8, float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_snaptogrid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- ST_SnapToGrid(input, xsize, ysize) # offsets=0 -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_SnapToGrid(geometry, float8, float8) RETURNS geometry AS 'SELECT ST_SnapToGrid($1, 0, 0, $2, $3)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_SnapToGrid(input, size) # xsize=ysize=size, offsets=0 -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_SnapToGrid(geometry, float8) RETURNS geometry AS 'SELECT ST_SnapToGrid($1, 0, 0, $2, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_SnapToGrid(input, point_offsets, xsize, ysize, zsize, msize) -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_SnapToGrid(geom1 geometry, geom2 geometry, float8, float8, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_snaptogrid_pointoff' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_Segmentize(geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_segmentize2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --------------------------------------------------------------- -- LRS @@ -2599,25 +2599,25 @@ CREATE OR REPLACE FUNCTION ST_Segmentize(geometry, float8) CREATE OR REPLACE FUNCTION ST_line_interpolate_point(geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_line_interpolate_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_line_substring(geometry, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_line_substring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_line_locate_point(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_line_locate_point' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_locate_between_measures(geometry, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_locate_between_m' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 @@ -2630,7 +2630,7 @@ CREATE OR REPLACE FUNCTION ST_locate_along_measure(geometry, float8) CREATE OR REPLACE FUNCTION ST_AddMeasure(geometry, float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_AddMeasure' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --------------------------------------------------------------- -- GEOS @@ -2640,21 +2640,21 @@ CREATE OR REPLACE FUNCTION ST_AddMeasure(geometry, float8, float8) CREATE OR REPLACE FUNCTION ST_Intersection(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME','intersection' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- PostGIS equivalent function: buffer(geometry,float8) CREATE OR REPLACE FUNCTION ST_Buffer(geometry,float8) RETURNS geometry AS 'MODULE_PATHNAME','buffer' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.5.0 - requires GEOS-3.2 or higher CREATE OR REPLACE FUNCTION _ST_Buffer(geometry,float8,cstring) RETURNS geometry AS 'MODULE_PATHNAME','buffer' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 @@ -2663,7 +2663,7 @@ CREATE OR REPLACE FUNCTION ST_Buffer(geometry,float8,integer) AS $$ SELECT _ST_Buffer($1, $2, CAST('quad_segs='||CAST($3 AS text) as cstring)) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_Buffer(geometry,float8,text) @@ -2673,20 +2673,20 @@ CREATE OR REPLACE FUNCTION ST_Buffer(geometry,float8,text) 'quad_segs='||$3) AS cstring) ) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 2.0.0 - requires GEOS-3.2 or higher CREATE OR REPLACE FUNCTION ST_OffsetCurve(line geometry, distance float8, params text DEFAULT '') RETURNS geometry AS 'MODULE_PATHNAME','ST_OffsetCurve' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- PostGIS equivalent function: convexhull(geometry) CREATE OR REPLACE FUNCTION ST_ConvexHull(geometry) RETURNS geometry AS 'MODULE_PATHNAME','convexhull' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Only accepts LINESTRING as parameters. @@ -2694,7 +2694,7 @@ CREATE OR REPLACE FUNCTION ST_ConvexHull(geometry) CREATE OR REPLACE FUNCTION _ST_LineCrossingDirection(geom1 geometry, geom2 geometry) RETURNS integer AS 'MODULE_PATHNAME', 'ST_LineCrossingDirection' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.4.0 @@ -2708,7 +2708,7 @@ CREATE OR REPLACE FUNCTION ST_LineCrossingDirection(geom1 geometry, geom2 geomet CREATE OR REPLACE FUNCTION ST_SimplifyPreserveTopology(geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME','topologypreservesimplify' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Requires GEOS >= 3.1.0 @@ -2716,7 +2716,7 @@ CREATE OR REPLACE FUNCTION ST_SimplifyPreserveTopology(geometry, float8) CREATE OR REPLACE FUNCTION ST_IsValidReason(geometry) RETURNS text AS 'MODULE_PATHNAME', 'isvalidreason' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 2.0.0 @@ -2731,7 +2731,7 @@ CREATE TYPE valid_detail AS ( CREATE OR REPLACE FUNCTION ST_IsValidDetail(geometry) RETURNS valid_detail AS 'MODULE_PATHNAME', 'isvaliddetail' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Requires GEOS >= 3.3.0 @@ -2739,7 +2739,7 @@ CREATE OR REPLACE FUNCTION ST_IsValidDetail(geometry) CREATE OR REPLACE FUNCTION ST_IsValidDetail(geometry, int4) RETURNS valid_detail AS 'MODULE_PATHNAME', 'isvaliddetail' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Requires GEOS >= 3.3.0 @@ -2768,7 +2768,7 @@ CREATE OR REPLACE FUNCTION ST_IsValid(geometry, int4) CREATE OR REPLACE FUNCTION ST_HausdorffDistance(geom1 geometry, geom2 geometry) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'hausdorffdistance' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Requires GEOS >= 3.2.0 @@ -2776,45 +2776,45 @@ CREATE OR REPLACE FUNCTION ST_HausdorffDistance(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_HausdorffDistance(geom1 geometry, geom2 geometry, float8) RETURNS FLOAT8 AS 'MODULE_PATHNAME', 'hausdorffdistancedensify' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- PostGIS equivalent function: difference(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Difference(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME','difference' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: boundary(geometry) CREATE OR REPLACE FUNCTION ST_Boundary(geometry) RETURNS geometry AS 'MODULE_PATHNAME','boundary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: symdifference(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_SymDifference(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME','symdifference' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_symmetricdifference(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME','symdifference' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: GeomUnion(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Union(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME','geomunion' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 -- Requires: GEOS-3.3.0 CREATE OR REPLACE FUNCTION ST_UnaryUnion(geometry) RETURNS geometry AS 'MODULE_PATHNAME','ST_UnaryUnion' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- ST_RemoveRepeatedPoints(in geometry) -- @@ -2826,7 +2826,7 @@ CREATE OR REPLACE FUNCTION ST_UnaryUnion(geometry) CREATE OR REPLACE FUNCTION ST_RemoveRepeatedPoints(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_RemoveRepeatedPoints' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -------------------------------------------------------------------------------- @@ -2845,7 +2845,7 @@ CREATE OR REPLACE FUNCTION ST_RemoveRepeatedPoints(geometry) CREATE OR REPLACE FUNCTION ST_MakeValid(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_MakeValid' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- ST_CleanGeometry(in geometry) @@ -2866,7 +2866,7 @@ CREATE OR REPLACE FUNCTION ST_MakeValid(geometry) CREATE OR REPLACE FUNCTION ST_CleanGeometry(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_CleanGeometry' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -------------------------------------------------------------------------------- @@ -2886,7 +2886,7 @@ CREATE OR REPLACE FUNCTION ST_CleanGeometry(geometry) CREATE OR REPLACE FUNCTION ST_Split(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_Split' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -------------------------------------------------------------------------------- @@ -2909,7 +2909,7 @@ CREATE OR REPLACE FUNCTION ST_Split(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_SharedPaths(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_SharedPaths' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -------------------------------------------------------------------------------- @@ -2926,7 +2926,7 @@ CREATE OR REPLACE FUNCTION ST_SharedPaths(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Snap(geom1 geometry, geom2 geometry, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_Snap' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -------------------------------------------------------------------------------- @@ -2943,7 +2943,7 @@ CREATE OR REPLACE FUNCTION ST_Snap(geom1 geometry, geom2 geometry, float8) CREATE OR REPLACE FUNCTION ST_RelateMatch(text, text) RETURNS bool AS 'MODULE_PATHNAME', 'ST_RelateMatch' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -------------------------------------------------------------------------------- @@ -2962,7 +2962,7 @@ CREATE OR REPLACE FUNCTION ST_RelateMatch(text, text) CREATE OR REPLACE FUNCTION ST_Node(g geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_Node' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; @@ -2975,7 +2975,7 @@ CREATE OR REPLACE FUNCTION ST_Node(g geometry) CREATE OR REPLACE FUNCTION ST_Combine_BBox(box3d,geometry) RETURNS box3d AS 'MODULE_PATHNAME', 'BOX3D_combine' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Availability: 1.2.2 CREATE AGGREGATE ST_Extent( @@ -2996,7 +2996,7 @@ CREATE AGGREGATE ST_3DExtent( CREATE OR REPLACE FUNCTION ST_Collect(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_collect' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Availability: 1.2.2 CREATE AGGREGATE ST_MemCollect( @@ -3009,7 +3009,7 @@ CREATE AGGREGATE ST_MemCollect( CREATE OR REPLACE FUNCTION ST_Collect(geometry[]) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_collect_garray' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE AGGREGATE ST_MemUnion ( @@ -3026,12 +3026,12 @@ CREATE AGGREGATE ST_MemUnion ( CREATE OR REPLACE FUNCTION pgis_abs_in(cstring) RETURNS pgis_abs AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION pgis_abs_out(pgis_abs) RETURNS cstring AS 'MODULE_PATHNAME' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE TYPE pgis_abs ( internallength = 8, @@ -3044,37 +3044,37 @@ CREATE TYPE pgis_abs ( CREATE OR REPLACE FUNCTION pgis_geometry_accum_transfn(pgis_abs, geometry) RETURNS pgis_abs AS 'MODULE_PATHNAME' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION pgis_geometry_accum_finalfn(pgis_abs) RETURNS geometry[] AS 'MODULE_PATHNAME' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION pgis_geometry_union_finalfn(pgis_abs) RETURNS geometry AS 'MODULE_PATHNAME' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION pgis_geometry_collect_finalfn(pgis_abs) RETURNS geometry AS 'MODULE_PATHNAME' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION pgis_geometry_polygonize_finalfn(pgis_abs) RETURNS geometry AS 'MODULE_PATHNAME' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION pgis_geometry_makeline_finalfn(pgis_abs) RETURNS geometry AS 'MODULE_PATHNAME' - LANGUAGE 'C'; + LANGUAGE 'c'; -- Availability: 1.2.2 CREATE AGGREGATE ST_Accum ( @@ -3088,7 +3088,7 @@ CREATE AGGREGATE ST_Accum ( CREATE OR REPLACE FUNCTION ST_Union (geometry[]) RETURNS geometry AS 'MODULE_PATHNAME','pgis_union_geometry_array' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE AGGREGATE ST_Union ( @@ -3130,32 +3130,32 @@ CREATE AGGREGATE ST_MakeLine ( CREATE OR REPLACE FUNCTION ST_Relate(geom1 geometry, geom2 geometry) RETURNS text AS 'MODULE_PATHNAME','relate_full' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 -- Requires GEOS >= 3.3.0 CREATE OR REPLACE FUNCTION ST_Relate(geom1 geometry, geom2 geometry, int4) RETURNS text AS 'MODULE_PATHNAME','relate_full' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: relate(geom1 geometry, geom2 geometry,text) CREATE OR REPLACE FUNCTION ST_Relate(geom1 geometry, geom2 geometry,text) RETURNS boolean AS 'MODULE_PATHNAME','relate_pattern' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: disjoint(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Disjoint(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','disjoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: touches(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION _ST_Touches(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','touches' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 @@ -3163,26 +3163,26 @@ CREATE OR REPLACE FUNCTION _ST_Touches(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Touches(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Touches($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.3.4 CREATE OR REPLACE FUNCTION _ST_DWithin(geom1 geometry, geom2 geometry,float8) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_dwithin' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_DWithin(geom1 geometry, geom2 geometry, float8) RETURNS boolean AS 'SELECT $1 && ST_Expand($2,$3) AND $2 && ST_Expand($1,$3) AND _ST_DWithin($1, $2, $3)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- PostGIS equivalent function: intersects(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION _ST_Intersects(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','intersects' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 @@ -3190,13 +3190,13 @@ CREATE OR REPLACE FUNCTION _ST_Intersects(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Intersects(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Intersects($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- PostGIS equivalent function: crosses(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION _ST_Crosses(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','crosses' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 @@ -3204,13 +3204,13 @@ CREATE OR REPLACE FUNCTION _ST_Crosses(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Crosses(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Crosses($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- PostGIS equivalent function: contains(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION _ST_Contains(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','contains' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 @@ -3218,26 +3218,26 @@ CREATE OR REPLACE FUNCTION _ST_Contains(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Contains(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Contains($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION _ST_CoveredBy(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'coveredby' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_CoveredBy(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_CoveredBy($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION _ST_Covers(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'covers' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.2 @@ -3245,13 +3245,13 @@ CREATE OR REPLACE FUNCTION _ST_Covers(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_Covers(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Covers($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION _ST_ContainsProperly(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','containsproperly' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.4.0 @@ -3259,93 +3259,93 @@ CREATE OR REPLACE FUNCTION _ST_ContainsProperly(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_ContainsProperly(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_ContainsProperly($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- PostGIS equivalent function: overlaps(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION _ST_Overlaps(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','overlaps' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- PostGIS equivalent function: within(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION _ST_Within(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT _ST_Contains($2,$1)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.2.2 -- Inlines index magic CREATE OR REPLACE FUNCTION ST_Within(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Contains($2,$1)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Availability: 1.2.2 -- Inlines index magic CREATE OR REPLACE FUNCTION ST_Overlaps(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_Overlaps($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- PostGIS equivalent function: IsValid(geometry) -- TODO: change null returns to true CREATE OR REPLACE FUNCTION ST_IsValid(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'isvalid' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- PostGIS equivalent function: Centroid(geometry) CREATE OR REPLACE FUNCTION ST_Centroid(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'centroid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: IsRing(geometry) CREATE OR REPLACE FUNCTION ST_IsRing(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'isring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: PointOnSurface(geometry) CREATE OR REPLACE FUNCTION ST_PointOnSurface(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'pointonsurface' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- PostGIS equivalent function: IsSimple(geometry) CREATE OR REPLACE FUNCTION ST_IsSimple(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'issimple' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_IsCollection(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'ST_IsCollection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION _ST_Equals(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','ST_Equals' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.2.1 CREATE OR REPLACE FUNCTION ST_Equals(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 ~= $2 AND _ST_Equals($1,$2)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Deprecation in 1.2.3 -- TODO: drop in 2.0.0 ! CREATE OR REPLACE FUNCTION Equals(geom1 geometry, geom2 geometry) RETURNS boolean AS 'MODULE_PATHNAME','ST_Equals' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- GML & KML INPUT @@ -3353,37 +3353,37 @@ CREATE OR REPLACE FUNCTION Equals(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION _ST_GeomFromGML(text, int4) RETURNS geometry AS 'MODULE_PATHNAME','geom_from_gml' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_GeomFromGML(text, int4) RETURNS geometry AS 'MODULE_PATHNAME','geom_from_gml' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_GeomFromGML(text) RETURNS geometry AS 'SELECT _ST_GeomFromGML($1, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_GMLToSQL(text) RETURNS geometry AS 'SELECT _ST_GeomFromGML($1, 0)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_GMLToSQL(text, int4) RETURNS geometry AS 'MODULE_PATHNAME','geom_from_gml' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_GeomFromKML(text) RETURNS geometry AS 'MODULE_PATHNAME','geom_from_kml' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- GEOJSON INPUT @@ -3392,13 +3392,13 @@ CREATE OR REPLACE FUNCTION ST_GeomFromKML(text) CREATE OR REPLACE FUNCTION ST_GeomFromGeoJson(text) RETURNS geometry AS 'MODULE_PATHNAME','geom_from_geojson' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION postgis_libjson_version() RETURNS text AS 'MODULE_PATHNAME','postgis_libjson_version' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- SVG OUTPUT @@ -3408,7 +3408,7 @@ CREATE OR REPLACE FUNCTION postgis_libjson_version() CREATE OR REPLACE FUNCTION ST_AsSVG(geom geometry,rel int4 DEFAULT 0,maxdecimaldigits int4 DEFAULT 15) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asSVG' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- GML OUTPUT @@ -3417,7 +3417,7 @@ CREATE OR REPLACE FUNCTION ST_AsSVG(geom geometry,rel int4 DEFAULT 0,maxdecimald CREATE OR REPLACE FUNCTION _ST_AsGML(int4, geometry, int4, int4, text) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asGML' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- ST_AsGML(version, geom) / precision=15 -- Availability: 1.3.2 @@ -3430,7 +3430,7 @@ CREATE OR REPLACE FUNCTION _ST_AsGML(int4, geometry, int4, int4, text) CREATE OR REPLACE FUNCTION ST_AsGML(geom geometry, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0) RETURNS TEXT AS $$ SELECT _ST_AsGML(2, $1, $2, $3, null); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsGML(version, geom, precision, option) -- Availability: 1.4.0 @@ -3440,7 +3440,7 @@ CREATE OR REPLACE FUNCTION ST_AsGML(geom geometry, maxdecimaldigits int4 DEFAULT CREATE OR REPLACE FUNCTION ST_AsGML(version int4, geom geometry, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0, nprefix text DEFAULT null) RETURNS TEXT AS $$ SELECT _ST_AsGML($1, $2, $3, $4,$5); $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; ----------------------------------------------------------------------- -- KML OUTPUT @@ -3449,14 +3449,14 @@ CREATE OR REPLACE FUNCTION ST_AsGML(version int4, geom geometry, maxdecimaldigit CREATE OR REPLACE FUNCTION _ST_AsKML(int4,geometry, int4, text) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asKML' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Availability: 1.2.2 -- Changed: 2.0.0 to use default args and allow named args CREATE OR REPLACE FUNCTION ST_AsKML(geom geometry, maxdecimaldigits int4 DEFAULT 15) RETURNS TEXT AS $$ SELECT _ST_AsKML(2, ST_Transform($1,4326), $2, null); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsKML(version, geom, precision, text) -- Availability: 2.0.0 @@ -3464,7 +3464,7 @@ CREATE OR REPLACE FUNCTION ST_AsKML(geom geometry, maxdecimaldigits int4 DEFAULT CREATE OR REPLACE FUNCTION ST_AsKML(version int4, geom geometry, maxdecimaldigits int4 DEFAULT 15, nprefix text DEFAULT null) RETURNS TEXT AS $$ SELECT _ST_AsKML($1, ST_Transform($2,4326), $3, $4); $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; ----------------------------------------------------------------------- @@ -3475,21 +3475,21 @@ CREATE OR REPLACE FUNCTION ST_AsKML(version int4, geom geometry, maxdecimaldigit CREATE OR REPLACE FUNCTION _ST_AsGeoJson(int4, geometry, int4, int4) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asGeoJson' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- ST_AsGeoJson(geom, precision, options) / version=1 -- Changed 2.0.0 to use default args and named args CREATE OR REPLACE FUNCTION ST_AsGeoJson(geom geometry, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0) RETURNS TEXT AS $$ SELECT _ST_AsGeoJson(1, $1, $2, $3); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- ST_AsGeoJson(version, geom, precision,options) -- Changed 2.0.0 to use default args and named args CREATE OR REPLACE FUNCTION ST_AsGeoJson(gj_version int4, geom geometry, maxdecimaldigits int4 DEFAULT 15, options int4 DEFAULT 0) RETURNS TEXT AS $$ SELECT _ST_AsGeoJson($1, $2, $3, $4); $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; ------------------------------------------------------------------------ -- GeoHash (geohash.org) @@ -3500,7 +3500,7 @@ CREATE OR REPLACE FUNCTION ST_AsGeoJson(gj_version int4, geom geometry, maxdecim CREATE OR REPLACE FUNCTION ST_GeoHash(geom geometry, maxchars int4 DEFAULT 0) RETURNS TEXT AS 'MODULE_PATHNAME', 'ST_GeoHash' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ------------------------------------------------------------------------ -- OGC defined @@ -3509,67 +3509,67 @@ CREATE OR REPLACE FUNCTION ST_GeoHash(geom geometry, maxchars int4 DEFAULT 0) CREATE OR REPLACE FUNCTION ST_NumPoints(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_numpoints_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: NumGeometries(geometry) CREATE OR REPLACE FUNCTION ST_NumGeometries(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_numgeometries_collection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: GeometryN(geometry) CREATE OR REPLACE FUNCTION ST_GeometryN(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_geometryn_collection' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: Dimension(geometry) CREATE OR REPLACE FUNCTION ST_Dimension(geometry) RETURNS int4 AS 'MODULE_PATHNAME', 'LWGEOM_dimension' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: ExteriorRing(geometry) CREATE OR REPLACE FUNCTION ST_ExteriorRing(geometry) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_exteriorring_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: NumInteriorRings(geometry) CREATE OR REPLACE FUNCTION ST_NumInteriorRings(geometry) RETURNS integer AS 'MODULE_PATHNAME','LWGEOM_numinteriorrings_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_NumInteriorRing(geometry) RETURNS integer AS 'MODULE_PATHNAME','LWGEOM_numinteriorrings_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: InteriorRingN(geometry) CREATE OR REPLACE FUNCTION ST_InteriorRingN(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_interiorringn_polygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Deprecation in 1.2.3 -- this should not be deprecated (2011-01-04 robe) CREATE OR REPLACE FUNCTION GeometryType(geometry) RETURNS text AS 'MODULE_PATHNAME', 'LWGEOM_getTYPE' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Not quite equivalent to GeometryType CREATE OR REPLACE FUNCTION ST_GeometryType(geometry) RETURNS text AS 'MODULE_PATHNAME', 'geometry_geometrytype' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: PointN(geometry,integer) CREATE OR REPLACE FUNCTION ST_PointN(geometry,integer) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_pointn_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_NumPatches(geometry) @@ -3579,7 +3579,7 @@ CREATE OR REPLACE FUNCTION ST_NumPatches(geometry) THEN ST_NumGeometries($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_PatchN(geometry, integer) @@ -3589,91 +3589,91 @@ CREATE OR REPLACE FUNCTION ST_PatchN(geometry, integer) THEN ST_GeometryN($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function of old StartPoint(geometry)) CREATE OR REPLACE FUNCTION ST_StartPoint(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_startpoint_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function of old EndPoint(geometry) CREATE OR REPLACE FUNCTION ST_EndPoint(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_endpoint_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: IsClosed(geometry) CREATE OR REPLACE FUNCTION ST_IsClosed(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_isclosed' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: IsEmpty(geometry) CREATE OR REPLACE FUNCTION ST_IsEmpty(geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_isempty' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION ST_SRID(geometry) RETURNS int4 AS 'MODULE_PATHNAME','LWGEOM_get_srid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_SetSRID(geometry,int4) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_set_srid' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_AsBinary(geometry,text) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_asBinary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent of old function: AsBinary(geometry) CREATE OR REPLACE FUNCTION ST_AsBinary(geometry) RETURNS bytea AS 'MODULE_PATHNAME','LWGEOM_asBinary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: AsText(geometry) CREATE OR REPLACE FUNCTION ST_AsText(geometry) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asText' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeometryFromText(text) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeometryFromText(text, int4) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeomFromText(text) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: ST_GeometryFromText(text, int4) CREATE OR REPLACE FUNCTION ST_GeomFromText(text, int4) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: ST_GeometryFromText(text) -- SQL/MM alias for ST_GeomFromText CREATE OR REPLACE FUNCTION ST_WKTToSQL(text) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_text' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PointFromText(text) @@ -3683,7 +3683,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromText(text) THEN ST_GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: PointFromText(text, int4) @@ -3695,7 +3695,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromText(text, int4) THEN ST_GeomFromText($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_LineFromText(text) @@ -3705,7 +3705,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromText(text) THEN ST_GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: LineFromText(text, int4) CREATE OR REPLACE FUNCTION ST_LineFromText(text, int4) @@ -3715,7 +3715,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromText(text, int4) THEN ST_GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PolyFromText(text) @@ -3725,7 +3725,7 @@ CREATE OR REPLACE FUNCTION ST_PolyFromText(text) THEN ST_GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: ST_PolygonFromText(text, int4) CREATE OR REPLACE FUNCTION ST_PolyFromText(text, int4) @@ -3735,19 +3735,19 @@ CREATE OR REPLACE FUNCTION ST_PolyFromText(text, int4) THEN ST_GeomFromText($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PolygonFromText(text, int4) RETURNS geometry AS 'SELECT ST_PolyFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PolygonFromText(text) RETURNS geometry AS 'SELECT ST_PolyFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: MLineFromText(text, int4) CREATE OR REPLACE FUNCTION ST_MLineFromText(text, int4) @@ -3758,7 +3758,7 @@ CREATE OR REPLACE FUNCTION ST_MLineFromText(text, int4) THEN ST_GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MLineFromText(text) @@ -3768,20 +3768,20 @@ CREATE OR REPLACE FUNCTION ST_MLineFromText(text) THEN ST_GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiLineStringFromText(text) RETURNS geometry AS 'SELECT ST_MLineFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiLineStringFromText(text, int4) RETURNS geometry AS 'SELECT ST_MLineFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: MPointFromText(text, int4) CREATE OR REPLACE FUNCTION ST_MPointFromText(text, int4) @@ -3791,7 +3791,7 @@ CREATE OR REPLACE FUNCTION ST_MPointFromText(text, int4) THEN ST_GeomFromText($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MPointFromText(text) @@ -3801,19 +3801,19 @@ CREATE OR REPLACE FUNCTION ST_MPointFromText(text) THEN ST_GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiPointFromText(text) RETURNS geometry AS 'SELECT ST_MPointFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiPointFromText(text) RETURNS geometry AS 'SELECT ST_MPointFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: MPolyFromText(text, int4) CREATE OR REPLACE FUNCTION ST_MPolyFromText(text, int4) @@ -3823,7 +3823,7 @@ CREATE OR REPLACE FUNCTION ST_MPolyFromText(text, int4) THEN ST_GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; --Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MPolyFromText(text) @@ -3833,19 +3833,19 @@ CREATE OR REPLACE FUNCTION ST_MPolyFromText(text) THEN ST_GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiPolygonFromText(text, int4) RETURNS geometry AS 'SELECT ST_MPolyFromText($1, $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiPolygonFromText(text) RETURNS geometry AS 'SELECT ST_MPolyFromText($1)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeomCollFromText(text, int4) @@ -3856,7 +3856,7 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromText(text, int4) THEN ST_GeomFromText($1,$2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeomCollFromText(text) @@ -3867,19 +3867,19 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromText(text) THEN ST_GeomFromText($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeomFromWKB(bytea) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_WKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: GeomFromWKB(bytea, int) CREATE OR REPLACE FUNCTION ST_GeomFromWKB(bytea, int) RETURNS geometry AS 'SELECT ST_SetSRID(ST_GeomFromWKB($1), $2)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: PointFromWKB(bytea, int) CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea, int) @@ -3889,7 +3889,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea) @@ -3899,7 +3899,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: LineFromWKB(bytea, int) CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea, int) @@ -3909,7 +3909,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea) @@ -3919,7 +3919,7 @@ CREATE OR REPLACE FUNCTION ST_LineFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea, int) @@ -3929,7 +3929,7 @@ CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea) @@ -3939,7 +3939,7 @@ CREATE OR REPLACE FUNCTION ST_LinestringFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: PolyFromWKB(text, int) CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea, int) @@ -3949,7 +3949,7 @@ CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea) @@ -3959,7 +3959,7 @@ CREATE OR REPLACE FUNCTION ST_PolyFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea, int) @@ -3969,7 +3969,7 @@ CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea) @@ -3979,7 +3979,7 @@ CREATE OR REPLACE FUNCTION ST_PolygonFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: MPointFromWKB(text, int) CREATE OR REPLACE FUNCTION ST_MPointFromWKB(bytea, int) @@ -3989,7 +3989,7 @@ CREATE OR REPLACE FUNCTION ST_MPointFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 @@ -4000,7 +4000,7 @@ CREATE OR REPLACE FUNCTION ST_MPointFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea, int) @@ -4010,7 +4010,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea) @@ -4020,7 +4020,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPointFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiLineFromWKB(bytea) @@ -4030,7 +4030,7 @@ CREATE OR REPLACE FUNCTION ST_MultiLineFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: MLineFromWKB(text, int) CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea, int) @@ -4040,7 +4040,7 @@ CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea) @@ -4050,7 +4050,7 @@ CREATE OR REPLACE FUNCTION ST_MLineFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 -- PostGIS equivalent function: MPolyFromWKB(bytea, int) @@ -4061,7 +4061,7 @@ CREATE OR REPLACE FUNCTION ST_MPolyFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MPolyFromWKB(bytea) @@ -4071,7 +4071,7 @@ CREATE OR REPLACE FUNCTION ST_MPolyFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_MultiPolyFromWKB(bytea, int) @@ -4081,7 +4081,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPolyFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 @@ -4092,7 +4092,7 @@ CREATE OR REPLACE FUNCTION ST_MultiPolyFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 CREATE OR REPLACE FUNCTION ST_GeomCollFromWKB(bytea, int) @@ -4103,7 +4103,7 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromWKB(bytea, int) THEN ST_GeomFromWKB($1, $2) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- Availability: 1.2.2 @@ -4115,7 +4115,7 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromWKB(bytea) THEN ST_GeomFromWKB($1) ELSE NULL END ' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; --New functions @@ -4125,48 +4125,48 @@ CREATE OR REPLACE FUNCTION ST_GeomCollFromWKB(bytea) CREATE OR REPLACE FUNCTION _ST_MaxDistance(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_maxdistance2d_linestring' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION ST_MaxDistance(geom1 geometry, geom2 geometry) RETURNS float8 AS 'SELECT _ST_MaxDistance(ST_ConvexHull($1), ST_ConvexHull($2))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION ST_ClosestPoint(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_closestpoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION ST_ShortestLine(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_shortestline2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION _ST_LongestLine(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_longestline2d' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION ST_LongestLine(geom1 geometry, geom2 geometry) RETURNS geometry AS 'SELECT _ST_LongestLine(ST_ConvexHull($1), ST_ConvexHull($2))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION _ST_DFullyWithin(geom1 geometry, geom2 geometry,float8) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_dfullywithin' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION ST_DFullyWithin(geom1 geometry, geom2 geometry, float8) RETURNS boolean AS 'SELECT $1 && ST_Expand($2,$3) AND $2 && ST_Expand($1,$3) AND _ST_DFullyWithin(ST_ConvexHull($1), ST_ConvexHull($2), $3)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; CREATE OR REPLACE FUNCTION ST_FlipCoordinates(geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_FlipCoordinates' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- -- SFSQL 1.1 @@ -4260,7 +4260,7 @@ CREATE OR REPLACE FUNCTION ST_distance_sphere(geom1 geometry, geom2 geometry) AS $$ select st_distance(geography($1),geography($2),false) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT + LANGUAGE 'sql' IMMUTABLE STRICT COST 300; -- Availability: 1.2.2 @@ -4269,7 +4269,7 @@ CREATE OR REPLACE FUNCTION ST_distance_sphere(geom1 geometry, geom2 geometry) AS $$ select st_distance(geography($1),geography($2),false) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT + LANGUAGE 'sql' IMMUTABLE STRICT COST 300; @@ -4367,7 +4367,7 @@ $$ WHERE (upper(old_name) = upper($1) OR upper(new_name) = upper($1)) AND coord_dimension = $2; $$ -language 'sql' IMMUTABLE STRICT COST 200; +LANGUAGE 'sql' IMMUTABLE STRICT COST 200; CREATE OR REPLACE FUNCTION postgis_constraint_srid(geomschema text, geomtable text, geomcolumn text) RETURNS integer AS $$ @@ -4471,61 +4471,61 @@ CREATE OR REPLACE RULE geometry_columns_delete AS CREATE OR REPLACE FUNCTION ST_3DDistance(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_mindistance3d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; CREATE OR REPLACE FUNCTION ST_3DMaxDistance(geom1 geometry, geom2 geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'LWGEOM_maxdistance3d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; CREATE OR REPLACE FUNCTION ST_3DClosestPoint(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_closestpoint3d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; CREATE OR REPLACE FUNCTION ST_3DShortestLine(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_shortestline3d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; CREATE OR REPLACE FUNCTION ST_3DLongestLine(geom1 geometry, geom2 geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_longestline3d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; CREATE OR REPLACE FUNCTION _ST_3DDWithin(geom1 geometry, geom2 geometry,float8) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_dwithin3d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; CREATE OR REPLACE FUNCTION ST_3DDWithin(geom1 geometry, geom2 geometry,float8) RETURNS boolean AS 'SELECT $1 && ST_Expand($2,$3) AND $2 && ST_Expand($1,$3) AND _ST_3DDWithin($1, $2, $3)' - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 100; CREATE OR REPLACE FUNCTION _ST_3DDFullyWithin(geom1 geometry, geom2 geometry,float8) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_dfullywithin3d' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; CREATE OR REPLACE FUNCTION ST_3DDFullyWithin(geom1 geometry, geom2 geometry,float8) RETURNS boolean AS 'SELECT $1 && ST_Expand($2,$3) AND $2 && ST_Expand($1,$3) AND _ST_3DDFullyWithin($1, $2, $3)' - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 100; CREATE OR REPLACE FUNCTION ST_3DIntersects(geom1 geometry, geom2 geometry) RETURNS boolean AS 'SELECT $1 && $2 AND _ST_3DDWithin($1, $2, 0.0)' - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 100; @@ -4536,7 +4536,7 @@ CREATE OR REPLACE FUNCTION ST_3DIntersects(geom1 geometry, geom2 geometry) CREATE OR REPLACE FUNCTION ST_CoordDim(Geometry geometry) RETURNS smallint AS 'MODULE_PATHNAME', 'LWGEOM_ndims' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- -- SQL-MM -- @@ -4548,7 +4548,7 @@ CREATE OR REPLACE FUNCTION ST_CoordDim(Geometry geometry) CREATE OR REPLACE FUNCTION ST_CurveToLine(geometry, integer) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_curve_segmentize' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- -- SQL-MM -- @@ -4559,23 +4559,23 @@ CREATE OR REPLACE FUNCTION ST_CurveToLine(geometry, integer) -- the default value of 32 segments per quarter circle CREATE OR REPLACE FUNCTION ST_CurveToLine(geometry) RETURNS geometry AS 'SELECT ST_CurveToLine($1, 32)' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION ST_HasArc(Geometry geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_has_arc' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION ST_LineToCurve(Geometry geometry) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_line_desegmentize' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 1.5.0 CREATE OR REPLACE FUNCTION _ST_OrderingEquals(GeometryA geometry, GeometryB geometry) RETURNS boolean AS 'MODULE_PATHNAME', 'LWGEOM_same' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 100; -- Availability: 1.3.0 @@ -4584,7 +4584,7 @@ CREATE OR REPLACE FUNCTION ST_OrderingEquals(GeometryA geometry, GeometryB geome AS $$ SELECT $1 ~= $2 AND _ST_OrderingEquals($1, $2) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; ------------------------------------------------------------------------------- -- SQL/MM - SQL Functions on type ST_Point @@ -4594,7 +4594,7 @@ CREATE OR REPLACE FUNCTION ST_OrderingEquals(GeometryA geometry, GeometryB geome CREATE OR REPLACE FUNCTION ST_Point(float8, float8) RETURNS geometry AS 'MODULE_PATHNAME', 'LWGEOM_makepoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- PostGIS equivalent function: ST_MakePolygon(Geometry geometry) CREATE OR REPLACE FUNCTION ST_Polygon(geometry, int) @@ -4602,14 +4602,14 @@ CREATE OR REPLACE FUNCTION ST_Polygon(geometry, int) AS $$ SELECT ST_SetSRID(ST_MakePolygon($1), $2) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- PostGIS equivalent function: GeomFromWKB(WKB bytea)) -- Note: Defaults to an SRID=-1, not 0 as per SQL/MM specs. CREATE OR REPLACE FUNCTION ST_WKBToSQL(WKB bytea) RETURNS geometry AS 'MODULE_PATHNAME','LWGEOM_from_WKB' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --- -- Linear referencing functions @@ -4618,26 +4618,26 @@ CREATE OR REPLACE FUNCTION ST_WKBToSQL(WKB bytea) CREATE OR REPLACE FUNCTION ST_LocateBetween(Geometry geometry, FromMeasure float8, ToMeasure float8, LeftRightOffset float8 default 0.0) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_LocateBetween' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_LocateAlong(Geometry geometry, Measure float8, LeftRightOffset float8 default 0.0) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_LocateAlong' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Only accepts LINESTRING as parameters. -- Availability: 1.4.0 CREATE OR REPLACE FUNCTION ST_LocateBetweenElevations(Geometry geometry, FromElevation float8, ToElevation float8) RETURNS geometry AS 'MODULE_PATHNAME', 'ST_LocateBetweenElevations' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Availability: 2.0.0 CREATE OR REPLACE FUNCTION ST_InterpolatePoint(Line geometry, Point geometry) RETURNS float8 AS 'MODULE_PATHNAME', 'ST_InterpolatePoint' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; --------------------------------------------------------------- -- END @@ -4997,7 +4997,7 @@ LANGUAGE 'plpgsql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION _ST_AsX3D(int4, geometry, int4, int4, text) RETURNS TEXT AS 'MODULE_PATHNAME','LWGEOM_asX3D' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- ST_AsX3D(geom, precision, options) CREATE OR REPLACE FUNCTION ST_AsX3D(geom geometry, maxdecimaldigits integer DEFAULT 15, options integer DEFAULT 0) diff --git a/raster/rt_pg/rtpostgis.sql.in.c b/raster/rt_pg/rtpostgis.sql.in.c index be49b1456..ce2aa3fe5 100644 --- a/raster/rt_pg/rtpostgis.sql.in.c +++ b/raster/rt_pg/rtpostgis.sql.in.c @@ -34,12 +34,12 @@ BEGIN; CREATE OR REPLACE FUNCTION raster_in(cstring) RETURNS raster AS 'MODULE_PATHNAME','RASTER_in' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_out(raster) RETURNS cstring AS 'MODULE_PATHNAME','RASTER_out' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE TYPE raster ( alignment = double, @@ -60,7 +60,7 @@ CREATE TYPE raster ( CREATE OR REPLACE FUNCTION postgis_raster_lib_version() RETURNS text AS 'MODULE_PATHNAME', 'RASTER_lib_version' - LANGUAGE 'C' IMMUTABLE; -- a new lib will require a new session + LANGUAGE 'c' IMMUTABLE; -- a new lib will require a new session CREATE OR REPLACE FUNCTION postgis_raster_scripts_installed() RETURNS text AS _POSTGIS_SQL_SELECT_POSTGIS_SCRIPTS_VERSION @@ -69,12 +69,12 @@ CREATE OR REPLACE FUNCTION postgis_raster_scripts_installed() RETURNS text CREATE OR REPLACE FUNCTION postgis_raster_lib_build_date() RETURNS text AS 'MODULE_PATHNAME', 'RASTER_lib_build_date' - LANGUAGE 'C' IMMUTABLE; -- a new lib will require a new session + LANGUAGE 'c' IMMUTABLE; -- a new lib will require a new session CREATE OR REPLACE FUNCTION postgis_gdal_version() RETURNS text AS 'MODULE_PATHNAME', 'RASTER_gdal_version' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; ----------------------------------------------------------------------- -- Raster Accessors @@ -83,77 +83,77 @@ CREATE OR REPLACE FUNCTION postgis_gdal_version() CREATE OR REPLACE FUNCTION st_convexhull(raster) RETURNS geometry AS 'MODULE_PATHNAME','RASTER_convex_hull' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION box3d(raster) RETURNS box3d AS 'select box3d(st_convexhull($1))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_envelope(raster) RETURNS geometry AS 'select st_envelope(st_convexhull($1))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_height(raster) RETURNS integer AS 'MODULE_PATHNAME','RASTER_getHeight' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_numbands(raster) RETURNS integer AS 'MODULE_PATHNAME','RASTER_getNumBands' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_scalex(raster) RETURNS float8 AS 'MODULE_PATHNAME','RASTER_getXScale' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_scaley(raster) RETURNS float8 AS 'MODULE_PATHNAME','RASTER_getYScale' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_skewx(raster) RETURNS float8 AS 'MODULE_PATHNAME','RASTER_getXSkew' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_skewy(raster) RETURNS float8 AS 'MODULE_PATHNAME','RASTER_getYSkew' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_srid(raster) RETURNS integer AS 'MODULE_PATHNAME','RASTER_getSRID' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_upperleftx(raster) RETURNS float8 AS 'MODULE_PATHNAME','RASTER_getXUpperLeft' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_upperlefty(raster) RETURNS float8 AS 'MODULE_PATHNAME','RASTER_getYUpperLeft' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_width(raster) RETURNS integer AS 'MODULE_PATHNAME','RASTER_getWidth' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_pixelwidth(raster) RETURNS float8 AS 'MODULE_PATHNAME', 'RASTER_getPixelWidth' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_pixelheight(raster) RETURNS float8 AS 'MODULE_PATHNAME', 'RASTER_getPixelHeight' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_geotransform(raster, OUT imag double precision, @@ -163,7 +163,7 @@ CREATE OR REPLACE FUNCTION st_geotransform(raster, OUT xoffset double precision, OUT yoffset double precision) AS 'MODULE_PATHNAME', 'RASTER_getGeotransform' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION st_rotation(raster) RETURNS float8 @@ -184,7 +184,7 @@ CREATE OR REPLACE FUNCTION st_metadata( OUT numbands int ) AS 'MODULE_PATHNAME', 'RASTER_metadata' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- Constructors ST_MakeEmptyRaster and ST_AddBand @@ -192,12 +192,12 @@ CREATE OR REPLACE FUNCTION st_metadata( CREATE OR REPLACE FUNCTION st_makeemptyraster(width int, height int, upperleftx float8, upperlefty float8, scalex float8, scaley float8, skewx float8, skewy float8, srid int4 DEFAULT 0) RETURNS RASTER AS 'MODULE_PATHNAME', 'RASTER_makeEmpty' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_makeemptyraster(width int, height int, upperleftx float8, upperlefty float8, pixelsize float8) RETURNS raster AS $$ SELECT st_makeemptyraster($1, $2, $3, $4, $5, -($5), 0, 0, ST_SRID('POINT(0 0)'::geometry)) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_makeemptyraster(rast raster) RETURNS raster @@ -222,19 +222,19 @@ CREATE OR REPLACE FUNCTION st_makeemptyraster(rast raster) CREATE OR REPLACE FUNCTION st_addband(rast raster, index int, pixeltype text, initialvalue float8 DEFAULT 0., nodataval float8 DEFAULT NULL) RETURNS RASTER AS 'MODULE_PATHNAME', 'RASTER_addband' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- This function can not be STRICT, because nodataval can be NULL indicating that no nodata value should be set CREATE OR REPLACE FUNCTION st_addband(rast raster, pixeltype text, initialvalue float8 DEFAULT 0., nodataval float8 DEFAULT NULL) RETURNS raster AS 'select st_addband($1, NULL, $2, $3, $4)' - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- This function can not be STRICT, because torastindex can not be determined (could be st_numbands(raster) though) CREATE OR REPLACE FUNCTION st_addband(torast raster, fromrast raster, fromband int DEFAULT 1, torastindex int DEFAULT NULL) RETURNS RASTER AS 'MODULE_PATHNAME', 'RASTER_copyband' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Variant that adds multiple raster bands in one array call -- -- If null is passed in for the torast, then array of rasts is accumulated. @@ -264,17 +264,17 @@ $$ LANGUAGE 'plpgsql'; CREATE OR REPLACE FUNCTION st_band(rast raster, nbands int[] DEFAULT ARRAY[1]) RETURNS RASTER AS 'MODULE_PATHNAME', 'RASTER_band' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_band(rast raster, nband int) RETURNS RASTER AS $$ SELECT st_band($1, ARRAY[$2]) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_band(rast raster, nbands text, delimiter char DEFAULT ',') RETURNS RASTER AS $$ SELECT st_band($1, regexp_split_to_array(regexp_replace($2, '[[:space:]]', '', 'g'), $3)::int[]) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- ST_SummaryStats and ST_ApproxSummaryStats @@ -291,72 +291,72 @@ CREATE TYPE summarystats AS ( CREATE OR REPLACE FUNCTION _st_summarystats(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 1) RETURNS summarystats AS 'MODULE_PATHNAME','RASTER_summaryStats' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION st_summarystats(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, $3, 1) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_summarystats(rast raster, exclude_nodata_value boolean) RETURNS summarystats AS $$ SELECT _st_summarystats($1, 1, $2, 1) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 0.1) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, $3, $4) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rast raster, nband int, sample_percent double precision) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, TRUE, $3) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rast raster, exclude_nodata_value boolean, sample_percent double precision DEFAULT 0.1) RETURNS summarystats AS $$ SELECT _st_summarystats($1, 1, $2, $3) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rast raster, sample_percent double precision) RETURNS summarystats AS $$ SELECT _st_summarystats($1, 1, TRUE, $2) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION _st_summarystats(rastertable text, rastercolumn text, nband integer DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 1) RETURNS summarystats AS 'MODULE_PATHNAME','RASTER_summaryStatsCoverage' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION st_summarystats(rastertable text, rastercolumn text, nband integer DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, $3, $4, 1) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_summarystats(rastertable text, rastercolumn text, exclude_nodata_value boolean) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, 1, $3, 1) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rastertable text, rastercolumn text, nband integer DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 0.1) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, $3, $4, $5) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rastertable text, rastercolumn text, nband integer, sample_percent double precision) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, $3, TRUE, $4) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rastertable text, rastercolumn text, exclude_nodata_value boolean) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, 1, $3, 0.1) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxsummarystats(rastertable text, rastercolumn text, sample_percent double precision) RETURNS summarystats AS $$ SELECT _st_summarystats($1, $2, 1, TRUE, $3) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; ----------------------------------------------------------------------- -- ST_Count and ST_ApproxCount @@ -380,32 +380,32 @@ CREATE OR REPLACE FUNCTION _st_count(rast raster, nband int DEFAULT 1, exclude_n CREATE OR REPLACE FUNCTION st_count(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE) RETURNS bigint AS $$ SELECT _st_count($1, $2, $3, 1) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_count(rast raster, exclude_nodata_value boolean) RETURNS bigint AS $$ SELECT _st_count($1, 1, $2, 1) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 0.1) RETURNS bigint AS $$ SELECT _st_count($1, $2, $3, $4) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rast raster, nband int, sample_percent double precision) RETURNS bigint AS $$ SELECT _st_count($1, $2, TRUE, $3) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rast raster, exclude_nodata_value boolean, sample_percent double precision DEFAULT 0.1) RETURNS bigint AS $$ SELECT _st_count($1, 1, $2, $3) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rast raster, sample_percent double precision) RETURNS bigint AS $$ SELECT _st_count($1, 1, TRUE, $2) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION _st_count(rastertable text, rastercolumn text, nband integer DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 1) RETURNS bigint @@ -475,32 +475,32 @@ CREATE OR REPLACE FUNCTION _st_count(rastertable text, rastercolumn text, nband CREATE OR REPLACE FUNCTION st_count(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE) RETURNS bigint AS $$ SELECT _st_count($1, $2, $3, $4, 1) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_count(rastertable text, rastercolumn text, exclude_nodata_value boolean) RETURNS bigint AS $$ SELECT _st_count($1, $2, 1, $3, 1) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 0.1) RETURNS bigint AS $$ SELECT _st_count($1, $2, $3, $4, $5) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rastertable text, rastercolumn text, nband int, sample_percent double precision) RETURNS bigint AS $$ SELECT _st_count($1, $2, $3, TRUE, $4) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision DEFAULT 0.1) RETURNS bigint AS $$ SELECT _st_count($1, $2, 1, $3, $4) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; CREATE OR REPLACE FUNCTION st_approxcount(rastertable text, rastercolumn text, sample_percent double precision) RETURNS bigint AS $$ SELECT _st_count($1, $2, 1, TRUE, $3) $$ - LANGUAGE 'SQL' STABLE STRICT; + LANGUAGE 'sql' STABLE STRICT; ----------------------------------------------------------------------- -- ST_Histogram and ST_ApproxHistogram @@ -523,7 +523,7 @@ CREATE OR REPLACE FUNCTION _st_histogram( ) RETURNS SETOF histogram AS 'MODULE_PATHNAME','RASTER_histogram' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Cannot be strict as "width" can be NULL CREATE OR REPLACE FUNCTION st_histogram(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, bins int DEFAULT 0, width double precision[] DEFAULT NULL, right boolean DEFAULT FALSE) @@ -596,7 +596,7 @@ CREATE OR REPLACE FUNCTION _st_histogram( ) RETURNS SETOF histogram AS 'MODULE_PATHNAME','RASTER_histogramCoverage' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION st_histogram(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, bins int DEFAULT 0, width double precision[] DEFAULT NULL, right boolean DEFAULT FALSE) RETURNS SETOF histogram @@ -670,7 +670,7 @@ CREATE TYPE quantile AS ( CREATE OR REPLACE FUNCTION _st_quantile(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 1, quantiles double precision[] DEFAULT NULL) RETURNS SETOF quantile AS 'MODULE_PATHNAME','RASTER_quantile' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Cannot be strict as "quantiles" can be NULL CREATE OR REPLACE FUNCTION st_quantile(rast raster, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, quantiles double precision[] DEFAULT NULL) @@ -762,7 +762,7 @@ CREATE OR REPLACE FUNCTION st_approxquantile(rast raster, quantile double precis CREATE OR REPLACE FUNCTION _st_quantile(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 1, quantiles double precision[] DEFAULT NULL) RETURNS SETOF quantile AS 'MODULE_PATHNAME','RASTER_quantileCoverage' - LANGUAGE 'C' STABLE; + LANGUAGE 'c' STABLE; -- Cannot be strict as "quantiles" can be NULL CREATE OR REPLACE FUNCTION st_quantile(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, quantiles double precision[] DEFAULT NULL) @@ -865,7 +865,7 @@ CREATE TYPE valuecount AS ( CREATE OR REPLACE FUNCTION _st_valuecount(rast raster, nband integer DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, searchvalues double precision[] DEFAULT NULL, roundto double precision DEFAULT 0) RETURNS SETOF valuecount AS 'MODULE_PATHNAME', 'RASTER_valueCount' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; CREATE OR REPLACE FUNCTION st_valuecount( rast raster, nband integer DEFAULT 1, @@ -942,7 +942,7 @@ CREATE OR REPLACE FUNCTION st_valuepercent(rast raster, searchvalue double preci CREATE OR REPLACE FUNCTION _st_valuecount(rastertable text, rastercolumn text, nband integer DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, searchvalues double precision[] DEFAULT NULL, roundto double precision DEFAULT 0) RETURNS SETOF valuecount AS 'MODULE_PATHNAME', 'RASTER_valueCountCoverage' - LANGUAGE 'C' STABLE; + LANGUAGE 'c' STABLE; CREATE OR REPLACE FUNCTION st_valuecount( rastertable text, rastercolumn text, @@ -1031,7 +1031,7 @@ CREATE TYPE reclassarg AS ( CREATE OR REPLACE FUNCTION _st_reclass(rast raster, VARIADIC reclassargset reclassarg[]) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_reclass' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_reclass(rast raster, VARIADIC reclassargset reclassarg[]) RETURNS raster @@ -1056,12 +1056,12 @@ CREATE OR REPLACE FUNCTION st_reclass(rast raster, VARIADIC reclassargset reclas CREATE OR REPLACE FUNCTION st_reclass(rast raster, nband int, reclassexpr text, pixeltype text, nodataval double precision DEFAULT NULL) RETURNS raster AS $$ SELECT st_reclass($1, ROW($2, $3, $4, $5)) $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; CREATE OR REPLACE FUNCTION st_reclass(rast raster, reclassexpr text, pixeltype text) RETURNS raster AS $$ SELECT st_reclass($1, ROW(1, $2, $3, NULL)) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- ST_AsGDALRaster and supporting functions @@ -1070,13 +1070,13 @@ CREATE OR REPLACE FUNCTION st_reclass(rast raster, reclassexpr text, pixeltype t CREATE OR REPLACE FUNCTION st_gdaldrivers(OUT idx int, OUT short_name text, OUT long_name text, OUT create_options text) RETURNS SETOF record AS 'MODULE_PATHNAME', 'RASTER_getGDALDrivers' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; -- Cannot be strict as "options" and "srid" can be NULL CREATE OR REPLACE FUNCTION st_asgdalraster(rast raster, format text, options text[] DEFAULT NULL, srid integer DEFAULT NULL) RETURNS bytea AS 'MODULE_PATHNAME', 'RASTER_asGDALRaster' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; ----------------------------------------------------------------------- -- ST_AsTIFF @@ -1111,7 +1111,7 @@ CREATE OR REPLACE FUNCTION st_astiff(rast raster, options text[] DEFAULT NULL, s CREATE OR REPLACE FUNCTION st_astiff(rast raster, nbands int[], options text[] DEFAULT NULL, srid integer DEFAULT NULL) RETURNS bytea AS $$ SELECT st_astiff(st_band($1, $2), $3, $4) $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; -- Cannot be strict as "srid" can be NULL CREATE OR REPLACE FUNCTION st_astiff(rast raster, compression text, srid integer DEFAULT NULL) @@ -1198,7 +1198,7 @@ CREATE OR REPLACE FUNCTION st_astiff(rast raster, compression text, srid integer CREATE OR REPLACE FUNCTION st_astiff(rast raster, nbands int[], compression text, srid integer DEFAULT NULL) RETURNS bytea AS $$ SELECT st_astiff(st_band($1, $2), $3, $4) $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; ----------------------------------------------------------------------- -- ST_AsJPEG @@ -1238,7 +1238,7 @@ CREATE OR REPLACE FUNCTION st_asjpeg(rast raster, options text[] DEFAULT NULL) CREATE OR REPLACE FUNCTION st_asjpeg(rast raster, nbands int[], options text[] DEFAULT NULL) RETURNS bytea AS $$ SELECT st_asjpeg(st_band($1, $2), $3) $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; CREATE OR REPLACE FUNCTION st_asjpeg(rast raster, nbands int[], quality int) RETURNS bytea @@ -1267,12 +1267,12 @@ CREATE OR REPLACE FUNCTION st_asjpeg(rast raster, nbands int[], quality int) CREATE OR REPLACE FUNCTION st_asjpeg(rast raster, nband int, options text[] DEFAULT NULL) RETURNS bytea AS $$ SELECT st_asjpeg(st_band($1, $2), $3) $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; CREATE OR REPLACE FUNCTION st_asjpeg(rast raster, nband int, quality int) RETURNS bytea AS $$ SELECT st_asjpeg($1, ARRAY[$2], $3) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- ST_AsPNG @@ -1314,7 +1314,7 @@ CREATE OR REPLACE FUNCTION st_aspng(rast raster, options text[] DEFAULT NULL) CREATE OR REPLACE FUNCTION st_aspng(rast raster, nbands int[], options text[] DEFAULT NULL) RETURNS bytea AS $$ SELECT st_aspng(st_band($1, $2), $3) $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; CREATE OR REPLACE FUNCTION st_aspng(rast raster, nbands int[], compression int) RETURNS bytea @@ -1342,12 +1342,12 @@ CREATE OR REPLACE FUNCTION st_aspng(rast raster, nbands int[], compression int) CREATE OR REPLACE FUNCTION st_aspng(rast raster, nband int, options text[] DEFAULT NULL) RETURNS bytea AS $$ SELECT st_aspng(st_band($1, $2), $3) $$ - LANGUAGE 'SQL' IMMUTABLE; + LANGUAGE 'sql' IMMUTABLE; CREATE OR REPLACE FUNCTION st_aspng(rast raster, nband int, compression int) RETURNS bytea AS $$ SELECT st_aspng($1, ARRAY[$2], $3) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- ST_AsRaster @@ -1367,7 +1367,7 @@ CREATE OR REPLACE FUNCTION _st_asraster( ) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_asRaster' - LANGUAGE 'C' STABLE; + LANGUAGE 'c' STABLE; CREATE OR REPLACE FUNCTION st_asraster( geom geometry, @@ -1546,7 +1546,7 @@ CREATE OR REPLACE FUNCTION _st_resample( ) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_resample' - LANGUAGE 'C' STABLE; + LANGUAGE 'c' STABLE; CREATE OR REPLACE FUNCTION st_resample( rast raster, @@ -1703,7 +1703,7 @@ CREATE OR REPLACE FUNCTION st_mapalgebraexpr(rast raster, band integer, pixeltyp expression text, nodataval double precision DEFAULT NULL) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_mapAlgebraExpr' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- This function can not be STRICT, because nodataval can be NULL -- or pixeltype can not be determined (could be st_bandpixeltype(raster, band) though) @@ -1718,7 +1718,7 @@ CREATE OR REPLACE FUNCTION st_mapalgebrafct(rast raster, band integer, pixeltype text, onerastuserfunc regprocedure, variadic args text[]) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_mapAlgebraFct' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- Variant 1: missing user args CREATE OR REPLACE FUNCTION st_mapalgebrafct(rast raster, band integer, @@ -1781,7 +1781,7 @@ CREATE OR REPLACE FUNCTION st_mapalgebraexpr( ) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_mapAlgebra2' - LANGUAGE 'C' STABLE; + LANGUAGE 'c' STABLE; CREATE OR REPLACE FUNCTION st_mapalgebraexpr( rast1 raster, @@ -1793,7 +1793,7 @@ CREATE OR REPLACE FUNCTION st_mapalgebraexpr( ) RETURNS raster AS $$ SELECT st_mapalgebraexpr($1, 1, $2, 1, $3, $4, $5, $6, $7, $8) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; CREATE OR REPLACE FUNCTION st_mapalgebrafct( rast1 raster, band1 integer, @@ -1804,7 +1804,7 @@ CREATE OR REPLACE FUNCTION st_mapalgebrafct( ) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_mapAlgebra2' - LANGUAGE 'C' STABLE; + LANGUAGE 'c' STABLE; CREATE OR REPLACE FUNCTION st_mapalgebrafct( rast1 raster, @@ -1815,7 +1815,7 @@ CREATE OR REPLACE FUNCTION st_mapalgebrafct( ) RETURNS raster AS $$ SELECT st_mapalgebrafct($1, 1, $2, 1, $3, $4, $5, VARIADIC $6) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; ----------------------------------------------------------------------- -- Neighborhood single raster map algebra @@ -1832,7 +1832,7 @@ CREATE OR REPLACE FUNCTION st_mapalgebrafctngb( ) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_mapAlgebraFctNgb' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; ----------------------------------------------------------------------- -- Neighborhood MapAlgebra processing functions. @@ -2006,7 +2006,7 @@ CREATE OR REPLACE FUNCTION _st_slope4ma(matrix float[][], nodatamode text, varia CREATE OR REPLACE FUNCTION st_slope(rast raster, band integer, pixeltype text) RETURNS RASTER AS $$ SELECT st_mapalgebrafctngb($1, $2, $3, 1, 1, '_st_slope4ma(float[][], text, text[])'::regprocedure, 'value', st_pixelwidth($1)::text, st_pixelheight($1)::text) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; CREATE OR REPLACE FUNCTION _st_aspect4ma(matrix float[][], nodatamode text, variadic args text[]) RETURNS float @@ -2040,7 +2040,7 @@ CREATE OR REPLACE FUNCTION _st_aspect4ma(matrix float[][], nodatamode text, vari CREATE OR REPLACE FUNCTION st_aspect(rast raster, band integer, pixeltype text) RETURNS RASTER AS $$ SELECT st_mapalgebrafctngb($1, $2, $3, 1, 1, '_st_aspect4ma(float[][], text, text[])'::regprocedure, 'value', st_pixelwidth($1)::text, st_pixelheight($1)::text) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; CREATE OR REPLACE FUNCTION _st_hillshade4ma(matrix float[][], nodatamode text, variadic args text[]) @@ -2088,7 +2088,7 @@ CREATE OR REPLACE FUNCTION _st_hillshade4ma(matrix float[][], nodatamode text, v CREATE OR REPLACE FUNCTION st_hillshade(rast raster, band integer, pixeltype text, azimuth float, altitude float, max_bright float DEFAULT 255.0, elevation_scale float DEFAULT 1.0) RETURNS RASTER AS $$ SELECT st_mapalgebrafctngb($1, $2, $3, 1, 1, '_st_hillshade4ma(float[][], text, text[])'::regprocedure, 'value', st_pixelwidth($1)::text, st_pixelheight($1)::text, $4::text, $5::text, $6::text, $7::text) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; CREATE OR REPLACE FUNCTION st_distinct4ma(matrix float[][], nodatamode TEXT, VARIADIC args TEXT[]) RETURNS float AS @@ -2107,12 +2107,12 @@ CREATE OR REPLACE FUNCTION st_stddev4ma(matrix float[][], nodatamode TEXT, VARIA CREATE OR REPLACE FUNCTION st_isempty(rast raster) RETURNS boolean AS 'MODULE_PATHNAME', 'RASTER_isEmpty' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_hasnoband(rast raster, nband int DEFAULT 1) RETURNS boolean AS 'MODULE_PATHNAME', 'RASTER_hasNoBand' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- Raster Band Accessors @@ -2121,12 +2121,12 @@ CREATE OR REPLACE FUNCTION st_hasnoband(rast raster, nband int DEFAULT 1) CREATE OR REPLACE FUNCTION st_bandnodatavalue(rast raster, band integer DEFAULT 1) RETURNS double precision AS 'MODULE_PATHNAME','RASTER_getBandNoDataValue' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_bandisnodata(rast raster, band integer DEFAULT 1, forceChecking boolean DEFAULT FALSE) RETURNS boolean AS 'MODULE_PATHNAME', 'RASTER_bandIsNoData' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_bandisnodata(rast raster, forceChecking boolean) RETURNS boolean @@ -2136,12 +2136,12 @@ CREATE OR REPLACE FUNCTION st_bandisnodata(rast raster, forceChecking boolean) CREATE OR REPLACE FUNCTION st_bandpath(rast raster, band integer DEFAULT 1) RETURNS text AS 'MODULE_PATHNAME','RASTER_getBandPath' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_bandpixeltype(rast raster, band integer DEFAULT 1) RETURNS text AS 'MODULE_PATHNAME','RASTER_getBandPixelTypeName' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_bandmetadata( rast raster, @@ -2153,7 +2153,7 @@ CREATE OR REPLACE FUNCTION st_bandmetadata( OUT path text ) AS 'MODULE_PATHNAME','RASTER_bandmetadata' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_bandmetadata( rast raster, @@ -2173,7 +2173,7 @@ CREATE OR REPLACE FUNCTION st_bandmetadata( CREATE OR REPLACE FUNCTION st_value(rast raster, band integer, x integer, y integer, hasnodata boolean DEFAULT TRUE) RETURNS float8 AS 'MODULE_PATHNAME','RASTER_getPixelValue' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_value(rast raster, x integer, y integer, hasnodata boolean DEFAULT TRUE) RETURNS float8 @@ -2266,37 +2266,37 @@ CREATE OR REPLACE FUNCTION st_georeference(rast raster, format text DEFAULT 'GDA CREATE OR REPLACE FUNCTION st_setscale(rast raster, scale float8) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setScale' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_setscale(rast raster, scalex float8, scaley float8) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setScaleXY' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_setskew(rast raster, skew float8) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setSkew' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_setskew(rast raster, skewx float8, skewy float8) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setSkewXY' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_setsrid(rast raster, srid integer) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setSRID' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_setupperleft(rast raster, upperleftx float8, upperlefty float8) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setUpperLeftXY' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_setrotation(rast raster, rotation float8) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setRotation' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_setgeotransform(rast raster, imag double precision, @@ -2307,7 +2307,7 @@ CREATE OR REPLACE FUNCTION st_setgeotransform(rast raster, yoffset double precision) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setGeotransform' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; ----------------------------------------------------------------------- -- Raster Editors ST_SetGeoreference() @@ -2364,7 +2364,7 @@ CREATE OR REPLACE FUNCTION st_setgeoreference(rast raster, georef text, format t CREATE OR REPLACE FUNCTION st_setbandnodatavalue(rast raster, band integer, nodatavalue float8, forceChecking boolean DEFAULT FALSE) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setBandNoDataValue' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- This function can not be STRICT, because nodatavalue can be NULL indicating that no nodata value should be set CREATE OR REPLACE FUNCTION st_setbandnodatavalue(rast raster, nodatavalue float8) @@ -2375,7 +2375,7 @@ CREATE OR REPLACE FUNCTION st_setbandnodatavalue(rast raster, nodatavalue float8 CREATE OR REPLACE FUNCTION st_setbandisnodata(rast raster, band integer DEFAULT 1) RETURNS raster AS 'MODULE_PATHNAME', 'RASTER_setBandIsNoData' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- Raster Pixel Editors @@ -2385,7 +2385,7 @@ CREATE OR REPLACE FUNCTION st_setbandisnodata(rast raster, band integer DEFAULT CREATE OR REPLACE FUNCTION st_setvalue(rast raster, band integer, x integer, y integer, newvalue float8) RETURNS raster AS 'MODULE_PATHNAME','RASTER_setPixelValue' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'c' IMMUTABLE; -- This function can not be STRICT, because newvalue can be NULL for nodata CREATE OR REPLACE FUNCTION st_setvalue(rast raster, x integer, y integer, newvalue float8) @@ -2435,7 +2435,7 @@ CREATE TYPE geomval AS ( CREATE OR REPLACE FUNCTION st_dumpaspolygons(rast raster, band integer DEFAULT 1) RETURNS SETOF geomval AS 'MODULE_PATHNAME','RASTER_dumpAsPolygons' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_polygon(rast raster, band integer DEFAULT 1) RETURNS geometry AS @@ -2443,12 +2443,12 @@ CREATE OR REPLACE FUNCTION st_polygon(rast raster, band integer DEFAULT 1) SELECT st_union(f.geom) AS singlegeom FROM (SELECT (st_dumpaspolygons($1, $2)).geom AS geom) AS f; $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_pixelaspolygon(rast raster, x integer, y integer) RETURNS geometry AS 'MODULE_PATHNAME','RASTER_getPixelPolygon' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- ST_PixelAsPolygons @@ -2763,7 +2763,7 @@ CREATE OR REPLACE FUNCTION st_raster2worldcoordy(rast raster, yr int) CREATE OR REPLACE FUNCTION st_minpossiblevalue(pixeltype text) RETURNS double precision AS 'MODULE_PATHNAME', 'RASTER_minPossibleValue' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ----------------------------------------------------------------------- -- Raster Outputs @@ -2772,12 +2772,12 @@ CREATE OR REPLACE FUNCTION st_minpossiblevalue(pixeltype text) CREATE OR REPLACE FUNCTION st_asbinary(raster) RETURNS bytea AS 'MODULE_PATHNAME', 'RASTER_to_binary' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION bytea(raster) RETURNS bytea AS 'MODULE_PATHNAME', 'RASTER_to_bytea' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; ------------------------------------------------------------------------------ -- Casts @@ -2799,84 +2799,84 @@ CREATE CAST (raster AS bytea) CREATE OR REPLACE FUNCTION raster_overleft(raster, raster) RETURNS bool AS 'select $1::geometry &< $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_overright(raster, raster) RETURNS bool AS 'select $1::geometry &> $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_left(raster, raster) RETURNS bool AS 'select $1::geometry << $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_right(raster, raster) RETURNS bool AS 'select $1::geometry >> $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_overabove(raster, raster) RETURNS bool AS 'select $1::geometry |&> $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_overbelow(raster, raster) RETURNS bool AS 'select $1::geometry &<| $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_above(raster, raster) RETURNS bool AS 'select $1::geometry |>> $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_below(raster, raster) RETURNS bool AS 'select $1::geometry <<| $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_same(raster, raster) RETURNS bool AS 'select $1::geometry ~= $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_contained(raster, raster) RETURNS bool AS 'select $1::geometry @ $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_contain(raster, raster) RETURNS bool AS 'select $1::geometry ~ $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_overlap(raster, raster) RETURNS bool AS 'select $1::geometry && $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- raster/geometry functions CREATE OR REPLACE FUNCTION raster_geometry_contain(raster, geometry) RETURNS bool AS 'select $1::geometry ~ $2' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION raster_geometry_overlap(raster, geometry) RETURNS bool AS 'select $1::geometry && $2' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; -- geometry/raster functions CREATE OR REPLACE FUNCTION geometry_raster_contain(geometry, raster) RETURNS bool AS 'select $1 ~ $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION geometry_raster_overlap(geometry, raster) RETURNS bool AS 'select $1 && $2::geometry' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; ------------------------------------------------------------------------------ -- GiST index OPERATORs @@ -2986,7 +2986,7 @@ CREATE OPERATOR && ( CREATE OR REPLACE FUNCTION st_samealignment(rast1 raster, rast2 raster) RETURNS boolean AS 'MODULE_PATHNAME', 'RASTER_sameAlignment' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION st_samealignment( ulx1 double precision, uly1 double precision, scalex1 double precision, scaley1 double precision, skewx1 double precision, skewy1 double precision, @@ -2994,24 +2994,24 @@ CREATE OR REPLACE FUNCTION st_samealignment( ) RETURNS boolean AS $$ SELECT st_samealignment(st_makeemptyraster(1, 1, $1, $2, $3, $4, $5, $6), st_makeemptyraster(1, 1, $7, $8, $9, $10, $11, $12)) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION _st_intersects(rast1 raster, nband1 integer, rast2 raster, nband2 integer) RETURNS boolean AS 'MODULE_PATHNAME', 'RASTER_intersects' - LANGUAGE 'C' IMMUTABLE STRICT + LANGUAGE 'c' IMMUTABLE STRICT COST 1000; CREATE OR REPLACE FUNCTION st_intersects(rast1 raster, nband1 integer, rast2 raster, nband2 integer) RETURNS boolean AS $$ SELECT $1 && $3 AND CASE WHEN $2 IS NULL OR $4 IS NULL THEN TRUE ELSE _st_intersects($1, $2, $3, $4) END $$ - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 1000; CREATE OR REPLACE FUNCTION st_intersects(rast1 raster, rast2 raster) RETURNS boolean AS $$ SELECT $1 && $2 AND _st_intersects($1, 1, $2, 1) $$ - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 1000; ----------------------------------------------------------------------- @@ -3047,13 +3047,13 @@ CREATE OR REPLACE FUNCTION _st_intersects(rast raster, geom geometry, nband inte CREATE OR REPLACE FUNCTION st_intersects(rast raster, geom geometry, nband integer DEFAULT NULL) RETURNS boolean AS $$ SELECT $1::geometry && $2 AND _st_intersects($1, $2, $3) $$ - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 1000; CREATE OR REPLACE FUNCTION st_intersects(rast raster, nband integer, geom geometry) RETURNS boolean AS $$ SELECT $1::geometry && $3 AND _st_intersects($1, $3, $2) $$ - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 1000; ----------------------------------------------------------------------- @@ -3195,7 +3195,7 @@ CREATE OR REPLACE FUNCTION _st_intersects(geom geometry, rast raster, nband inte CREATE OR REPLACE FUNCTION st_intersects(geom geometry, rast raster, nband integer DEFAULT NULL) RETURNS boolean AS $$ SELECT $1 && $2::geometry AND _st_intersects($1, $2, $3); $$ - LANGUAGE 'SQL' IMMUTABLE + LANGUAGE 'sql' IMMUTABLE COST 1000; ----------------------------------------------------------------------- @@ -3416,28 +3416,28 @@ CREATE OR REPLACE FUNCTION _ST_MapAlgebra4UnionState(rast1 raster,rast2 raster,b RETURNS raster AS $$ SELECT _ST_MapAlgebra4UnionState($1, ST_Band($2,$3), $4, NULL, NULL, NULL, NULL, NULL, NULL, NULL) - $$ LANGUAGE 'SQL'; + $$ LANGUAGE 'sql'; -- State function when there is no expressions but allows specifying band CREATE OR REPLACE FUNCTION _ST_MapAlgebra4UnionState(rast1 raster,rast2 raster, bandnum integer) RETURNS raster AS $$ SELECT _ST_MapAlgebra4UnionState($1,ST_Band($2,$3), 'LAST', NULL, NULL, NULL, NULL, NULL, NULL, NULL) - $$ LANGUAGE 'SQL'; + $$ LANGUAGE 'sql'; -- State function when there is no expressions and assumes band 1 CREATE OR REPLACE FUNCTION _ST_MapAlgebra4UnionState(rast1 raster,rast2 raster) RETURNS raster AS $$ SELECT _ST_MapAlgebra4UnionState($1,$2, 'LAST', NULL, NULL, NULL, NULL, NULL, NULL, NULL) - $$ LANGUAGE 'SQL'; + $$ LANGUAGE 'sql'; -- State function when there isan expressions and assumes band 1 CREATE OR REPLACE FUNCTION _ST_MapAlgebra4UnionState(rast1 raster,rast2 raster, p_expression text) RETURNS raster AS $$ SELECT _ST_MapAlgebra4UnionState($1,$2, $3, NULL, NULL, NULL, NULL, NULL, NULL, NULL) - $$ LANGUAGE 'SQL'; + $$ LANGUAGE 'sql'; -- Final function with only the primary expression CREATE OR REPLACE FUNCTION _ST_MapAlgebra4UnionFinal1(rast raster) @@ -3560,31 +3560,31 @@ CREATE OR REPLACE FUNCTION st_clip(rast raster, band int, geom geometry, nodatav CREATE OR REPLACE FUNCTION st_clip(rast raster, band int, geom geometry, nodataval double precision, crop boolean DEFAULT TRUE) RETURNS raster AS $$ SELECT ST_Clip($1, $2, $3, ARRAY[$4], $5) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; -- Variant defaulting nodataval to the one of the raster or the min possible value CREATE OR REPLACE FUNCTION st_clip(rast raster, band int, geom geometry, crop boolean) RETURNS raster AS $$ SELECT ST_Clip($1, $2, $3, null::float8[], $4) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; -- Variant defaulting to all bands CREATE OR REPLACE FUNCTION st_clip(rast raster, geom geometry, nodataval double precision[] DEFAULT NULL, crop boolean DEFAULT TRUE) RETURNS raster AS $$ SELECT ST_Clip($1, NULL, $2, $3, $4) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; -- Variant defaulting to all bands CREATE OR REPLACE FUNCTION st_clip(rast raster, geom geometry, nodataval double precision, crop boolean DEFAULT TRUE) RETURNS raster AS $$ SELECT ST_Clip($1, NULL, $2, ARRAY[$3], $4) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; -- Variant defaulting nodataval to the one of the raster or the min possible value and returning all bands CREATE OR REPLACE FUNCTION st_clip(rast raster, geom geometry, crop boolean) RETURNS raster AS $$ SELECT ST_Clip($1, NULL, $2, null::float8[], $3) $$ - LANGUAGE 'SQL' STABLE; + LANGUAGE 'sql' STABLE; ------------------------------------------------------------------------------ -- raster constraint functions diff --git a/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in.c b/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in.c index 578febb6d..f1599caa1 100644 --- a/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in.c +++ b/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in.c @@ -59,7 +59,7 @@ DROP FUNCTION IF EXISTS st_bytea(raster); CREATE OR REPLACE FUNCTION bytea(raster) RETURNS bytea AS 'MODULE_PATHNAME', 'RASTER_to_bytea' - LANGUAGE 'C' IMMUTABLE STRICT; + LANGUAGE 'c' IMMUTABLE STRICT; CREATE CAST (raster AS bytea) WITH FUNCTION bytea(raster) AS ASSIGNMENT; @@ -82,7 +82,7 @@ BEGIN CREATE OR REPLACE FUNCTION box3d(raster) RETURNS box3d AS 'SELECT box3d(st_convexhull($1))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE CAST (raster AS box3d) WITH FUNCTION box3d(raster) AS ASSIGNMENT; END IF; @@ -94,7 +94,7 @@ DROP CAST IF EXISTS (raster AS box3d); CREATE OR REPLACE FUNCTION box3d(raster) RETURNS box3d AS 'SELECT box3d(st_convexhull($1))' - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'sql' IMMUTABLE STRICT; CREATE CAST (raster AS box3d) WITH FUNCTION box3d(raster) AS ASSIGNMENT; #endif diff --git a/topology/sql/populate.sql.in.c b/topology/sql/populate.sql.in.c index 54e6bdc42..70953b6b8 100644 --- a/topology/sql/populate.sql.in.c +++ b/topology/sql/populate.sql.in.c @@ -37,7 +37,7 @@ AS $$ abs(ST_xmax($1)), abs(ST_ymax($1))), 0), 1)) )); -$$ LANGUAGE 'SQL' IMMUTABLE STRICT; +$$ LANGUAGE 'sql' IMMUTABLE STRICT; -- } -- { @@ -53,7 +53,7 @@ AS $$ topology._st_mintolerance($2)) FROM topology.topology WHERE name = $1; -$$ LANGUAGE 'SQL' STABLE STRICT; +$$ LANGUAGE 'sql' STABLE STRICT; -- } --{ diff --git a/topology/sql/topogeometry/type.sql.in.c b/topology/sql/topogeometry/type.sql.in.c index f09b9adee..d773b2b4c 100644 --- a/topology/sql/topogeometry/type.sql.in.c +++ b/topology/sql/topogeometry/type.sql.in.c @@ -31,7 +31,7 @@ $$ ELSE 'UNEXPECTED' END; $$ -LANGUAGE 'SQL' STABLE STRICT; +LANGUAGE 'sql' STABLE STRICT; -- } -- { @@ -55,5 +55,5 @@ $$ ELSE 'ST_Unexpected' END; $$ -LANGUAGE 'SQL' STABLE STRICT; +LANGUAGE 'sql' STABLE STRICT; -- } diff --git a/topology/topology.sql.in.c b/topology/topology.sql.in.c index 63dbacf94..1dc0e845c 100644 --- a/topology/topology.sql.in.c +++ b/topology/topology.sql.in.c @@ -1870,19 +1870,19 @@ LANGUAGE 'plpgsql' VOLATILE STRICT; CREATE OR REPLACE FUNCTION topology.CreateTopology(toponame varchar, srid integer, prec float8) RETURNS integer AS ' SELECT topology.CreateTopology($1, $2, $3, false);' -LANGUAGE 'SQL' VOLATILE STRICT; +LANGUAGE 'sql' VOLATILE STRICT; -- CreateTopology(name, SRID) -- precision = 0 CREATE OR REPLACE FUNCTION topology.CreateTopology(varchar, integer) RETURNS integer AS ' SELECT topology.CreateTopology($1, $2, 0); ' -LANGUAGE 'SQL' VOLATILE STRICT; +LANGUAGE 'sql' VOLATILE STRICT; -- CreateTopology(name) -- srid = unknown, precision = 0 CREATE OR REPLACE FUNCTION topology.CreateTopology(varchar) RETURNS integer AS $$ SELECT topology.CreateTopology($1, ST_SRID('POINT EMPTY'::geometry), 0); $$ -LANGUAGE 'SQL' VOLATILE STRICT; +LANGUAGE 'sql' VOLATILE STRICT; --} CreateTopology -- 2.50.1