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

Function: st_overlaps

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: rastA, nbandA, rastB, nbandB - Return true if raster rastA and rastB intersect but one does not completely contain the other.

 

Options

Option

Value

Returns

boolean

Language

sql

Parameters

rast1 public.raster

nband1 integer

rast2 public.raster

nband2 integer

 

Definition

CREATE OR REPLACE FUNCTION public.st_overlaps (
 rast1 public.raster,
 nband1 integer,
 rast2 public.raster,
 nband2 integer
)
RETURNS boolean AS
$span$
SELECT
$1 OPERATOR(public.&&) $3 AND CASE WHEN $2 IS NULL OR $4 IS NULL THEN public._st_overlaps(public.st_convexhull($1), public.st_convexhull($3)) ELSE public._ST_overlaps($1, $2, $3, $4) END
$span$
LANGUAGE
'sql'
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST
1000;

COMMENT ON FUNCTION public.st_overlaps(rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer)
IS 'args: rastA, nbandA, rastB, nbandB - Return true if raster rastA and rastB intersect but one does not completely contain the other.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23
Previous topic Chapter index Next topic