Re: [GENERAL] string_to_array with empty input - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [GENERAL] string_to_array with empty input
Date
Msg-id 603c8f070904021137u45d298fcw9b88c2cfd78e5b6a@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] string_to_array with empty input  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] string_to_array with empty input  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Apr 2, 2009 at 2:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> On Thu, Apr 2, 2009 at 2:04 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> Right at the moment, if we stick with the historical definition
>>> of the function, *both* camps have to write out their choice of
>>> the above.  Seems like this is the worst of all possible worlds.
>>> We should probably pick one or the other.
>
>> ISTM there are three camps.
>
> If there's a camp that actually *wants* a NULL result for this case,
> I missed the reasoning.  AFAICS we can either say that every application
> is going to have to put in a CASE wrapper around this function, or say
> that we'll make it do the right thing for some of them and the rest have
> to put the same wrapper around it.

So that we don't break existing apps because of an issue that is
trivial to work around.

...Robert

pgsql-hackers by date:

Previous
From: Mokhtari Amine
Date:
Subject: Re: about hacking postgresql
Next
From: Jeff Davis
Date:
Subject: Re: [pgsql-www] Mentors needed urgently for SoC & PostgreSQL Student Internships