Revision 4008
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 120 | 120 |
|
| 121 | 121 |
|
| 122 | 122 |
-- |
| 123 |
-- Name: join_strs_(text, text, text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 123 |
-- Name: join_strs_transform_fold_empty(text, text, text); Type: FUNCTION; Schema: functions; Owner: -
|
|
| 124 | 124 |
-- |
| 125 | 125 |
|
| 126 |
CREATE FUNCTION join_strs_(state text, delim text, value text) RETURNS text |
|
| 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 | 129 |
SELECT $1 || (CASE |
| ... | ... | |
| 139 | 139 |
-- |
| 140 | 140 |
|
| 141 | 141 |
CREATE AGGREGATE join_strs(text, text) ( |
| 142 |
SFUNC = join_strs_, |
|
| 142 |
SFUNC = join_strs_transform_fold_empty,
|
|
| 143 | 143 |
STYPE = text, |
| 144 | 144 |
INITCOND = '' |
| 145 | 145 |
); |
Also available in: Unified diff
schemas/functions.sql: Renamed join_strs_() to join_strs_transform_fold_empty() for clarity and to indicate that it's for use by the join_strs() aggregate