Re: Are arrays broken in 7.0.3? - Mailing list pgsql-general

From Tom Lane
Subject Re: Are arrays broken in 7.0.3?
Date
Msg-id 2008.977178000@sss.pgh.pa.us
Whole thread Raw
In response to Re: Are arrays broken in 7.0.3?  (Jason Aten <jaten@CS.UCLA.EDU>)
List pgsql-general
Jason Aten <jaten@CS.UCLA.EDU> writes:
> Is there some way to find the dimensions of an array once it
> has been inserted into a table?

regression=# select array_dims(f) from arr;
 array_dims
------------
 [1:4][1:5]
(1 row)

The result is a text string, which isn't too helpful for a program;
might be nice to have some more program-friendly functions someday.

            regards, tom lane

pgsql-general by date:

Previous
From: Jason Aten
Date:
Subject: Re: Are arrays broken in 7.0.3?
Next
From: "Brett W. McCoy"
Date:
Subject: Re: a "huge" table with small rows and culumns