Was this ever addressed? ---------------------------------------------------------------------------
Tom Lane wrote: > "Alan Pinstein" <apinst...@mac.com> writes: > > ... hierarchy @> ARRAY(select hierarchy from > > feature where description ilike '%pool%this%') ... > > > EXPECTED BEHAVIOR: > > - return 0 rows > > > ACTUAL BEHAVIOR: > > ERROR: array must be one-dimensional > > Possibly from: > > https://projects.commandprompt.com/public/replicator/browser/trunk/contrib/ltree/_ltree_op.c?rev=1905 > > line 46 > > > NOTES: > > This query worked in 8.1.x and started failing in 8.3.6 (only 2 versions I > > tested). > > 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. > > I can see two reasonable ways to address this: > > * Change the ltree test to reject only ARR_NDIM > 1. > > * Drop the ARR_NDIM check altogether, and let it search any sort of > array. > > I'm leaning to #2 myself. However, there are probably other places with > the same kind of issue, and in some of them it might make more sense to > reject multidimensional arrays. > > regards, tom lane > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
