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