Re: Concatenation through SQL

[Andreas Kretschmer <akretschmer(at)spamfence(dot)net>]

Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> schrieb:

2 ways:

* You can use something like this:

test=*# select * from a;
 id | val
----+-----
  1 | foo
  2 | bar
(2 rows)

test=*# select array_to_string(array(select val from a), ', ');
 array_to_string
-----------------
 foo, bar
(1 row)


* comma-aggregate, see
http://www.zigo.dhs.org/postgresql/#comma_aggregate


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°