pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr

Function: st_dfullywithin

Schema

public

Owner

albenard

Descriptions

args: g1, g2, distance - Returns true if all of the geometries are within the specified distance of one another

Options

Definition

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

COMMENT ON FUNCTION public.st_dfullywithin(geom1 public.geometry, geom2 public.geometry, double precision)
IS 'args: g1, g2, distance - Returns true if all of the geometries are within the specified distance of one another';

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