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

--

CREATE FUNCTION _alt() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    new.result := coalesce(new."0", new."1", new."2", new."3", new."4", new."5",

        new."6", new."7", new."8", new."9");

    RETURN new;

END;

$$;

--

-- Name: ensure_not_null(text); Type: FUNCTION; Schema: functions; Owner: -

--

CREATE FUNCTION ensure_not_null(value text) RETURNS text

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT COALESCE($1, E'\\N');

$_$;

--

SET default_tablespace = '';

SET default_with_oids = false;

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

--

CREATE TABLE _alt (

    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: _alt_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX _alt_unique ON _alt 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: _alt; Type: TRIGGER; Schema: functions; Owner: -

--

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

--