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:

vegbien.sql
418 418

  
419 419

  
420 420
--
421
-- Name: _dms_to_dd(double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: -
422
--
423

  
424
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
425
    LANGUAGE sql IMMUTABLE
426
    AS $_$
427
SELECT sum(value)
428
FROM
429
(VALUES
430
      ($1)
431
    , ($2/60)
432
    , ($3/60/60)
433
)
434
AS v (value)
435
$_$;
436

  
437

  
438
--
439 421
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: -
440 422
--
441 423

  

Also available in: Unified diff