On Jun 11, 2013, at 3:09 PM, Brendan Jurd <dire...@gmail.com> wrote: > There have been attempts to add a cardinality function in the past, as > it is required by the SQL spec, but these attempts have stalled when > trying to decide how it should handle multidim arrays. Having it > return the length of the first dimension is the more spec-compatible > way to go, but some folks argued that it should work as > ArrayGetNItems, because we don't already have a function for that at > the SQL level. Therefore I propose we add cardinality() per the spec, > and another function to expose ArrayGetNItems. > > And that's about where we got to, when the whole discussion was put on > a time-out to make room for the beta. > > I am withdrawing the original zero-D patch in favour of the proposed > new functions. If you have an opinion about that, please do chime in. > Depending on how that goes I may post a patch implementing my new > proposal in the next few days.
+1 to this proposal. Modulo function names, perhaps. I don’t much care what they're called, as long as the work as you describe here. Best, David Array Complainer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers