Project

General

Profile

« Previous | Next » 

Revision 4009

schemas/functions.sql: Added join_strs_transform_preserve_empty() and use it in join_strs_transform_fold_empty()

View differences:

schemas/functions.sql
126 126
CREATE FUNCTION join_strs_transform_fold_empty(state text, delim text, value text) RETURNS text
127 127
    LANGUAGE sql IMMUTABLE
128 128
    AS $_$
129
SELECT functions.join_strs_transform_preserve_empty($1, $2, NULLIF($3, ''))
130
$_$;
131

  
132

  
133
--
134
-- Name: join_strs_transform_preserve_empty(text, text, text); Type: FUNCTION; Schema: functions; Owner: -
135
--
136

  
137
CREATE FUNCTION join_strs_transform_preserve_empty(state text, delim text, value text) RETURNS text
138
    LANGUAGE sql IMMUTABLE
139
    AS $_$
129 140
SELECT $1 || (CASE
130
WHEN $1 = '' OR $3 IS NULL OR $3 = ''
141
WHEN $1 = '' OR $3 IS NULL
131 142
THEN ''
132 143
ELSE $2
133 144
END) || coalesce($3, '');

Also available in: Unified diff