On 1/12/14, 5:53 AM, I wrote:
> On 1/9/14, 2:57 PM, Dean Rasheed wrote:
>> How it should behave for multi-dimensional arrays is less clear, but
>> I'd argue that it should return the total number of elements, i.e.
>> cardinality('{{1,2},{3,4}}'::int[][]) = 4. That would make it
>> consistent with the choices we've already made for unnest() and
>> ordinality:
>> - cardinality(foo) = (select count(*) from unnest(foo)).
>> - unnest with ordinality would always result in ordinals in the range
>> [1, cardinality].
>
> Ignoring my proposal, this seems like the most reasonable option. I'll
> send an updated patch along these lines.
Here's the patch as promised. Thoughts?
Regards,
Marko Tiikkaja