Re: cardinality()

On 1 Mar 2009, at 00:52, Andrew Dunstan wrote:

>
> We seem to have acquired a cardinality() function with almost no  
> discussion, and it has semantics that are a bit surprising to me. I  
> should have thought cardinality(array) would be the total number of  
> elements in the array. Instead, it seems it is a synonym for  
> array_length(array,1). Is that *really* what the standard says?

any difference between array_upper(array,1), and cardinality ?
Standart just says something like:

cardinality (a collection):
- The number of elements in that collection.
- Those elements need not necessarily have distinct values.
- The objects to which this concept applies includes tables and the  
values of collection types.