From victor@caido.ro Sun Aug 25 12:15:51 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDZEV-0000kS-6l for pgsql-sql@arkaria.postgresql.org; Sun, 25 Aug 2013 12:15:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VDZEU-0000oc-LW for pgsql-sql@arkaria.postgresql.org; Sun, 25 Aug 2013 12:15:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDZES-0000oT-J2 for pgsql-sql@postgresql.org; Sun, 25 Aug 2013 12:15:48 +0000 Received: from ppp248107867.ambra.ro ([86.107.248.7] helo=caido.ro) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDZEM-000724-Iq for pgsql-sql@postgresql.org; Sun, 25 Aug 2013 12:15:48 +0000 Received: from localhost (localhost [127.0.0.1]) by caido.ro (Postfix) with ESMTP id 2074C1415AA for ; Sun, 25 Aug 2013 15:14:54 +0300 (EEST) Received: from caido.ro ([127.0.0.1]) by localhost (caido.ro [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id QnlUHeTVYGyF for ; Sun, 25 Aug 2013 15:14:53 +0300 (EEST) Received: from localhost (localhost [127.0.0.1]) by caido.ro (Postfix) with ESMTP id 5609B1415AC for ; Sun, 25 Aug 2013 15:14:53 +0300 (EEST) X-Amavis-Modified: Mail body modified (using disclaimer) - caido.ro X-Virus-Scanned: amavisd-new at caido.ro Received: from caido.ro ([127.0.0.1]) by localhost (caido.ro [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id eRtMvB2FTm_w for ; Sun, 25 Aug 2013 15:14:53 +0300 (EEST) Received: from [127.0.0.1] (unknown [89.43.152.14]) by caido.ro (Postfix) with ESMTPSA id 2309B1415AA for ; Sun, 25 Aug 2013 15:14:53 +0300 (EEST) From: "Victor Sterpu" To: pgsql-sql@postgresql.org Subject: function array_to_string(text[]) does not exist Date: Sun, 25 Aug 2013 12:15:41 +0000 Content-Type: multipart/alternative; boundary="------=_MB2DF58AC0-E9E1-4693-847E-9E23BE49DE63" Message-Id: Mime-Version: 1.0 Reply-To: "Victor Sterpu" User-Agent: eM_Client/5.0.18025.0 X-Pg-Spam-Score: 0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org --------=_MB2DF58AC0-E9E1-4693-847E-9E23BE49DE63 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; format=flowed; charset=utf-8 Hello When I run : SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR),=20 '-', CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii))) FROM lab_tests_reference_values ltrv1 GROUP BY ltrv1.val_min, ltrv1.val_max, ltrv1.comentarii; I get the error: ERROR: function array_to_string(text[]) does not exist LINE 1: SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min ... ^ HINT: No function matches the given name and argument types. You might=20 need to add explicit type casts. I tryed to cast but it's still not working. Thanku you. --------=_MB2DF58AC0-E9E1-4693-847E-9E23BE49DE63 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
Hello
 
When I run :
SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR),= '-', CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii)))
FROM lab_tes= ts_reference_values ltrv1
GROUP BY ltrv1.val_min, ltrv1.val_max, ltrv1.= comentarii;
 
I get the error:
ERROR:  function array_to_string(text[]) does not exist
LINE= 1: SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min ...
&nbs= p;            &= nbsp; ^
HINT:  No function matches the given name and argument type= s. You might need to add explicit type casts.
 
I tryed to cast but it's still not working.
 
Thanku you.

=

DISCLAIMER:
Acest mesaj de posta electronica si documentele aferente sunt confidentiale. Este interzisa distribuirea, dezvaluirea sau orice alt mod de utilizare a lor. Daca nu sunteti destinatarul acestui mesaj, este interzis sa actionati in baza acestor informatii. Citirea, copierea, distribuirea, dezvaluirea sau utilizarea in alt mod a informatiei continute in acest mesaj constituie o incalcare a legii. Daca ati primit mesajul din greseala, va rugam sa il distrugeti, anuntand expeditorul de eroarea comisa. Intrucat nu poate fi garantat faptul ca posta electronica este un mod sigur si lipsit de erori de transmitere a informatiilor, este responsabilitatea dvs. sa va asigurati ca mesajul (inclusiv documentele alaturate lui) este validat si autorizat spre a fi utilizat in mediul dvs.


