Schema
Owner
postgres
Descriptions
There is no description for function st_min4ma
Options
Option | Value |
---|---|
Returns |
double precision |
Language |
|
Parameters |
matrix double precision [] nodatamode text variadic args text [] |
Definition
CREATE OR REPLACE FUNCTION public.st_min4ma (
matrix double precision [],
nodatamode text,
variadic args text []
)
RETURNS double precision AS
$span$
DECLARE
_matrix float[][];
min float;
BEGIN
_matrix := matrix;
min := 'Infinity'::float;
FOR x in array_lower(_matrix, 1)..array_upper(_matrix, 1) LOOP
FOR y in array_lower(_matrix, 2)..array_upper(_matrix, 2) LOOP
IF _matrix[x][y] IS NULL THEN
IF NOT nodatamode = 'ignore' THEN
_matrix[x][y] := nodatamode::float;
END IF;
END IF;
IF min > _matrix[x][y] THEN
min := _matrix[x][y];
END IF;
END LOOP;
END LOOP;
RETURN min;
END;
$span$
LANGUAGE 'plpgsql'
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |