Revision 7659
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 186 | 186 |
|
| 187 | 187 |
|
| 188 | 188 |
-- |
| 189 |
-- Name: _dms_to_dd(double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: - |
|
| 190 |
-- |
|
| 191 |
|
|
| 192 |
|
|
| 193 |
|
|
| 194 |
|
|
| 195 |
-- |
|
| 189 | 196 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 190 | 197 |
-- |
| 191 | 198 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 406 | 406 |
|
| 407 | 407 |
|
| 408 | 408 |
-- |
| 409 |
-- Name: _dms_to_dd(double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: - |
|
| 410 |
-- |
|
| 411 |
|
|
| 412 |
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 |
|
| 413 |
LANGUAGE sql IMMUTABLE |
|
| 414 |
AS $_$ |
|
| 415 |
SELECT sum(value) |
|
| 416 |
FROM |
|
| 417 |
(VALUES |
|
| 418 |
($1) |
|
| 419 |
, ($2/60) |
|
| 420 |
, ($3/60/60) |
|
| 421 |
) |
|
| 422 |
AS v (value) |
|
| 423 |
$_$; |
|
| 424 |
|
|
| 425 |
|
|
| 426 |
-- |
|
| 409 | 427 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 410 | 428 |
-- |
| 411 | 429 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added _dms_to_dd()