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

[Joe Conway]

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

Po Eddie Lim wrote:[color=blue]
> 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?[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org