You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
23 lines
626 B
23 lines
626 B
return: text
|
|
lang: plpgsql
|
|
parameters:
|
|
p0:
|
|
type: text
|
|
name: i_liste
|
|
src: |
|
|
DECLARE
|
|
_liste text;
|
|
|
|
BEGIN
|
|
_liste = i_liste;
|
|
_liste = trim(translate(COALESCE(_liste,''),'"' || chr(9) || chr(10) || chr(13),' '));
|
|
_liste = replace(_liste,' ',' ');
|
|
_liste = replace(_liste,' ',' ');
|
|
_liste = replace(_liste,' ',' ');
|
|
_liste = replace(_liste,' ',' ');
|
|
_liste = (SELECT coalesce(base.cti_group_concat_without_sep(code || ' '), '')
|
|
FROM
|
|
(SELECT code FROM base.cti_unnest(string_to_array(_liste,' ')) AS code ORDER BY 1) subview
|
|
);
|
|
RETURN _liste ;
|
|
END;
|