This probably isn't the right list but I will try here first.
This probably isn't the right list but I will try here first.
От:
Grant <grant@conprojan.com.au>
Дата:
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=#