any function/aggrega to do the SUM of string field ?

Michael REMY · #1 (**permalink**) 07-03-09, 06:00

hi !

i'd like a function to get the sum (concatenate) all the field 's values in a column.

for exemple, with table :
id | lib
---------------------
1 | toto
2 | titi
3 | tata

i'd like this :
SELECT SUM (lib) AS super FROM myTable and get this :
1 row :
super
-----------------
toto titi tata

any idea ?

rski · #2 (**permalink**) 07-29-09, 15:55

Like that (test2 is table name)

Code:

select array_to_string(ARRAY(select lib from test2),' ');

Internet Services

Web Development

Digital Marketing

Consumer Tech