Project

General

Profile

« Previous | Next » 

Revision 7672

Moved _dms_to_dd() from schemas/vegbien.sql to schemas/functions.sql so it can use functions schema functions

View differences:

functions.sql
73 73

  
74 74

  
75 75
--
76
-- Name: _dms_to_dd(double precision, double precision, double precision); Type: FUNCTION; Schema: functions; Owner: -
77
--
78

  
79
CREATE FUNCTION _dms_to_dd(deg double precision DEFAULT NULL::double precision, min double precision DEFAULT NULL::double precision, sec double precision DEFAULT NULL::double precision) RETURNS double precision
80
    LANGUAGE sql IMMUTABLE
81
    AS $_$
82
SELECT sum(value)
83
FROM
84
(VALUES
85
      ($1)
86
    , ($2/60)
87
    , ($3/60/60)
88
)
89
AS v (value)
90
$_$;
91

  
92

  
93
--
76 94
-- Name: _eq(anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: -
77 95
--
78 96

  

Also available in: Unified diff