Join field values

From: veejar <veejar(dot)net(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Join field values
Date: 2007-06-05 16:33:58
Message-ID: a4c4d7e50706050933h1b6882d0jd50aad963af936b0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I have such field in my table:

field1
-------
1
2
3
4
5

I want to get such result from select:
'1,2,3,4,5' - join all values in field1 with ','
// result must be varchar.

Help to write SELECT-query for this task.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marko Kreen 2007-06-05 16:35:29 Re: Encrypted column
Previous Message Erik Jones 2007-06-05 16:27:26 Re: Large Database \d: ERROR: cache lookup failed for relation ...