On Tue, 2007-06-05 at 19:33 +0300, veejar wrote:
> 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.
>
Look into writing a simple function:
http://www.postgresql.org/docs/current/static/plpgsql.html
Also, consider that you should have an ORDER BY somewhere, to make sure
the values get joined in the order that you expect.
Regards,
Jeff Davis