Postgres Pro
Downloads
Home   >   mailing lists

Re: how to query the size of an array in a table - Mailing list pgsql-general

From Joe Conway
Subject Re: how to query the size of an array in a table
Date
Msg-id 413BEA56.2040100@joeconway.com
Whole thread Raw
In response to how to query the size of an array in a table  ("Po Eddie Lim" <eddiepo@ntsp.nec.co.jp>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: One Database per Data File?
Next
From: "Philippe Lang"
Date:
Subject: DROP TRIGGER permission