2011/9/14 Bob Pawley <rjpawley(at)shaw(dot)ca>
> Hi
>
> Is there a method of counting the number of elements in an array??
>
>
Yes...
Use function array_upper [1].
See an example:
postgres(at)bdteste=# SELECT array_upper(ARRAY['foo', 'bar'], 1);
array_upper
-------------
2
(1 row)
[1] http://www.postgresql.org/docs/current/interactive/functions-array.html
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello