From: | Jerry Sievers <jerry(at)jerrysievers(dot)com> |
---|---|
To: | veejar <veejar(dot)net(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Join field values |
Date: | 2007-06-07 19:49:48 |
Message-ID: | m3y7ivtuhv.fsf@mama.jerrysievers.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
veejar <veejar(dot)net(at)gmail(dot)com> writes:
> 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.
No sense in writing your own func for this; the feature is already
provided.
select array_to_string(array(select * from generate_series(1,5)), ',');
array_to_string
-----------------
1,2,3,4,5
(1 row)
> Help to write SELECT-query for this task.
--
-------------------------------------------------------------------------------
Jerry Sievers 732 365-2844 (work) Production Database Administrator
305 321-1144 (mobil WWW E-Commerce Consultant
From | Date | Subject | |
---|---|---|---|
Next Message | Richard P. Welty | 2007-06-07 20:03:37 | Re: Creditcard Number Security was Re: Encrypted column |
Previous Message | John D. Burger | 2007-06-07 19:45:56 | Re: querying the age of a row |