The following bug has been logged online:
Bug reference: 4921
Logged by: Alan Pinstein
Email address: apinst...@mac.com
PostgreSQL version: 8.3.6
Operating system: linux/centos 5.3
Description:ltree @> ltree[] operator shouldn't fail if ltree[] is
empty
Hmm. ltree has always had that ARR_NDIM == 1 check. I think the
reason
the behavior changed is that ARRAY(SELECT ...) used to return a NULL
for
zero rows, and now it returns an empty (zero-dimensional) array.
Ah OK that makes sense, especially given the "hack" I used as a
workaround, whi
Yeah, and I don't feel I know enough to answer that.
Thanks for responding! Good luck with your decision.
Regards,
Alan
On Jul 15, 2009, at 11:33 AM, Tom Lane wrote:
Alan Pinstein writes:
The real solution might be to just convert a 0-dim array into "null"
or equivalent a