Project

General

Profile

1
--
2
-- PostgreSQL database dump
3
--
4

    
5
SET statement_timeout = 0;
6
SET client_encoding = 'UTF8';
7
SET standard_conforming_strings = off;
8
SET check_function_bodies = false;
9
SET client_min_messages = warning;
10
SET escape_string_warning = off;
11

    
12
--
13
-- Name: functions; Type: SCHEMA; Schema: -; Owner: -
14
--
15

    
16
CREATE SCHEMA functions;
17

    
18

    
19
SET search_path = functions, pg_catalog;
20

    
21
--
22
-- Name: boolean(text); Type: FUNCTION; Schema: functions; Owner: -
23
--
24

    
25
CREATE FUNCTION "boolean"(value text) RETURNS boolean
26
    LANGUAGE plpgsql IMMUTABLE
27
    AS $$
28
BEGIN
29
    BEGIN
30
        RETURN value::boolean;
31
    EXCEPTION
32
        WHEN data_exception THEN
33
            RAISE WARNING '%', SQLERRM;
34
            RETURN NULL;
35
    END;
36
    RETURN new;
37
END;
38
$$;
39

    
40

    
41
--
42
-- Name: double precision(text); Type: FUNCTION; Schema: functions; Owner: -
43
--
44

    
45
CREATE FUNCTION "double precision"(value text) RETURNS double precision
46
    LANGUAGE plpgsql IMMUTABLE
47
    AS $$
48
BEGIN
49
    BEGIN
50
        RETURN value::double precision;
51
    EXCEPTION
52
        WHEN data_exception THEN
53
            RAISE WARNING '%', SQLERRM;
54
            RETURN NULL;
55
    END;
56
    RETURN new;
57
END;
58
$$;
59

    
60

    
61
--
62
-- Name: timestamp with time zone(text); Type: FUNCTION; Schema: functions; Owner: -
63
--
64

    
65
CREATE FUNCTION "timestamp with time zone"(value text) RETURNS timestamp with time zone
66
    LANGUAGE plpgsql IMMUTABLE
67
    AS $$
68
BEGIN
69
    BEGIN
70
        RETURN value::timestamp with time zone;
71
    EXCEPTION
72
        WHEN data_exception THEN
73
            RAISE WARNING '%', SQLERRM;
74
            RETURN NULL;
75
    END;
76
    RETURN new;
77
END;
78
$$;
79

    
80

    
81
--
82
-- PostgreSQL database dump complete
83
--
84

    
(4-4/20)