Re: [HACKERS] string_to_array with empty input

On Apr 2, 2009, at 11:24 AM, Sam Mason wrote:

> Yes, I'd be tempted to pick one and go with it. It's seems a
> completely
> arbitrary choice one way or the other but the current behaviour is
> certainly wrong.
>
> I'd go with returning a zero element array because it would do
> the "right thing" more often when paired with array_to_string.
> I've also been through the first few pages of a Google search for
> "array_to_string" and it seems to do the "right" thing for the
> majority
> of the cases.

Forgive me if I'm missing something, but it seems to me that
array_to_string() works either way, no?

try=# select '"' || array_to_string('{}'::text[], ',') || '"'; ?column?
----------
""
(1 row)

Time: 72.129 ms
try=# select '"' || array_to_string('{""}'::text[], ',') || '"';
?column?
----------
""
(1 row)

Best,

David