On Thu, 2005-22-09 at 12:43 -0400, Greg Stark wrote:
> Guy Fraser <guy@incentre.net> writes:
>
> > So to answer his question he would likely want :
> >
> > SELECT
> > array_upper(item,1) - array_upper(item,0) + 1 as elements
> > FROM
> > arraytest ;
>
> Note that this doesn't work for empty arrays.
> It will return NULL instead of 0.
Your response was not at all helpfull, I would like to
encourage you to expand on what I put off the top of my
head.
I have not used array_upper() before, and the question was
how to return the total number of elements, not how to
handle NULL and empty arrays.
One could construct a fully logic compliant routine using
CASE and IF NULL to generate the type of response you want
when checking empty or NULL arrays.
If you have something to add then provide details. If you
are just trying to seem like you know more than everyone
else then don't bother posting.
