blob: c9722827baf86f05f365017761a57c6f04484e9e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
CREATE FUNCTION _api.trim(
_text TEXT
)
RETURNS TEXT
LANGUAGE plpgsql VOLATILE
AS $BODY$
DECLARE
_new TEXT;
BEGIN
IF _text IS NULL THEN
RETURN NULL;
END IF;
_new = _text;
_new = TRIM(_new);
_new = REGEXP_REPLACE(_new, '^(?: |\r|\n)*', '');
_new = REGEXP_REPLACE(_new, '(?: |\r|\n)*$', '');
RETURN _new;
END
$BODY$;
GRANT EXECUTE ON FUNCTION _api.trim(TEXT)
TO rest_anon, rest_user;
|
