On Thu, 2005-22-09 at 12:43 -0400, Greg Stark wrote: > Guy Fraser <guy@xxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
