[BUGS] BUG #4921: ltree @> ltree[] operator shouldn't fail if ltree[] is empty

2009-07-15 Thread Alan Pinstein
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

Re: [BUGS] BUG #4921: ltree @> ltree[] operator shouldn't fail if ltree[] is empty

2009-07-15 Thread Alan Pinstein
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

Re: [BUGS] BUG #4921: ltree @> ltree[] operator shouldn't fail if ltree[] is empty

2009-07-15 Thread Alan Pinstein
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