On Thu, Apr 02, 2009 at 12:06:01PM -0700, David E. Wheeler wrote: > 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? Sorry, I meant to type string_to_array but typed array_to_string instead---after doing exactly the same thing when searching for stuff in Google! I think I should be using copy/paste more! -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general