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

Function: st_band

 

 

Schema

public

 

Owner

albenard

 

Descriptions

args: rast, nbands, delimiter=, - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.

 

Options

Option

Value

Returns

public.raster

Language

sql

Parameters

rast public.raster

nbands text

delimiter char = ','::bpchar

 

Definition

CREATE OR REPLACE FUNCTION public.st_band (
 rast public.raster,
 nbands text,
 delimiter char = ','::bpchar
)
RETURNS public.raster AS
$span$
SELECT  public
.ST_band($1, regexp_split_to_array(regexp_replace($2, '[[:space:]]', '', 'g'), E'\\' || array_to_string(regexp_split_to_array($3, ''), E'\\'))::int[])
$span$
LANGUAGE
'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_band(rast public.raster, nbands text, delimiter char)
IS 'args: rast, nbands, delimiter=, - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.';

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