PostgreSQL: perl like join

1 2 3 4 5

db=# select array_to_string(array['a', 'b', 'c'], '-');                                                                      array_to_string -----------------  a-b-c (1 row)