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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-docs(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Annoying "split to array" function inconsistency...best way to fix?
Date: 2015-09-27 22:54:35
Message-ID: 12249.1443394475@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Michael Paquier 2015-09-28 03:33:58 Re: Updated docs on base backups
Previous Message David G. Johnston 2015-09-27 14:49:01 Annoying "split to array" function inconsistency...best way to fix?