On Tue, Mar 26, 2013 at 4:39 PM, Brendan Jurd <dire...@gmail.com> wrote: > On 27 March 2013 06:47, Robert Haas <robertmh...@gmail.com> wrote: >> On Tue, Mar 26, 2013 at 9:02 AM, Brendan Jurd <dire...@gmail.com> wrote: >>> We can't sensibly test for whether an array is empty. I'd call that a >>> functional problem. >> >> Sure you can. Equality comparisons work just fine. >> >> rhaas=# select '{}'::int4[] = '{}'::int4[]; > > The good news is, if anybody out there is using that idiom to test for > emptiness, they will not be disrupted by the change.
According to the discussion downthread, apparently they will, because you're introducing an infinitude of empty arrays, not all of which compare equal to '{}'::int4. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers