Revision 10321
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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
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.