This probably isn't the right list but I will try here first.

From: Grant <grant(at)conprojan(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: This probably isn't the right list but I will try here first.
Date: 2001-03-05 11:28:34
Message-ID: Pine.LNX.4.21.0103052126570.31171-100000@webster.conprojan.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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=#

Browse pgsql-admin by date

  From Date Subject
Next Message Karthikeyan Shanmuganathan 2001-03-05 11:41:42 Table Size
Previous Message Lu Raymond 2001-03-05 02:43:07 There is error at the examples in PL/pgSQL