pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Function: st_intersects

 

 

Schema

public

 

Owner

albenard

 

Descriptions

args: geomA, geomB - Returns TRUE if the Geometries/Geography "spatially intersect in 2D" - (share any portion of space) and FALSE if they dont (they are Disjoint). For geography -- tolerance is 0.00001 meters (so any points that close are considered to intersect)

 

Options

Option

Value

Returns

boolean

Language

sql

Parameters

geom1 public.geometry

geom2 public.geometry

 

Definition

CREATE OR REPLACE FUNCTION public.st_intersects (
 geom1 public.geometry,
 geom2 public.geometry
)
RETURNS boolean AS
$span$
SELECT
$1 OPERATOR(public.&&) $2 AND public._ST_Intersects($1,$2)
$span$
LANGUAGE
'sql'
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_intersects(geom1 public.geometry, geom2 public.geometry)
IS 'args: geomA, geomB - Returns TRUE if the Geometries/Geography "spatially intersect in 2D" - (share any portion of space) and FALSE if they dont (they are Disjoint). For geography -- tolerance is 0.00001 meters (so any points that close are considered to intersect)';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51
Previous topic Chapter index Next topic