-- Name: datatype; Type: TYPE; Schema: functions; Owner: -

--

CREATE TYPE datatype AS ENUM (

    'str',

    'float'

);

--

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

--

CREATE FUNCTION "_nullIf"() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    IF new.result = 'str' THEN -- no cast needed

        new.result := (SELECT nullif(new.value, new."null"));

    -- Invalid value -> warning, but invalid null value -> error

    ELSIF new.result = 'float' THEN

        new.result := (SELECT nullif(functions."double precision"(new.value),

            new."null"::double precision));

    END IF;

    RETURN new;

END;

$$;

--

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

--

CREATE TABLE "_nullIf" (

    result text,

    not_null_col boolean DEFAULT true NOT NULL,

    "null" text,

    type datatype DEFAULT 'str'::datatype NOT NULL,

    value text

);

--

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

--

CREATE UNIQUE INDEX "_nullIf_unique" ON "_nullIf" USING btree (ensure_not_null("null"), type, ensure_not_null(value));

--

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

--

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

--