length of array

From: "Chris Faulkner" <chrisf(at)oramap(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: length of array
Date: 2003-08-27 19:49:12
Message-ID: DGENKIKMJILAAKJGFHKFCEMNCGAA.chrisf@oramap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello

Is there a function in postgres to return the length of an array field ? I
have seen array_dims(array) but this returns a character value. Ideally, I'd
like something numeric returned.

Thanks

Chris

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-08-27 19:51:26 Re: One-2-many relation - need distinct counts
Previous Message scott.marlowe 2003-08-27 15:31:12 Re: Canceling other backend's query