Postgres Pro
Downloads
Home   >   mailing lists

length of array - Mailing list pgsql-sql

From Chris Faulkner
Subject length of array
Date
Msg-id DGENKIKMJILAAKJGFHKFCEMNCGAA.chrisf@oramap.com
Whole thread Raw
Responses Re: length of array
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: One-2-many relation - need distinct counts
Next
From: Joe Conway
Date:
Subject: Re: How to return a record set from function.