Project

General

Profile

« Previous | Next » 

Revision 10321

bugfix: schemas/util.sql: array_length(anyarray): need to call util.array_length() instead of just array_length() (which uses pg_catalog.array_length()) so that empty arrays will be returned as 0 instead of NULL. note that for some reason, adding `SET search_path=util` to the function does not have the same effect.

View differences:

schemas/util.sql
567 567
CREATE FUNCTION array_length("array" anyarray) RETURNS integer
568 568
    LANGUAGE sql IMMUTABLE STRICT
569 569
    AS $_$
570
SELECT array_length($1, 1)
570
SELECT util.array_length($1, 1)
571 571
$_$;
572 572

  
573 573

  

Also available in: Unified diff