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

From Cédric Villemain
Subject Re: NULLs in array_cat vs array || array
Date
Msg-id AANLkTinX0AmpYWr0j1hutgftxaFDbObx+K8OT3o0K1D5@mail.gmail.com
Whole thread Raw
In response to NULLs in array_cat vs array || array  (Thom Brown <thom@linux.com>)
Responses Re: NULLs in array_cat vs array || array  (Thom Brown <thom@linux.com>)
List pgsql-hackers
2011/2/15 Thom Brown <thom@linux.com>:
> 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.

There is bugreport and todo entry for that if it helps:

http://archives.postgresql.org/pgsql-bugs/2008-11/msg00032.php


>
> 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
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>



--
Cédric Villemain               2ndQuadrant
http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: NULLs in array_cat vs array || array
Next
From: Tom Lane
Date:
Subject: Re: NULLs in array_cat vs array || array