Re: [HACKERS] string_to_array with empty input

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <stark(at)enterprisedb(dot)com>
Cc: Sam Mason <sam(at)samason(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] string_to_array with empty input
Date: 2009-03-31 15:37:16
Message-ID: 10720.1238513836@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Greg Stark <stark(at)enterprisedb(dot)com> writes:
> On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
>> string_to_array('',',')::INT[] => invalid input syntax for integer: ""

> Oof. That's a good point.

Isn't that an argument in favor of the zero-size-array definition?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-03-31 15:45:28 Re: Server Performance
Previous Message Marcin Krol 2009-03-31 15:35:58 weird problem with PG 8.1

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2009-03-31 15:37:36 Re: Fwd: Abwesend: [GENERAL] string_to_array with empty input
Previous Message Sam Mason 2009-03-31 15:34:01 Re: string_to_array with empty input