Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZgDGa-0000dT-TU for pgsql-docs@arkaria.postgresql.org; Sun, 27 Sep 2015 14:49:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZgDGZ-0002aI-Vh for pgsql-docs@arkaria.postgresql.org; Sun, 27 Sep 2015 14:49:28 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZgDGE-0002Cy-Ky for pgsql-docs@postgresql.org; Sun, 27 Sep 2015 14:49:06 +0000 Received: from mail-io0-x229.google.com ([2607:f8b0:4001:c06::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZgDGB-00027p-4k for pgsql-docs@postgresql.org; Sun, 27 Sep 2015 14:49:04 +0000 Received: by ioii196 with SMTP id i196so152924002ioi.3 for ; Sun, 27 Sep 2015 07:49:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=v4alYHhqJIzzrz/0AdXGRzLucyjzQg/CWLx/frm2Huw=; b=FW2ZowijDt0YOppJ2JQstUEIzBu0HPY8BGynYajXSFBBZzTB1rIqJ6e0/Mbr7ZWKpz TA+F3aFKX3V91kz7dgXOqdssScQTl9aVJVHdyQwG14cMLI6y/H7hLJrF7JCQdSl4imX2 sEc2OjqSC84+3pU/YLlijv/97q85sR6foiAg2YKSrbiguyDL5VlW8Zdv9sPWEYyj5Uho xWYs9cAaol+oE9XLnri2Bz5Ni5IiRleE6+I/mZVQ7pDJnsnPoaUQ/spYkteA3BoB+PLk webW53t22fh9/9fNFBZ8zTEYGBQAEQU60DMOrXDnmk83VNdg4HH6kz4uC8wJH3JgFmrW pP1A== MIME-Version: 1.0 X-Received: by 10.107.6.73 with SMTP id 70mr13943126iog.158.1443365341911; Sun, 27 Sep 2015 07:49:01 -0700 (PDT) Received: by 10.36.62.134 with HTTP; Sun, 27 Sep 2015 07:49:01 -0700 (PDT) Date: Sun, 27 Sep 2015 10:49:01 -0400 Message-ID: Subject: Annoying "split to array" function inconsistency...best way to fix? From: "David G. Johnston" To: "pgsql-docs@postgresql.org" Content-Type: multipart/alternative; boundary=001a113f8cb87c673d0520bbae51 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --001a113f8cb87c673d0520bbae51 Content-Type: text/plain; charset=UTF-8 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. David J. --001a113f8cb87c673d0520bbae51 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Two functions exists that convert "text" to &= quot;text[]"

regexp_string_to_array(text, text [,= text]) :=C2=A0http://www.postgresql.org/docs/9.4/interactive/function= s-string.html
string_to_array(text, text [, text]) :=C2=A0= http://www.postgresql.org/docs/9.4/interactive/functions-array.html

Would it be hateful to make it so that both entries appea= r on both tables?

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

string_to_ar= ray not being on the string functions page is the more glaring omission for= me.

David J.

--001a113f8cb87c673d0520bbae51--