Re: array_length()

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Decibel!" <decibel(at)decibel(dot)org>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: array_length()
Date: 2008-11-05 13:00:43
Message-ID: 491198FB.7090504@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Decibel! wrote:
> ISTM it'd be useful to have an array_length function (since I just wrote
> one for work ;), so here's a patch. Note that I don't have the docs
> toolchain setup, so I wasn't able to test the doc patches.

There is a tiny problem with this implementation: It returns null for an
empty array, not zero. This is because array_lower and/or array_upper
return null for an empty array, which makes sense for those cases. We
could fix this by putting a coalesce around the expression, but since
the array functions return null for all kinds of error cases, this might
mask other problems. Or we move to a C implementation.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gianni Ciolli 2008-11-05 13:10:58 Re: usermap regexp support
Previous Message Fujii Masao 2008-11-05 12:59:36 Re: Synchronous replication patch v1