--

-- PostgreSQL database dump

--

SET statement_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = off;

SET check_function_bodies = false;

SET client_min_messages = warning;

SET escape_string_warning = off;

--

-- Name: functions; Type: SCHEMA; Schema: -; Owner: -

--

CREATE SCHEMA functions;

SET search_path = functions, pg_catalog;

--

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

--

CREATE FUNCTION "_toBool"() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    BEGIN

        new.result := CAST(new.value AS boolean);

    EXCEPTION

        WHEN data_exception THEN

            new.result := NULL;

            RAISE WARNING '%', SQLERRM;

    END;

    RETURN new;

END;

$$;

--

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

--

CREATE FUNCTION "_toDouble"() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    BEGIN

        new.result := CAST(new.value AS double precision);

    EXCEPTION

        WHEN data_exception THEN

            new.result := NULL;

            RAISE WARNING '%', SQLERRM;

    END;

    RETURN new;

END;

$$;

--

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

--

CREATE FUNCTION "_toTimestamp"() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    BEGIN

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

    EXCEPTION

        WHEN data_exception THEN

            new.result := NULL;

            RAISE WARNING '%', SQLERRM;

    END;

    RETURN new;

END;

$$;

SET default_tablespace = '';

SET default_with_oids = false;

--

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

--

CREATE TABLE "_toBool" (

    result boolean,

    not_null boolean DEFAULT true NOT NULL,

    value text

);

--

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

--

CREATE TABLE "_toDouble" (

    result double precision,

    not_null boolean DEFAULT true NOT NULL,

    value text

);

--

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

--

CREATE TABLE "_toTimestamp" (

    result timestamp with time zone,

    not_null boolean DEFAULT true NOT NULL,

    value text

);

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

-- PostgreSQL database dump complete

--