Re: NULLs in array_cat vs array || array

From: Thom Brown <thom(at)linux(dot)com>
To: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: NULLs in array_cat vs array || array
Date: 2011-02-15 21:50:00
Message-ID: AANLkTi=Q1SJwMvAy6cZ7jF=d1YL5=R=AQoGOS-mf0BmJ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 15 February 2011 21:46, Cédric Villemain
<cedric(dot)villemain(dot)debian(at)gmail(dot)com> wrote:
> 2011/2/15 Thom Brown <thom(at)linux(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2011-02-15 21:55:47 Re: Extensions vs PGXS' MODULE_PATHNAME handling
Previous Message Dimitri Fontaine 2011-02-15 21:49:01 Re: Extensions vs PGXS' MODULE_PATHNAME handling