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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
