NULLs in array_cat vs array || array

From: Thom Brown <thom(at)linux(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: NULLs in array_cat vs array || array
Date: 2011-02-15 21:37:21
Message-ID: AANLkTikeJMQY9aELpbQVWPqoeToDnGi6uW3=F8cm_D6G@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
array_cat_nulls.patch application/octet-stream 874 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Cédric Villemain 2011-02-15 21:46:09 Re: NULLs in array_cat vs array || array
Previous Message Alvaro Herrera 2011-02-15 21:32:45 Re: FOR KEY LOCK foreign keys