= --------=_MB2DF58AC0-E9E1-4693-847E-9E23BE49DE63-- From amutu@amutu.com Sun Aug 25 12:34:06 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDZWA-0001XN-0i for pgsql-sql@arkaria.postgresql.org; Sun, 25 Aug 2013 12:34:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VDZW9-0002TH-8c for pgsql-sql@arkaria.postgresql.org; Sun, 25 Aug 2013 12:34:05 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDZW6-0002T8-UI for pgsql-sql@postgresql.org; Sun, 25 Aug 2013 12:34:03 +0000 Received: from mail-we0-x22d.google.com ([2a00:1450:400c:c03::22d]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDZVy-0003TZ-DU for pgsql-sql@postgresql.org; Sun, 25 Aug 2013 12:34:01 +0000 Received: by mail-we0-f173.google.com with SMTP id x54so1887608wes.18 for ; Sun, 25 Aug 2013 05:33:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:from:date:message-id :subject:to:cc:content-type; bh=00XV1yi+h6+OtFUERIHbHpRZTfJHacMNHMK5x8/tLAY=; b=pV0Lr5IucT+PxHZ6htTuM1vvwAmx3QbH1/wzfN8aJTTRWWy2Ajg6rNz/2acRlkdOHC KunMYwOqFwWoqMArWNaZDstnNFc/FTAT3wsWw+W4xpkTxIvxuIF3g58Sf5FlIABoD3JH 0+pK9ATSCN0SkPH8E8ETBEsUHwSjofakN7s2rHqNpfdTOssKlHpMFctR39/qgQFvrIhO BKC1pIGryrILXT76R1YU/dyoo6EHVEx10QguJiC2sSQ5eTawAS9d+nH33A7MEQi16f6o +WnfC2er7uvB5Yah3ZW3QoPmcN03sJ5FzGOyRTG39Jv7dZncEckoorKPUaE67FtubLww /qCg== X-Received: by 10.180.188.49 with SMTP id fx17mr4220020wic.49.1377434031245; Sun, 25 Aug 2013 05:33:51 -0700 (PDT) MIME-Version: 1.0 Received: by 10.194.155.99 with HTTP; Sun, 25 Aug 2013 05:33:31 -0700 (PDT) In-Reply-To: References: From: Jov Date: Sun, 25 Aug 2013 20:33:31 +0800 X-Google-Sender-Auth: H4G6e4ElzCSuK2DJ5GEDNqQY2lY Message-ID: Subject: Re: function array_to_string(text[]) does not exist To: Victor Sterpu Cc: pgsql-sql Content-Type: multipart/alternative; boundary=001a11c25bda22500304e4c4da2e X-Pg-Spam-Score: 1.1 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org --001a11c25bda22500304e4c4da2e Content-Type: text/plain; charset=ISO-8859-1 Yes,array_to_string(text[]) does not exist. This from the doc may help: array_to_string(anyarray,text [, text]) text concatenates array elements using supplied delimiter and optional null stringarray_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*') 1,2,3,*,5 Jov blog: http:amutu.com/blog 2013/8/25 Victor Sterpu > Hello > > When I run : > SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR), '-', > CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii))) > FROM lab_tests_reference_values ltrv1 > GROUP BY ltrv1.val_min, ltrv1.val_max, ltrv1.comentarii; > > I get the error: > ERROR: function array_to_string(text[]) does not exist > LINE 1: SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min ... > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > > I tryed to cast but it's still not working. > > Thanku you. > > *DISCLAIMER: > Acest mesaj de posta electronica si documentele aferente sunt > confidentiale. Este interzisa distribuirea, dezvaluirea sau orice alt mod > de utilizare a lor. Daca nu sunteti destinatarul acestui mesaj, este > interzis sa actionati in baza acestor informatii. Citirea, copierea, > distribuirea, dezvaluirea sau utilizarea in alt mod a informatiei continute > in acest mesaj constituie o incalcare a legii. Daca ati primit mesajul din > greseala, va rugam sa il distrugeti, anuntand expeditorul de eroarea > comisa. Intrucat nu poate fi garantat faptul ca posta electronica este un > mod sigur si lipsit de erori de transmitere a informatiilor, este > responsabilitatea dvs. sa va asigurati ca mesajul (inclusiv documentele > alaturate lui) este validat si autorizat spre a fi utilizat in mediul dvs. > * > > --001a11c25bda22500304e4c4da2e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Yes,array_to_string(text[]) does not exist.
This from the doc may help:
array_to_string(anyarray,text=A0[,=A0text]) text concatenates array elements using supplied delimiter and optional null stri= ngarray_= to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*') 1,2,3,*,5



2013/8/25 Victor Sterpu <victor@caido.ro<= /a>>
Hello
=A0
When I run :
SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR), = '-', CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii)))<= br>FROM lab_tests_reference_values ltrv1
GROUP BY ltrv1.val_min, ltrv1.= val_max, ltrv1.comentarii;
=A0
I get the error:
ERROR:=A0 function array_to_string(text[]) does not exist
LINE 1: S= ELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min ...
=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ^
HINT:=A0 No function matches the giv= en name and argument types. You might need to add explicit type casts.
=A0
I tryed to cast but it's still not working.
=A0
Thanku you.

