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

From: Joe Conway <mail(at)joeconway(dot)com>
To: Po Eddie Lim <eddiepo(at)ntsp(dot)nec(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to query the size of an array in a table
Date: 2004-09-06 04:40:54
Message-ID: 413BEA56.2040100@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2004-09-06 08:23:49 DROP TRIGGER permission
Previous Message Randy Yates 2004-09-06 04:02:48 Re: One Database per Data File?