Re: tab_to_sting

On 07/24/2014 07:22 AM, Ramesh T wrote:
> SELECT
> qa.tab_to_largestringcheck(cast(array_agg(part_id)as
> t_varchar2_tab),':')FROM qa.part
>
> when i replace string_agg it's return does not exit,

My guess is if you look at the error message it is complaining about the
type of argument passed in.

Please show us the actual error message if that is not the case.

>
> need to enable string_agg ..?i think is predefined right

From psql:

production=# SELECT version();
version

-----------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.4 on i686-pc-linux-gnu, compiled by gcc (SUSE Linux)
4.7.2 20130108 [gcc-4_7-branch revision 195012], 32-bit
(1 row)

production=# \df string_agg
List of functions
Schema | Name | Result data type | Argument data types | Type
------------+------------+------------------+---------------------+------
pg_catalog | string_agg | bytea | bytea, bytea | agg
pg_catalog | string_agg | text | text, text | agg
(2 rows)

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com