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.