Arrays - Mailing list pgsql-general

From zris@somewhere.com (zris)
Subject Arrays
Date
Msg-id 381e3c1a.435675257@news.earthlink.net
Whole thread Raw
List pgsql-general
How do I get a count of the array for a given column?

ex:

    Create table test (
        name text,
        in        integer,
        props text[][] );

    insert into test values ('Chris',1,'{{"Add","1
Stree"},{"SSN","123-123-1231"},{"Hello","Hello"}');

Is there a way of finding the count of the number of props, the array
that is?
Also is there a collection class?
thanks
Chris



pgsql-general by date:

Previous
From: "moribund"
Date:
Subject: Re: CASE WHEN examples
Next
From: Charles Tassell
Date:
Subject: Re: [GENERAL] users in Postgresql