how to query the size of an array in a table
Started by Po Eddie Limover 21 years ago2 messagesgeneral
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
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