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

--

CREATE FUNCTION _label() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    new.result := (SELECT new.label+': '+new.value);

    RETURN new;

END;

$$;

--

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

--

CREATE TABLE _label (

    result text,

    not_null_col boolean DEFAULT true NOT NULL,

    label text,

    value text

);

--

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

--

CREATE UNIQUE INDEX _label_unique ON _label USING btree (ensure_not_null(label), ensure_not_null(value));

--

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

--

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

--