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

Function: st_count

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: rastertable, rastercolumn, exclude_nodata_value - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value.

 

Options

Option

Value

Returns

bigint

Language

sql

Parameters

rastertable text

rastercolumn text

exclude_nodata_value boolean

 

Definition

CREATE OR REPLACE FUNCTION public.st_count (
 rastertable text,
 rastercolumn text,
 exclude_nodata_value boolean
)
RETURNS bigint AS
$span$
SELECT public
._ST_count($1, $2, 1, $3, 1)
$span$
LANGUAGE
'sql'
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_count(rastertable text, rastercolumn text, exclude_nodata_value boolean)
IS 'args: rastertable, rastercolumn, exclude_nodata_value - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata 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