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

2004-09-05 Thread 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

[GENERAL] how to query the size of an array in a table

2004-09-05 Thread 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