view schema/updates/1201/01.fix_support_functions.sql @ 4855:01b593ea2311

Added missing doc strings for the STR tree in the mesh package.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 19 Nov 2019 17:48:02 +0100
parents 8fcabb6f971e
children
line wrap: on
line source

CREATE OR REPLACE FUNCTION isrslt(a isrs, b isrs) RETURNS boolean
AS $$
BEGIN
    RETURN public.isrs_cmp(a, b) < 0;
END;
$$ LANGUAGE plpgsql
    IMMUTABLE PARALLEL SAFE;

CREATE OR REPLACE FUNCTION isrsle(a isrs, b isrs) RETURNS boolean
AS $$
BEGIN
    RETURN public.isrs_cmp(a, b) <= 0;
END;
$$ LANGUAGE plpgsql
    IMMUTABLE PARALLEL SAFE;

CREATE OR REPLACE FUNCTION isrseq(a isrs, b isrs) RETURNS boolean
AS $$
BEGIN
    RETURN public.isrs_cmp(a, b) = 0;
END;
$$ LANGUAGE plpgsql
    IMMUTABLE PARALLEL SAFE;

CREATE OR REPLACE FUNCTION isrsge(a isrs, b isrs) RETURNS boolean
AS $$
BEGIN
    RETURN public.isrs_cmp(a, b) >= 0;
END;
$$ LANGUAGE plpgsql
    IMMUTABLE PARALLEL SAFE;

CREATE OR REPLACE FUNCTION isrsgt(a isrs, b isrs) RETURNS boolean
AS $$
BEGIN
    RETURN public.isrs_cmp(a, b) > 0;
END;
$$ LANGUAGE plpgsql
    IMMUTABLE PARALLEL SAFE;

CREATE OR REPLACE FUNCTION isrs_diff(a isrs, b isrs) RETURNS double precision
AS $$
    SELECT CAST(public.isrs_cmp(a, b) AS double precision)
$$ LANGUAGE sql
    IMMUTABLE PARALLEL SAFE;