Thread: Annoying "split to array" function inconsistency...best way to fix?

Annoying "split to array" function inconsistency...best way to fix?

From
"David G. Johnston"
Date:
Two functions exists that convert "text" to "text[]"

regexp_string_to_array(text, text [,text]) : http://www.postgresql.org/docs/9.4/interactive/functions-string.html

Would it be hateful to make it so that both entries appear on both tables?

array_to_string(anyarray, text [,text]) could be lumped in with this as well.

string_to_array not being on the string functions page is the more glaring omission for me.

David J.

Re: Annoying "split to array" function inconsistency...best way to fix?

From
Tom Lane
Date:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Two functions exists that convert "text" to "text[]"
> regexp_string_to_array(text, text [,text]) :
> http://www.postgresql.org/docs/9.4/interactive/functions-string.html
> string_to_array(text, text [, text]) :
> http://www.postgresql.org/docs/9.4/interactive/functions-array.html

> Would it be hateful to make it so that both entries appear on both tables?

> array_to_string(anyarray, text [,text]) could be lumped in with this as
> well.

> string_to_array not being on the string functions page is the more glaring
> omission for me.

I am not excited about the idea of documenting functions twice; that would
almost certainly lead to the redundant entries getting out of sync.

We could possibly decide that string_to_array and array_to_string are
primarily string functions not array functions, and just move them to
the string-functions page.

Another possibility is to just add cross-references to the
string-functions page, like the existing one for string_agg().
But I think I like the first idea better, in view of
regexp_string_to_array already being here.

            regards, tom lane