function array_to_string(text[]) does not exist

From: "Victor Sterpu" <victor(at)caido(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: function array_to_string(text[]) does not exist
Date: 2013-08-25 12:15:41
Message-ID: em0ef363fb-ebff-4b95-87ce-32365c65f5e1@victor-pc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jov 2013-08-25 12:33:31 Re: function array_to_string(text[]) does not exist
Previous Message Rob Sargentg 2013-08-05 04:01:15 Re: Presenting data in 5 Rows & 5 Cols for 25 specific values