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
Message-ID: <em0ef363fb-ebff-4b95-87ce-32365c65f5e1@victor-pc> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: victor@caido.ro
Subject: Re: function array_to_string(text[]) does not exist
In-Reply-To: <em0ef363fb-ebff-4b95-87ce-32365c65f5e1@victor-pc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox