Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37416=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 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
 <pgsql-sql-owner+M37416=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 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 <victor@caido.ro>) 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 <victor@caido.ro>) 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 <pgsql-sql@postgresql.org>; 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 <pgsql-sql@postgresql.org>;
 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 <pgsql-sql@postgresql.org>; 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 <pgsql-sql@postgresql.org>;
 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 <pgsql-sql@postgresql.org>; Sun, 25 Aug 2013 15:14:53 +0300 (EEST)
From: "Victor Sterpu" <victor@caido.ro>
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: <em0ef363fb-ebff-4b95-87ce-32365c65f5e1@victor-pc>
Mime-Version: 1.0
Reply-To: "Victor Sterpu" <victor@caido.ro>
User-Agent: eM_Client/5.0.18025.0
X-Pg-Spam-Score: 0.0 (/)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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

<HTML><HEAD>
<STYLE id=3DeMClientCss>
blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px;=
 padding-right:0px; border-left: 1px solid #000000 }
.plain pre, .plain tt { font-family: monospace; font-size: 100%; font-weigh=
t: normal; font-style: normal; }
body {font-family: Tahoma;font-size: 12pt;}
.plain pre, .plain tt {font-family: Tahoma;font-size: 12pt;}</STYLE>
</HEAD>
<BODY>
<DIV>Hello</DIV>
<DIV>&nbsp;</DIV>
<DIV>When I run :</DIV>
<DIV>SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR),=
 '-', CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii)))<BR>FROM lab_tes=
ts_reference_values ltrv1 <BR>GROUP BY ltrv1.val_min, ltrv1.val_max, ltrv1.=
comentarii;</DIV>
<DIV>&nbsp;</DIV>
<DIV>I get the error:</DIV>
<DIV>ERROR:&nbsp; function array_to_string(text[]) does not exist<BR>LINE=
 1: SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min ...<BR>&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp; ^<BR>HINT:&nbsp; No function matches the given name and argument type=
s. You might need to add explicit type casts.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I tryed to cast but it's still not working.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanku you.</DIV>
<br>=
<html><body><p><font FACE=3DARIAL size=3D1 color=3DDARKGREEN><I><B>DISCLAIMER</B>: <BR>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.</I></font></p></body></html>
<br>=
</BODY></HTML>
--------=_MB2DF58AC0-E9E1-4693-847E-9E23BE49DE63--