Re: array size

[Dmitriy Igrishin <dmitigr@xxxxxxxxx>]

Hey,

2011/2/24 akp geek <akpgeek@xxxxxxxxx>

Hi all -

ÂÂ Â Â Â Â Â ÂI am trying to find the number of elements in the array. Right now I am using array_upper and array_lower. Is there any other way of getting the number of elements?

You may use array_length() function, e.g.
dmitigr=> SELECT array_length(ARRAY[ARRAY[1,2,3],ARRAY[4,5,6]], 1);
Âarray_length
--------------
ÂÂÂÂÂÂÂÂÂÂÂ 2
(1 row)

dmitigr=> SELECT array_length(ARRAY[ARRAY[1,2,3],ARRAY[4,5,6]], 2);
Âarray_length
--------------
ÂÂÂÂÂÂÂÂÂÂÂ 3
(1 row)

See http://www.postgresql.org/docs/9.0/static/functions-array.html

thanks for the help

Regards

-- 
// Dmitriy.