-- Name: _merge(); Type: FUNCTION; Schema: functions; Owner: -

--

CREATE FUNCTION _merge() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    new.result := (

        SELECT DISTINCT functions.join_strs('; ', value)

        FROM

        (VALUES (new."0"), (new."1"), (new."2"), (new."3"), (new."4"),

            (new."5"), (new."6"), (new."7"), (new."8"), (new."9"))

        AS v (value)

    );

    RETURN new;

END;

$$;

--

-- Name: _merge; Type: TABLE; Schema: functions; Owner: -; Tablespace: 

--

CREATE TABLE _merge (

    result text,

    not_null_col boolean DEFAULT true NOT NULL,

    "0" text,

    "1" text,

    "2" text,

    "3" text,

    "4" text,

    "5" text,

    "6" text,

    "7" text,

    "8" text,

    "9" text

);

--

-- Name: _merge_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX _merge_unique ON _merge USING btree (ensure_not_null("0"), ensure_not_null("1"), ensure_not_null("2"), ensure_not_null("3"), ensure_not_null("4"), ensure_not_null("5"), ensure_not_null("6"), ensure_not_null("7"), ensure_not_null("8"), ensure_not_null("9"));

--

-- Name: _merge; Type: TRIGGER; Schema: functions; Owner: -

--

CREATE TRIGGER _merge BEFORE INSERT OR UPDATE ON _merge FOR EACH ROW EXECUTE PROCEDURE _merge();

--