--

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

--

CREATE FUNCTION "_toTimestamp"() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    new.result := CAST(new.value AS timestamp with time zone);

    RETURN new;

END;

$$;

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

--

CREATE TABLE "_toTimestamp" (

    result timestamp with time zone,

    value text

);

--

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

--

CREATE UNIQUE INDEX "_toTimestamp_unique" ON "_toTimestamp" USING btree ((COALESCE(value, '\\N'::text)));

--

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

--

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

--