Обсуждение: how to query the size of an array in a table

Поиск
Список
Период
Сортировка

how to query the size of an array in a table

От
"Po Eddie Lim"
Дата:
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

От
Joe Conway
Дата:
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