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

Function: st_pixelofvalue

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: rast, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value.

 

Options

Option

Value

Returns

Set of record

Language

sql

Parameters

rast public.raster

search double precision []

exclude_nodata_value boolean = true

out val double precision

out x integer

out y integer

 

Definition

CREATE OR REPLACE FUNCTION public.st_pixelofvalue (
 rast public.raster,
 search double precision [],
 exclude_nodata_value boolean = true,
 out val double precision,
 out x integer,
 out y integer
)
RETURNS SETOF record AS
$span$
SELECT
val, x, y FROM public.ST_pixelofvalue($1, 1, $2, $3)
$span$
LANGUAGE
'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100 ROWS 1000;

COMMENT ON FUNCTION public.st_pixelofvalue(rast public.raster, search double precision [], exclude_nodata_value boolean, out val double precision, out x integer, out y integer)
IS 'args: rast, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value.';

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