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

Function: st_distance

 

 

Schema

public

 

Owner

albenard

 

Descriptions

args: g1, g2 - For geometry type Returns the 2D Cartesian distance between two geometries in projected units (based on spatial ref). For geography type defaults to return minimum geodesic distance between two geographies in meters.

 

Options

Option

Value

Returns

double precision

Language

c

Parameters

geom1 public.geometry

geom2 public.geometry

 

Definition

CREATE OR REPLACE FUNCTION public.st_distance (
 geom1 public.geometry,
 geom2 public.geometry
)
RETURNS double precision AS
'$libdir/postgis-2.3', 'distance'
LANGUAGE 'c'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
25;

COMMENT ON FUNCTION public.st_distance(geom1 public.geometry, geom2 public.geometry)
IS 'args: g1, g2 - For geometry type Returns the 2D Cartesian distance between two geometries in projected units (based on spatial ref). For geography type defaults to return minimum geodesic distance between two geographies in meters.';

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