public._group_concat

Documentation	Pagila
Schema	public
Name	_group_concat
Module	Functions

Concatenate text (coma separated).

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$

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