Re: Plpgsql function to join array elements with a string

From: Bastien Continsouzas <dev(at)continsouzas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Plpgsql function to join array elements with a string
Date: 2007-09-19 15:32:50
Message-ID: 1190215970.599727.8300@g4g2000hsf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=== PROBLEM SOLVED ===

I found for what I was looking
http://www.postgresql.org/docs/8.0/static/functions-array.html

Function : array_to_string (anyarray, text)
Return type : text
Description : concatenates array elements using provided delimiter
Example : array_to_string(array[1, 2, 3], '~^~')
Result : 1~^~2~^~3

Bastien Continsouzas

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-09-19 15:45:58 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Previous Message Richard Broersma Jr 2007-09-19 15:30:15 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER