Postgres Pro
Downloads
Home   >   mailing lists

Thread: how to query the size of an array in a table

how to query the size of an array in a table

From
"Po Eddie Lim"
Date:
Hello...

 Is it possible in PostGre 7.3 to query the size of a text[] array attribute
 of a table? Does anyone know how this is queried in 7.3?

 thanks... help is greatly needed.
 eddie

Re: how to query the size of an array in a table

From
Joe Conway
Date:
Po Eddie Lim wrote:
>  Is it possible in PostGre 7.3 to query the size of a text[] array attribute
>  of a table? Does anyone know how this is queried in 7.3?

It isn't well documented, and not convenient to use, but see
array_dims() function on this page:
http://www.postgresql.org/docs/7.3/interactive/arrays.html

Array support and documentation is significantly better in 7.4.x.

Joe