public._group_concat
Documentation | Pagila |
Schema | public |
Name | _group_concat |
Module | Functions |
Input/Output
Mode | Name | Data type | Description | |
---|---|---|---|---|
1 | OUT | Returns | text | Concatenate text. |
Concatenate text. | ||||
2 | IN | $1 | text | First part of text. |
First part of text. | ||||
3 | IN | $2 | text | Second part of text. |
Second part of text. |
Script
CREATE OR REPLACE FUNCTION public._group_concat(text, text) RETURNS text LANGUAGE sql IMMUTABLE AS $function$ SELECT CASE WHEN $2 IS NULL THEN $1 WHEN $1 IS NULL THEN $2 ELSE $1 || ', ' || $2 END $function$ |
Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25