Horton

Re: NULLs in array_cat vs array || array

Thom Brown <thom@linux.com>

View thread
From: Thom Brown <thom@linux.com>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-02-15T21:50:00Z
Lists: pgsql-hackers 
On 15 February 2011 21:46, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> 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

Ah, I see.  More to it than meets the eye.  My bad.

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