Revision 7672
Added by Aaron Marcuse-Kubitza over 11 years ago
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
Moved _dms_to_dd() from schemas/vegbien.sql to schemas/functions.sql so it can use functions schema functions