pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr

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

Definition

CREATE OR REPLACE FUNCTION public.st_count (
 rastertable text,
 rastercolumn text,
 exclude_nodata_value boolean
)
RETURNS bigint AS
$span$
SELECT _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