Changeset: 29e3ee2d2223 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=29e3ee2d2223 Modified Files: sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 Branch: geo Log Message:
approved systemfunctions test diffs (truncated from 1132 to 300 lines): diff --git a/sql/test/Tests/systemfunctions.stable.out b/sql/test/Tests/systemfunctions.stable.out --- a/sql/test/Tests/systemfunctions.stable.out +++ b/sql/test/Tests/systemfunctions.stable.out @@ -58,7 +58,7 @@ Ready. % sys.L3, sys.L3, sys.L3, sys.L3, sys.L3 # table_name % schema, function, argno, argtype, definition # name % varchar, varchar, int, varchar, varchar # type -% 4, 35, 2, 15, 1336 # length +% 4, 35, 2, 12, 2482 # length [ "bam", "bam_drop_file", 0, "bigint", "create procedure bam.bam_drop_file(file_id bigint, dbschema smallint)\nexternal name bam.bam_drop_file;" ] [ "bam", "bam_drop_file", 1, "smallint", "" ] [ "bam", "bam_export", 0, "clob", "create procedure bam.bam_export(output_path string)\nexternal name bam.bam_export;" ] @@ -129,12 +129,6 @@ Ready. [ "json", "tojsonarray", 1, "double", "" ] [ "json", "valuearray", 0, "json", "create function json.valuearray(js json)\nreturns json external name json.valuearray;" ] [ "json", "valuearray", 1, "json", "" ] -[ "sys", "Intersect", 0, "boolean", "create function \"Intersect\"(a geometry, b geometry) returns boolean external name geom.\"Intersect\";" ] -[ "sys", "Intersect", 1, "geometry", "" ] -[ "sys", "Intersect", 2, "geometry", "" ] -[ "sys", "Union", 0, "geometry", "create function \"Union\"(a geometry, b geometry) returns geometry external name geom.\"Union\";" ] -[ "sys", "Union", 1, "geometry", "" ] -[ "sys", "Union", 2, "geometry", "" ] [ "sys", "abbrev", 0, "clob", "create function \"abbrev\" (p inet) returns clob\n\texternal name inet.\"abbrev\";" ] [ "sys", "abbrev", 1, "inet", "" ] [ "sys", "alpha", 0, "double", "create function alpha(pdec double, pradius double)\nreturns double external name sql.alpha;" ] @@ -156,10 +150,6 @@ Ready. [ "sys", "analyze", 1, "clob", "" ] [ "sys", "analyze", 2, "clob", "" ] [ "sys", "analyze", 3, "bigint", "" ] -[ "sys", "area", 0, "double", "-- ogc Spatial Analysis methods\n\ncreate function area(g geometry) returns float external name geom.\"Area\";" ] -[ "sys", "area", 1, "geometry", "" ] -[ "sys", "astext", 0, "clob", "create function astext(g geometry) returns string external name geom.\"AsText\";" ] -[ "sys", "astext", 1, "geometry", "" ] [ "sys", "bbp", 0, "int", "-- The BAT buffer pool overview\ncreate function sys.bbp () \n\treturns table (id int, name string, htype string, \n\t\tttype string, count bigint, refcnt int, lrefcnt int, \n\t\tlocation string, heat int, dirty string, \n\t\tstatus string, kind string) \n\texternal name bbp.get;" ] [ "sys", "bbp", 1, "clob", "" ] [ "sys", "bbp", 2, "clob", "" ] @@ -172,13 +162,8 @@ Ready. [ "sys", "bbp", 9, "clob", "" ] [ "sys", "bbp", 10, "clob", "" ] [ "sys", "bbp", 11, "clob", "" ] -[ "sys", "boundary", 0, "geometry", "create function boundary(g geometry) returns geometry external name geom.\"Boundary\";" ] -[ "sys", "boundary", 1, "geometry", "" ] [ "sys", "broadcast", 0, "inet", "create function \"broadcast\" (p inet) returns inet \n\texternal name inet.\"broadcast\";" ] [ "sys", "broadcast", 1, "inet", "" ] -[ "sys", "buffer", 0, "geometry", "create function buffer(a geometry, distance float) returns geometry external name geom.\"Buffer\";" ] -[ "sys", "buffer", 1, "geometry", "" ] -[ "sys", "buffer", 2, "double", "" ] [ "sys", "chi2prob", 0, "double", "-- This Source Code Form is subject to the terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n-- (co) Arjen de Rijke, Bart Scheers\n-- Use statistical functions from gsl library\n\n-- Calculate Chi squared probability\ncreate function sys.chi2prob(chi2 double, datapoints double)\nreturns double external name gsl.\"chi2prob\";" ] [ "sys", "chi2prob", 1, "double", "" ] [ "sys", "chi2prob", 2, "double", "" ] @@ -186,14 +171,9 @@ Ready. [ "sys", "columnsize", 1, "clob", "" ] [ "sys", "columnsize", 2, "bigint", "" ] [ "sys", "columnsize", 3, "bigint", "" ] -[ "sys", "contains", 0, "boolean", "create function contains(a geometry, b geometry) returns boolean external name geom.\"Contains\";" ] -[ "sys", "contains", 1, "geometry", "" ] -[ "sys", "contains", 2, "geometry", "" ] [ "sys", "convert", 0, "date", "create function \"convert\"(s string, format string) returns date\n\texternal name mtime.\"str_to_date\";" ] [ "sys", "convert", 1, "clob", "" ] [ "sys", "convert", 2, "clob", "" ] -[ "sys", "convexhull", 0, "geometry", "create function convexhull(a geometry) returns geometry external name geom.\"ConvexHull\";" ] -[ "sys", "convexhull", 1, "geometry", "" ] [ "sys", "corr", 0, "tinyint", "create aggregate corr(e1 tinyint, e2 tinyint) returns tinyint\n\texternal name \"aggr\".\"corr\";" ] [ "sys", "corr", 1, "tinyint", "" ] [ "sys", "corr", 2, "tinyint", "" ] @@ -275,21 +255,8 @@ Ready. [ "sys", "dependencies_views_on_triggers", 0, "varchar", "--View v has a dependency on trigger tri\ncreate function dependencies_views_on_triggers()\nreturns table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select v.name, tri.name, 'DEP_TRIGGER' from tables as v, triggers as tri, dependencies as dep where dep.id = v.id and dep.depend_id =tri.id and dep.depend_type = 8 and v.type = 1);" ] [ "sys", "dependencies_views_on_triggers", 1, "varchar", "" ] [ "sys", "dependencies_views_on_triggers", 2, "varchar", "" ] -[ "sys", "difference", 0, "geometry", "create function difference(a geometry, b geometry) returns geometry external name geom.\"Difference\";" ] -[ "sys", "difference", 1, "geometry", "" ] -[ "sys", "difference", 2, "geometry", "" ] -[ "sys", "dimension", 0, "int", "-- CREATE FUNCTION Point(g Geometry) RETURNS Point external name geom.point;\n-- CREATE FUNCTION Curve(g Geometry) RETURNS Curve external name geom.curve;\n-- CREATE FUNCTION LineString(g Geometry) RETURNS LineString external name geom.linestring;\n-- CREATE FUNCTION Surface(g Geometry) RETURNS Surface external name geom.surface;\n-- CREATE FUNCTION Polygon(g Geometry) RETURNS Polygon external name geom.polygon;\n\n-- ogc basic methods\ncreate function dimension(g geometry) returns integer external name geom.\"Dimension\";" ] -[ "sys", "dimension", 1, "geometry", "" ] -[ "sys", "disjoint", 0, "boolean", "create function disjoint(a geometry, b geometry) returns boolean external name geom.\"Disjoint\";" ] -[ "sys", "disjoint", 1, "geometry", "" ] -[ "sys", "disjoint", 2, "geometry", "" ] -[ "sys", "distance", 0, "double", "create function distance(a geometry, b geometry) returns float external name geom.\"Distance\";" ] -[ "sys", "distance", 1, "geometry", "" ] -[ "sys", "distance", 2, "geometry", "" ] [ "sys", "env", 0, "varchar", "CREATE FUNCTION env () RETURNS TABLE( name varchar(1024), value varchar(2048)) EXTERNAL NAME sql.sql_environment;" ] [ "sys", "env", 1, "varchar", "" ] -[ "sys", "envelope", 0, "geometry", "create function envelope(g geometry) returns geometry external name geom.\"Envelope\";" ] -[ "sys", "envelope", 1, "geometry", "" ] [ "sys", "environment", 0, "clob", "-- The environment table\ncreate function sys.environment()\n\treturns table (\"name\" string, value string)\n\texternal name sql.sql_environment;" ] [ "sys", "environment", 1, "clob", "" ] [ "sys", "epoch", 0, "timestamp", "-- This Source Code Form is subject to the terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n-- assume milliseconds when converted to TIMESTAMP\ncreate function \"epoch\"(sec bigint) returns timestamp\n\texternal name timestamp.\"epoch\";" ] @@ -298,9 +265,6 @@ Ready. [ "sys", "epoch", 1, "int", "" ] [ "sys", "epoch", 0, "int", "create function \"epoch\"(ts timestamp) returns int\n\texternal name timestamp.\"epoch\";" ] [ "sys", "epoch", 1, "timestamp", "" ] -[ "sys", "equals", 0, "boolean", "-- ogc spatial relation methods\ncreate function equals(a geometry, b geometry) returns boolean external name geom.\"Equals\";" ] -[ "sys", "equals", 1, "geometry", "" ] -[ "sys", "equals", 2, "geometry", "" ] [ "sys", "evalalgebra", 0, "clob", "create procedure sys.evalalgebra( ra_stmt string, opt bool)\n\texternal name sql.\"evalAlgebra\";" ] [ "sys", "evalalgebra", 1, "boolean", "" ] [ "sys", "fitsattach", 0, "clob", "create procedure fitsattach(fname string) external name fits.attach;" ] @@ -384,6 +348,8 @@ Ready. [ "sys", "gethost", 1, "url", "" ] [ "sys", "getport", 0, "clob", "create function getport(theurl url) returns string \n\texternal name url.\"getPort\";" ] [ "sys", "getport", 1, "url", "" ] +[ "sys", "getproj4", 0, "clob", "--CREATE FUNCTION ST_SetPoint RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_SnapToGrid RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Snap RETURNS EXTERNAL NAME\ncreate function getproj4(srid_in integer) returns string \nbegin\n\treturn select proj4text from spatial_ref_sys where srid=srid_in; \nend;" ] +[ "sys", "getproj4", 1, "int", "" ] [ "sys", "getprotocol", 0, "clob", "create function getprotocol(theurl url) returns string \n\texternal name url.\"getProtocol\";" ] [ "sys", "getprotocol", 1, "url", "" ] [ "sys", "getquery", 0, "clob", "create function getquery(theurl url) returns string \n\texternal name url.\"getQuery\";" ] @@ -392,6 +358,10 @@ Ready. [ "sys", "getroboturl", 1, "url", "" ] [ "sys", "getuser", 0, "clob", "create function getuser(theurl url) returns string \n\texternal name url.\"getUser\";" ] [ "sys", "getuser", 1, "url", "" ] +[ "sys", "has_m", 0, "int", "create function has_m(info integer) returns integer external name geom.\"hasM\";" ] +[ "sys", "has_m", 1, "int", "" ] +[ "sys", "has_z", 0, "int", "-- This Source Code Form is subject to the terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n-- make sure you load the geom module before loading this sql module\n-- create spatial_ref_sys metadata table\n\ncreate function has_z(info integer) returns integer external name geom.\"hasZ\";" ] +[ "sys", "has_z", 1, "int", "" ] [ "sys", "hashsize", 0, "bigint", "create function sys.hashsize(b boolean, i bigint)\nreturns bigint\nbegin\n\t-- assume non-compound keys\n\tif b = true\n\tthen\n\t\treturn 8 * i;\n\tend if;\n\treturn 0;\nend;" ] [ "sys", "hashsize", 1, "boolean", "" ] [ "sys", "hashsize", 2, "bigint", "" ] @@ -411,45 +381,36 @@ Ready. [ "sys", "imprintsize", 0, "bigint", "create function sys.imprintsize(i bigint, nme string)\nreturns bigint\nbegin\n\tif nme = 'boolean'\n\t\tor nme = 'tinyint'\n\t\tor nme = 'smallint'\n\t\tor nme = 'int'\t\n\t\tor nme = 'bigint'\t\n\t\tor nme = 'hugeint'\t\n\t\tor nme = 'decimal'\t\n\t\tor nme = 'date'\n\t\tor nme = 'timestamp'\n\t\tor nme = 'real'\n\t\tor nme = 'double'\n\tthen\n\t\treturn cast( i * 0.12 as bigint);\n\tend if ;\n\treturn 0;\nend;" ] [ "sys", "imprintsize", 1, "bigint", "" ] [ "sys", "imprintsize", 2, "clob", "" ] -[ "sys", "intersection", 0, "geometry", "create function intersection(a geometry, b geometry) returns geometry external name geom.\"Intersection\";" ] -[ "sys", "intersection", 1, "geometry", "" ] -[ "sys", "intersection", 2, "geometry", "" ] +[ "sys", "internaltransform", 0, "geometry", "create function internaltransform(geom geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest string) returns geometry external name geom.\"Transform\";" ] +[ "sys", "internaltransform", 1, "geometry", "" ] +[ "sys", "internaltransform", 2, "int", "" ] +[ "sys", "internaltransform", 3, "int", "" ] +[ "sys", "internaltransform", 4, "clob", "" ] +[ "sys", "internaltransform", 5, "clob", "" ] [ "sys", "isaurl", 0, "boolean", "create function isaurl(theurl url) returns bool\n\texternal name url.\"isaURL\";" ] [ "sys", "isaurl", 1, "url", "" ] [ "sys", "isauuid", 0, "uuid", "create function sys.isauuid(u uuid)\nreturns uuid external name uuid.\"isaUUID\";" ] [ "sys", "isauuid", 1, "uuid", "" ] [ "sys", "isauuid", 0, "uuid", "create function sys.isauuid(u string)\nreturns uuid external name uuid.\"isaUUID\";" ] [ "sys", "isauuid", 1, "clob", "" ] -[ "sys", "isempty", 0, "boolean", "create function isempty(g geometry) returns boolean external name geom.\"IsEmpty\";" ] -[ "sys", "isempty", 1, "geometry", "" ] -[ "sys", "issimple", 0, "boolean", "create function issimple(g geometry) returns boolean external name geom.\"IsSimple\";" ] -[ "sys", "issimple", 1, "geometry", "" ] [ "sys", "left_shift", 0, "boolean", "create function \"left_shift\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<\";" ] [ "sys", "left_shift", 1, "inet", "" ] [ "sys", "left_shift", 2, "inet", "" ] [ "sys", "left_shift_assign", 0, "boolean", "create function \"left_shift_assign\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<=\";" ] [ "sys", "left_shift_assign", 1, "inet", "" ] [ "sys", "left_shift_assign", 2, "inet", "" ] -[ "sys", "length", 0, "double", "create function length(g geometry) returns float external name geom.\"Length\";" ] -[ "sys", "length", 1, "geometry", "" ] [ "sys", "like", 0, "clob", "-- This Source Code Form is subject to the terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate filter function \"like\"(val string, pat string, esc string) external name algebra.\"like\";" ] [ "sys", "like", 1, "clob", "" ] [ "sys", "like", 2, "clob", "" ] [ "sys", "like", 0, "clob", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";" ] [ "sys", "like", 1, "clob", "" ] -[ "sys", "linefromtext", 0, "linestring", "create function linefromtext(wkt string, srid smallint) returns linestring external name geom.\"LineFromText\";" ] -[ "sys", "linefromtext", 1, "clob", "" ] -[ "sys", "linefromtext", 2, "smallint", "" ] [ "sys", "listdir", 0, "clob", "\n\ncreate procedure listdir(dirname string) external name fits.listdir;" ] [ "sys", "listdirpat", 0, "clob", "create procedure listdirpat(dirname string,pat string) external name fits.listdirpattern;" ] [ "sys", "listdirpat", 1, "clob", "" ] [ "sys", "masklen", 0, "int", "create function \"masklen\" (p inet) returns int\n\texternal name inet.\"masklen\";" ] [ "sys", "masklen", 1, "inet", "" ] -[ "sys", "mbr", 0, "mbr", "-- currently we only use mbr instead of\n-- Envelope():Geometry\n-- as that returns Geometry objects, and we prefer the explicit mbr's\n-- minimum bounding rectangle (mbr)\ncreate function mbr (g geometry) returns mbr external name geom.mbr;" ] +[ "sys", "mbr", 0, "mbr", "-- currently we only use mbr instead of\n-- Envelope():Geometry\n-- as that returns Geometry objects, and we prefer the explicit mbr's\n-- minimum bounding rectangle (mbr)\ncreate function mbr(geom geometry) returns mbr external name geom.\"mbr\";" ] [ "sys", "mbr", 1, "geometry", "" ] -[ "sys", "mbroverlaps", 0, "boolean", "create function mbroverlaps(a mbr, b mbr) returns boolean external name geom.\"mbroverlaps\";" ] -[ "sys", "mbroverlaps", 1, "mbr", "" ] -[ "sys", "mbroverlaps", 2, "mbr", "" ] [ "sys", "md5", 0, "clob", "-- This Source Code Form is subject to the terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n-- (co) Arjen de Rijke\n\ncreate function sys.md5(v string)\nreturns string external name clients.md5sum;" ] [ "sys", "md5", 1, "clob", "" ] [ "sys", "median", 0, "tinyint", "create aggregate median(val tinyint) returns tinyint\n\texternal name \"aggr\".\"median\";" ] @@ -520,25 +481,10 @@ Ready. [ "sys", "optimizers", 0, "clob", "-- MONETDB KERNEL SECTION\n-- optimizer pipe catalog\ncreate function sys.optimizers () \n\treturns table (name string, def string, status string)\n\texternal name sql.optimizers;" ] [ "sys", "optimizers", 1, "clob", "" ] [ "sys", "optimizers", 2, "clob", "" ] -[ "sys", "overlaps", 0, "boolean", "create function overlaps(a geometry, b geometry) returns boolean external name geom.\"Overlaps\";" ] -[ "sys", "overlaps", 1, "geometry", "" ] -[ "sys", "overlaps", 2, "geometry", "" ] [ "sys", "password_hash", 0, "clob", "-- This Source Code Form is subject to the terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate function sys.password_hash (username string) \n\treturns string \n\texternal name sql.password;" ] [ "sys", "password_hash", 1, "clob", "" ] [ "sys", "pause", 0, "int", "-- operations to manipulate the state of havoc queries\ncreate procedure sys.pause(tag int)\nexternal name sql.sysmon_pause;" ] [ "sys", "pause", 0, "bigint", "create procedure sys.pause(tag bigint)\nexternal name sql.sysmon_pause;" ] -[ "sys", "point", 0, "point", "create function point(x double,y double) returns point external name geom.point;" ] -[ "sys", "point", 1, "double", "" ] -[ "sys", "point", 2, "double", "" ] -[ "sys", "pointfromtext", 0, "point", "create function pointfromtext(wkt string, srid smallint) returns point external name geom.\"PointFromText\";" ] -[ "sys", "pointfromtext", 1, "clob", "" ] -[ "sys", "pointfromtext", 2, "smallint", "" ] -[ "sys", "polyfromtext", 0, "polygon", "create function polyfromtext(wkt string, srid smallint) returns polygon external name geom.\"PolyFromText\";" ] -[ "sys", "polyfromtext", 1, "clob", "" ] -[ "sys", "polyfromtext", 2, "smallint", "" ] -[ "sys", "polygonfromtext", 0, "polygon", "-- alias\ncreate function polygonfromtext(wkt string, srid smallint) returns polygon external name geom.\"PolyFromText\";" ] -[ "sys", "polygonfromtext", 1, "clob", "" ] -[ "sys", "polygonfromtext", 2, "smallint", "" ] [ "sys", "profiler_openstream", 0, "clob", "create procedure profiler_openstream(host string, port int) external name profiler.\"openStream\";" ] [ "sys", "profiler_openstream", 1, "int", "" ] [ "sys", "profiler_stethoscope", 0, "int", "create procedure profiler_stethoscope(ticks int) external name profiler.stethoscope;" ] @@ -606,10 +552,6 @@ Ready. [ "sys", "queue", 7, "clob", "" ] [ "sys", "radians", 0, "double", "create function radians(d double) \nreturns double\n\treturn d*pi()/180;" ] [ "sys", "radians", 1, "double", "" ] -[ "sys", "relate", 0, "boolean", "create function relate(a geometry, b geometry, pattern string) returns boolean external name geom.\"Relate\";" ] -[ "sys", "relate", 1, "geometry", "" ] -[ "sys", "relate", 2, "geometry", "" ] -[ "sys", "relate", 3, "clob", "" ] [ "sys", "resume", 0, "int", "create procedure sys.resume(tag int)\nexternal name sql.sysmon_resume;" ] [ "sys", "resume", 0, "bigint", "create procedure sys.resume(tag bigint)\nexternal name sql.sysmon_resume;" ] [ "sys", "reuse", 0, "clob", "create procedure reuse(sys string, tab string)\n\texternal name sql.reuse;" ] @@ -640,8 +582,311 @@ Ready. [ "sys", "shutdown", 0, "tinyint", "create procedure sys.shutdown(delay tinyint) \nexternal name sql.shutdown;" ] [ "sys", "shutdown", 0, "tinyint", "create procedure sys.shutdown(delay tinyint, force bool) \nexternal name sql.shutdown;" ] [ "sys", "shutdown", 1, "boolean", "" ] -[ "sys", "srid", 0, "int", "create function srid(g geometry) returns integer external name geom.\"SRID\";" ] -[ "sys", "srid", 1, "geometry", "" ] +[ "sys", "st_area", 0, "double", "create function st_area(geom geometry) returns double external name geom.\"Area\";" ] +[ "sys", "st_area", 1, "geometry", "" ] +[ "sys", "st_asbinary", 0, "clob", "--Obtainig WKB from Geometry\ncreate function st_asbinary(geom geometry) returns string external name geom.\"AsBinary\";" ] +[ "sys", "st_asbinary", 1, "geometry", "" ] +[ "sys", "st_asewkt", 0, "clob", "--CREATE FUNCTION ST_TransScale RETURNS EXTERNAL NAME\n\n-------------------------------------------------------------------------\n--------------------------- Geometry Outputs ----------------------------\n-------------------------------------------------------------------------\n--CREATE FUNCTION ST_AsEWKB RETURNS EXTERNAL NAME\ncreate function st_asewkt(geom geometry) returns string external name geom.\"AsEWKT\";" ] +[ "sys", "st_asewkt", 1, "geometry", "" ] +[ "sys", "st_astext", 0, "clob", "--Obtaining WKT from Geometry\ncreate function st_astext(geom geometry) returns string external name geom.\"AsText\";" ] +[ "sys", "st_astext", 1, "geometry", "" ] +[ "sys", "st_bdmpolyfromtext", 0, "geometry", "create function st_bdmpolyfromtext(wkt string, srid integer) returns geometry external name geom.\"BdMPolyFromText\";" ] +[ "sys", "st_bdmpolyfromtext", 1, "clob", "" ] +[ "sys", "st_bdmpolyfromtext", 2, "int", "" ] +[ "sys", "st_bdpolyfromtext", 0, "geometry", "create function st_bdpolyfromtext(wkt string, srid integer) returns geometry external name geom.\"BdPolyFromText\";" ] +[ "sys", "st_bdpolyfromtext", 1, "clob", "" ] +[ "sys", "st_bdpolyfromtext", 2, "int", "" ] +[ "sys", "st_boundary", 0, "geometry", "create function st_boundary(geom geometry) returns geometry external name geom.\"Boundary\";" ] +[ "sys", "st_boundary", 1, "geometry", "" ] +[ "sys", "st_buffer", 0, "geometry", "create function st_buffer(geom geometry, radius double) returns geometry external name geom.\"Buffer\";" ] +[ "sys", "st_buffer", 1, "geometry", "" ] +[ "sys", "st_buffer", 2, "double", "" ] +[ "sys", "st_centroid", 0, "geometry", "--Functions on Surface (i.e. Polygon and Polyhedral Surface) and MultiSurface\ncreate function st_centroid(geom geometry) returns geometry external name geom.\"Centroid\";" ] +[ "sys", "st_centroid", 1, "geometry", "" ] +[ "sys", "st_collect", 0, "geometry", "--CREATE FUNCTION ST_3DLength RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Length_Spheroid RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Length2D_Spheroid RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DLength_Spheroid RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_LongestLine RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_OrderingEquals RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Perimeter RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Perimeter2D RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DPerimeter RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Project RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Relate(geom1 Geometry, geom2 Geometry) RETURNS string EXTERNAL NAME geom.\"Relate\";\n--CREATE FUNCTION ST_Relate(geom1 Geometry, geom2 Geometry, boundary_node_rule integer) RETURNS string EXTERNAL NAME geom.\"Relate\";\n--CREATE FUNCTION ST_RelateMatch RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_ShortestLine RETURNS EXTERNAL NAME\n\n------------------------------- ------------------------------------------\n------------------------- Geometry Processing ---------------------------\n-------------------------------------------------------------------------\n--CREATE FUNCTION ST_Buffer(geom Geometry, radius double, circle_quarters_num integer) RETURNS Geometry EXTERNAL NAME geom.\"Buffer\";\n--CREATE FUNCTION ST_Buffer(geom Geometry, radius double, buffer_style_parameters string) RETURNS Geometry EXTERNAL NAME geom.\"Buffer\";\n--CREATE FUNCTION ST_Buffer(geog Geography, radius double) RETURNS Geometry EXTERNAL NAME geom.\"Buffer\";\n--CREATE FUNCTION ST_BuildArea RETURNS EXTERNAL NAME\n--collect is the same to union. POstGIS just has a more efficient implementation for it compared to union\ncreate function st_collect(geom1 geometry, geom2 geometry) returns geometry external name geom.\"Union\";" ] +[ "sys", "st_collect", 1, "geometry", "" ] +[ "sys", "st_collect", 2, "geometry", "" ] +[ "sys", "st_collect", 0, "geometry", "create aggregate st_collect(geom geometry) returns geometry external name geom.\"Union\";" ] +[ "sys", "st_collect", 1, "geometry", "" ] +[ "sys", "st_contains", 0, "boolean", "create function st_contains(box1 mbr, box2 mbr) returns boolean external name geom.\"mbrContains\";" ] +[ "sys", "st_contains", 1, "mbr", "" ] +[ "sys", "st_contains", 2, "mbr", "" ] +[ "sys", "st_contains", 0, "boolean", "create function st_contains(geom1 geometry, geom2 geometry) returns boolean external name geom.\"Contains\";" ] +[ "sys", "st_contains", 1, "geometry", "" ] +[ "sys", "st_contains", 2, "geometry", "" ] +[ "sys", "st_convexhull", 0, "geometry", "create function st_convexhull(geom geometry) returns geometry external name geom.\"ConvexHull\";" ] +[ "sys", "st_convexhull", 1, "geometry", "" ] +[ "sys", "st_coorddim", 0, "int", "create function st_coorddim(geom geometry) returns integer external name geom.\"CoordDim\";" ] +[ "sys", "st_coorddim", 1, "geometry", "" ] +[ "sys", "st_coveredby", 0, "boolean", "--CREATE FUNCTION ST_Covers(geog1 Geography, geog2 Geography) RETURNS boolean EXTERNAL NAME geom.\"Covers\";\ncreate function st_coveredby(geom1 geometry, geom2 geometry) returns boolean external name geom.\"CoveredBy\";" ] +[ "sys", "st_coveredby", 1, "geometry", "" ] +[ "sys", "st_coveredby", 2, "geometry", "" ] +[ "sys", "st_covers", 0, "boolean", "--CREATE FUNCTION ST_AsGeoJSON RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_AsGML RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_AsHEXEWKB RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_AsKML RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_AsSVG RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_AsX3D RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_GeoHash RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_AsLatLonText RETURNS EXTERNAL NAME\n\n-------------------------------------------------------------------------\n------------------------------ Operators --------------------------------\n-------------------------------------------------------------------------\n\n-------------------------------------------------------------------------\n---------------- Spatial Relationships and Measurements -----------------\n-------------------------------------------------------------------------\n--CREATE FUNCTION ST_3DClosestPoint RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DDistanc e RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DDWithin RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DDFullyWithin RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DIntersects RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DLongestLine RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DMaxDistance RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_3DShortestLine RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Area(geog Geography, use_spheroid boolean) RETURNS flt EXTERNAL NAME geom.\"Area\";\n--CREATE FUNCTION ST_Azimuth RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_ClosestPoint RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_ContainsProperly RETURNS EXTERNAL NAME\ncreate function st_covers(geom1 geometry, geom2 geometry) returns boolean external name geom.\"Covers\";" ] +[ "sys", "st_covers", 1, "geometry", "" ] +[ "sys", "st_covers", 2, "geometry", "" ] +[ "sys", "st_crosses", 0, "boolean", "create function st_crosses(geom1 geometry, geom2 geometry) returns boolean external name geom.\"Crosses\";" ] +[ "sys", "st_crosses", 1, "geometry", "" ] +[ "sys", "st_crosses", 2, "geometry", "" ] +[ "sys", "st_delaunaytriangles", 0, "geometry", "--CREATE FUNCTION ST_ConcaveHull RETURNS EXTERNAL NAME\ncreate function st_delaunaytriangles(geom geometry, tolerance double, flags integer) returns geometry external name geom.\"DelaunayTriangles\";" ] +[ "sys", "st_delaunaytriangles", 1, "geometry", "" ] +[ "sys", "st_delaunaytriangles", 2, "double", "" ] +[ "sys", "st_delaunaytriangles", 3, "int", "" ] +[ "sys", "st_difference", 0, "geometry", "create function st_difference(geom1 geometry, geom2 geometry) returns geometry external name geom.\"Difference\";" ] +[ "sys", "st_difference", 1, "geometry", "" ] +[ "sys", "st_difference", 2, "geometry", "" ] +[ "sys", "st_dimension", 0, "int", "--Functions on Geometries\ncreate function st_dimension(geom geometry) returns integer external name geom.\"Dimension\";" ] +[ "sys", "st_dimension", 1, "geometry", "" ] +[ "sys", "st_disjoint", 0, "boolean", "create function st_disjoint(geom1 geometry, geom2 geometry) returns boolean external name geom.\"Disjoint\";" ] +[ "sys", "st_disjoint", 1, "geometry", "" ] +[ "sys", "st_disjoint", 2, "geometry", "" ] +[ "sys", "st_distance", 0, "double", "create function st_distance(box1 mbr, box2 mbr) returns double external name geom.\"mbrDistance\";" ] +[ "sys", "st_distance", 1, "mbr", "" ] +[ "sys", "st_distance", 2, "mbr", "" ] +[ "sys", "st_distance", 0, "double", "--Distance between Geometries\ncreate function st_distance(geom1 geometry, geom2 geometry) returns double external name geom.\"Distance\";" ] +[ "sys", "st_distance", 1, "geometry", "" ] +[ "sys", "st_distance", 2, "geometry", "" ] +[ "sys", "st_dump", 0, "int", "create function st_dump(geom geometry) returns table(id integer, polygonwkb geometry) external name geom.\"Dump\";" ] +[ "sys", "st_dump", 1, "geometry", "" ] +[ "sys", "st_dump", 2, "geometry", "" ] +[ "sys", "st_dumppoints", 0, "clob", "create function st_dumppoints(geom geometry) returns table(path string, pointg geometry) external name geom.\"DumpPoints\";" ] +[ "sys", "st_dumppoints", 1, "geometry", "" ] +[ "sys", "st_dumppoints", 2, "geometry", "" ] +[ "sys", "st_dwithin", 0, "boolean", "--CREATE FUNCTION ST_CoveredBy(geog1 Geography, geog2 Geography) RETURNS boolean EXTERNAL NAME geom.\"CoveredBy\";\n--CREATE FUNCTION ST_LineCrossingDirection RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Distance(geog1 Geometry, geog2 Geometry) RETURNS double EXTERNAL NAME geom.\"Distance\"\n--CREATE FUNCTION ST_Distance(geog1 Geometry, geog2 Geometry, use_spheroid boolean) RETURNS double EXTERNAL NAME geom.\"Distance\"\ncreate function st_dwithin(geom1 geometry, geom2 geometry, dst double) returns boolean external name geom.\"DWithin\";" ] +[ "sys", "st_dwithin", 1, "geometry", "" ] +[ "sys", "st_dwithin", 2, "geometry", "" ] +[ "sys", "st_dwithin", 3, "double", "" ] +[ "sys", "st_endpoint", 0, "geometry", "create function st_endpoint(geom geometry) returns geometry external name geom.\"EndPoint\";" ] +[ "sys", "st_endpoint", 1, "geometry", "" ] +[ "sys", "st_envelope", 0, "geometry", "create function st_envelope(geom geometry) returns geometry external name geom.\"Envelope\";" ] +[ "sys", "st_envelope", 1, "geometry", "" ] +[ "sys", "st_equals", 0, "boolean", "create function st_equals(box1 mbr, box2 mbr) returns boolean external name geom.\"mbrEqual\";" ] +[ "sys", "st_equals", 1, "mbr", "" ] +[ "sys", "st_equals", 2, "mbr", "" ] +[ "sys", "st_equals", 0, "boolean", "--Functions testing spatial relations between Geometries\ncreate function st_equals(geom1 geometry, geom2 geometry) returns boolean external name geom.\"Equals\";" ] +[ "sys", "st_equals", 1, "geometry", "" ] +[ "sys", "st_equals", 2, "geometry", "" ] +[ "sys", "st_exteriorring", 0, "geometry", "--Functions on Polygon\ncreate function st_exteriorring(geom geometry) returns geometry external name geom.\"ExteriorRing\";" ] +[ "sys", "st_exteriorring", 1, "geometry", "" ] +[ "sys", "st_force2d", 0, "geometry", "--GEOS creates only 2D Envelope\n--CREATE FUNCTION ST_ZMax(geom Geometry) RETURNS double EXTERNAL NAME geom.\"ZMaxFromWKB\";\n--CREATE FUNCTION ST_ZMax(box mbr) RETURNS double EXTERNAL NAME geom.\"ZMaxFromMBR\";\n--CREATE FUNCTION ST_ZMin(geom Geometry) RETURNS double EXTERNAL NAME geom.\"ZMinFromWKB\";\n--CREATE FUNCTION ST_ZMin(box mbr) RETURNS double EXTERNAL NAME geom.\"ZMinFromMBR\";\n--CREATE FUNCTION ST_Zmflag(geom Geometry) RETURNS smallint EXTERNAL NAME --0=2d, 1=3dm, 2=3dz, 4=4d\n\n-------------------------------------------------------------------------\n--------------------------- Geometry Editors ----------------------------\n-------------------------------------------------------------------------\n--CREATE FUNCTION ST_AddPoint RETURNS EXTERNAL NAME\n--CREATE FUNCTION ST_Affine RETURNS EXTERNAL NAME\ncreate function st_force2d(geom geometry) returns geometry external name geom.\"Force2D\";" ] +[ "sys", "st_force2d", 1, "geometry", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
