On 2 April 2013 10:59, Robert Haas <robertmh...@gmail.com> wrote: > On Mon, Apr 1, 2013 at 6:40 PM, Brendan Jurd <dire...@gmail.com> wrote: >> It is not possible to construct e.g. '[3:2]={}' or '{{}, {}}' in >> existing applications, so there is no way for that idiom in existing >> applications to be broken by upgrading. If testing for equality with >> '{}' works now, it will also work post-upgrade. > > Sure, they've probably got to have at least > some kind of application change before the wheels really start to come > off, but as soon as some array that's empty but not equal to {} creeps > into their application by whatever means, they've got trouble.
Constructing an array with nondefault bounds isn't happening by accident, you'd have to know about, and deliberately make use of, the obscure '[m:n]={}' syntax for array literals. How is it going to "creep in"? I note the total absence of people rending their garments over the fact that '{foo}' does not equal '[2:2]={foo}'. Cheers, BJ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers