NULLs in array_cat vs array || array

Thom Brown <thom@linux.com>

From: Thom Brown <thom@linux.com>

To: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2011-02-15T21:37:21Z

Lists: pgsql-hackers

Attachments

array_cat_nulls.patch (application/octet-stream) patch

Hi all,

I assumed array_cat would behave similarly to array || array, but it
appears not when it comes to NULLs.  Shouldn't these have identical
functionality?  The attached patch makes it so, although it would
break existing code.

Would such a change have any knock-on effect, or cause inconsistency
with other functions?

Thanks

Thom

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935