How can I obtain a count (number) of elements in a text array? Thanks.
test=# \d array
Table "array"
Attribute | Type | Modifier
--------------+---------+------------------------------------------------
id | integer | not null default nextval('array_id_seq'::text)
to_group_ids | text[] |
Index: array_pkey
test=#
--- EXAMPLE SELECT ---
test=# select to_group_ids[1] from array where id=1;
to_group_ids
--------------
1
(1 row)
test=#
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
