| From: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
|---|---|
| To: | akp geek <akpgeek(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: array size |
| Date: | 2011-02-24 21:08:52 |
| Message-ID: | AANLkTimroWdjrfcDkqT4BX4c+iuXhDHcv6ZCVm00o94M@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hey,
2011/2/24 akp geek <akpgeek(at)gmail(dot)com>
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksey Tsalolikhin | 2011-02-24 21:11:44 | Re: database is bigger after dump/restore - why? (60 GB to 109 GB) |
| Previous Message | Gauthier, Dave | 2011-02-24 20:12:09 | Re: regexp problem |