DISCL= AIMER:
Acest mesaj de posta electronica si documentele aferente sun= t confidentiale. Este interzisa distribuirea, dezvaluirea sau orice alt mod= de utilizare a lor. Daca nu sunteti destinatarul acestui mesaj, este inter= zis sa actionati in baza acestor informatii. Citirea, copierea, distribuire= a, dezvaluirea sau utilizarea in alt mod a informatiei continute in acest m= esaj constituie o incalcare a legii. Daca ati primit mesajul din greseala, = va rugam sa il distrugeti, anuntand expeditorul de eroarea comisa. Intrucat= nu poate fi garantat faptul ca posta electronica este un mod sigur si lips= it de erori de transmitere a informatiilor, este responsabilitatea dvs. sa = va asigurati ca mesajul (inclusiv documentele alaturate lui) este validat s= i autorizat spre a fi utilizat in mediul dvs.



--001a11c25bda22500304e4c4da2e-- From pavel.stehule@gmail.com Sun Aug 25 13:19:05 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDaDh-00037F-My for pgsql-sql@arkaria.postgresql.org; Sun, 25 Aug 2013 13:19:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VDaDh-0004pL-6A for pgsql-sql@arkaria.postgresql.org; Sun, 25 Aug 2013 13:19:05 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDaDg-0004pE-0u for pgsql-sql@postgresql.org; Sun, 25 Aug 2013 13:19:04 +0000 Received: from mail-ea0-x233.google.com ([2a00:1450:4013:c01::233]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDaDY-0004F7-BV for pgsql-sql@postgresql.org; Sun, 25 Aug 2013 13:19:03 +0000 Received: by mail-ea0-f179.google.com with SMTP id b10so1125888eae.10 for ; Sun, 25 Aug 2013 06:18:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=IfguKBlLv/GlDOm1Axzxm6yzCRWfoNzgn9QYo3JUv0w=; b=cXCCzyxkT3ynnWKE/vBWiU6+v/xm3ryS4ZB5xe7r6ry1J8UtJriq9i35NQ8FhkF2AM TPJz9t9fUXV3cOp0VDflZWYqrBgpaJfU+l7nTbw8RgAQK7UvlQvinLEti9O6PNDSbFUY ziyrxklsgWfEspZYhZBRsRcg2+jsbDuoqtcK5uANYRtYEJvDPtR1W1Arv0etTnGEPh8x cUJSqEkV/Wj2AeL1+iua1LlK+VwLUNVSnrupz/JoT9s9RV/pYASUuCbkVCy/RykOJng3 Y8uNInp4D304HCWRH5tEQKA0m8z0AKWKTDgl5klLW7pdmiF6+fQn8tO3wntsB8wI7ClV jgOg== X-Received: by 10.15.94.201 with SMTP id bb49mr17021309eeb.23.1377436734696; Sun, 25 Aug 2013 06:18:54 -0700 (PDT) MIME-Version: 1.0 Received: by 10.14.143.196 with HTTP; Sun, 25 Aug 2013 06:18:14 -0700 (PDT) In-Reply-To: References: From: Pavel Stehule Date: Sun, 25 Aug 2013 15:18:14 +0200 Message-ID: Subject: Re: function array_to_string(text[]) does not exist To: Victor Sterpu Cc: postgres list Content-Type: multipart/alternative; boundary=089e01681f4245cfa204e4c57bd0 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org --089e01681f4245cfa204e4c57bd0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello you should to enter separator postgres=3D# select array_to_string(ARRAY[1,2,3,4], '|'); array_to_string =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80 1|2|3|4 (1 row) Regards Pavel Stehule 2013/8/25 Victor Sterpu > Hello > > When I run : > SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR), '-'= , > CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii))) > FROM lab_tests_reference_values ltrv1 > GROUP BY ltrv1.val_min, ltrv1.val_max, ltrv1.comentarii; > > I get the error: > ERROR: function array_to_string(text[]) does not exist > LINE 1: SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min ... > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > > I tryed to cast but it's still not working. > > Thanku you. > > *DISCLAIMER: > Acest mesaj de posta electronica si documentele aferente sunt > confidentiale. Este interzisa distribuirea, dezvaluirea sau orice alt mod > de utilizare a lor. Daca nu sunteti destinatarul acestui mesaj, este > interzis sa actionati in baza acestor informatii. Citirea, copierea, > distribuirea, dezvaluirea sau utilizarea in alt mod a informatiei continu= te > in acest mesaj constituie o incalcare a legii. Daca ati primit mesajul di= n > greseala, va rugam sa il distrugeti, anuntand expeditorul de eroarea > comisa. Intrucat nu poate fi garantat faptul ca posta electronica este un > mod sigur si lipsit de erori de transmitere a informatiilor, este > responsabilitatea dvs. sa va asigurati ca mesajul (inclusiv documentele > alaturate lui) este validat si autorizat spre a fi utilizat in mediul dvs= . > * > > --089e01681f4245cfa204e4c57bd0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello

you should to enter sepa= rator

postgres=3D# select array_to_string(ARRAY[1,2,3,4], '|'= ;);
=C2=A0array_to_string
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80
=C2=A01|2|3|4
(1 row)

Regards

Pavel Stehule



2013/8/25 Vi= ctor Sterpu <victor@caido.ro>
Hello
=C2=A0
When I run :
SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR), = '-', CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii)))<= br>FROM lab_tests_reference_values ltrv1
GROUP BY ltrv1.val_min, ltrv1.= val_max, ltrv1.comentarii;
=C2=A0
I get the error:
ERROR:=C2=A0 function array_to_string(text[]) does not exist
LINE 1= : SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min ...
=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 ^
HINT:=C2=A0 No function matches the given name and argument types.= You might need to add explicit type casts.
=C2=A0
I tryed to cast but it's still not working.
=C2=A0
Thanku you.

DISCL= AIMER:
Acest mesaj de posta electronica si documentele aferente sun= t confidentiale. Este interzisa distribuirea, dezvaluirea sau orice alt mod= de utilizare a lor. Daca nu sunteti destinatarul acestui mesaj, este inter= zis sa actionati in baza acestor informatii. Citirea, copierea, distribuire= a, dezvaluirea sau utilizarea in alt mod a informatiei continute in acest m= esaj constituie o incalcare a legii. Daca ati primit mesajul din greseala, = va rugam sa il distrugeti, anuntand expeditorul de eroarea comisa. Intrucat= nu poate fi garantat faptul ca posta electronica este un mod sigur si lips= it de erori de transmitere a informatiilor, este responsabilitatea dvs. sa = va asigurati ca mesajul (inclusiv documentele alaturate lui) este validat s= i autorizat spre a fi utilizat in mediul dvs.



--089e01681f4245cfa204e4c57bd0--