postgis -  functions -  public.find_extent

Description

Function properties

Usage

result = public.find_extent();

Code

CREATE FUNCTION find_extent(text, text, text) RETURNS box2d
    AS $_$
DECLARE
    schemaname alias for $1;
    tablename alias for $2;
    columnname alias for $3;
    myrec RECORD;

BEGIN
    FOR myrec IN EXECUTE 'SELECT extent("'||columnname||'") FROM "'||schemaname||'"."'||tablename||'"' LOOP
        return myrec.extent;
    END LOOP; 
END;
$_$
    LANGUAGE plpgsql IMMUTABLE STRICT;