Project

General

Profile

« Previous | Next » 

Revision 6436

schemas/vegbien.sql: public: Added _or(), for use by analytical_stem_view

View differences:

vegbien.sql
507 507

  
508 508

  
509 509
--
510
-- Name: _or(boolean, boolean, boolean, boolean, boolean); Type: FUNCTION; Schema: public; Owner: -
511
--
512

  
513
CREATE FUNCTION _or("0" boolean DEFAULT NULL::boolean, "1" boolean DEFAULT NULL::boolean, "2" boolean DEFAULT NULL::boolean, "3" boolean DEFAULT NULL::boolean, "4" boolean DEFAULT NULL::boolean) RETURNS boolean
514
    LANGUAGE sql IMMUTABLE
515
    AS $_$
516
SELECT bool_or(value)
517
FROM
518
(VALUES
519
      ($1)
520
    , ($2)
521
    , ($3)
522
    , ($4)
523
    , ($5)
524
)
525
AS v (value)
526
$_$;
527

  
528

  
529
--
510 530
-- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: -
511 531
--
512 532

  

Also available in: Unified diff