Postgres Pro
Downloads
Home   >   mailing lists

NULLs in array_cat vs array || array - Mailing list pgsql-hackers

From Thom Brown
Subject NULLs in array_cat vs array || array
Date
Msg-id AANLkTikeJMQY9aELpbQVWPqoeToDnGi6uW3=F8cm_D6G@mail.gmail.com
Whole thread Raw
Responses Re: NULLs in array_cat vs array || array  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Re: NULLs in array_cat vs array || array  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: FOR KEY LOCK foreign keys
Next
From: Cédric Villemain
Date:
Subject: Re: NULLs in array_cat vs array || array