I know that postgresql array implementation is not right complete and that if just
one element of array is NULL the basics array function (array_dims, array_upper, etc.) returns NULL.
I need to send a list of parameters (which could contain NULL values) and evaluate the parameters excluding NULL values
is this possible?
any suggestion?
It's not true. Dimensions are stored independent to content.

postgres=# create or replace function foo(int[])
returns int as $$
declare s int = 0; i integer;
begin
for i in select generate_subscripts($1,1)
loop
s := s + coalesce($1[i],0);
end loop;
return s;
end;
$$ language plpgsql;
CREATE FUNCTION
postgres=# select foo(array[1,2]);
foo
─────
3
(1 row)

postgres=# select foo(array[1,2, null, 3]);
foo
─────
6
(1 row)

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedOct 21, '09 at 8:37a
activeOct 21, '09 at 2:39p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase