Project

General

Profile

« Previous | Next » 

Revision 6436

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

View differences:

schemas/vegbien.my.sql
235 235

  
236 236

  
237 237
--
238
-- Name: _or(int(1), int(1), int(1), int(1), int(1)); Type: FUNCTION; Schema: public; Owner: -
239
--
240

  
241

  
242

  
243

  
244
--
238 245
-- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: -
239 246
--
240 247

  
schemas/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