Re: need substring based on delimiter - Mailing list pgsql-general

On 08/23/2012 02:30 PM, Gauthier, Dave wrote:
> I want to create a string from the first 3 elements of a csv (for
> example).  The csv is longer than 3 elements.  Example...
>
> aaa,bbb,ccc,ddd,eee,fff,ggg
>
> I want the string "aaa,bbb,ccc".

select array_to_string
       (
         (
           string_to_array
           (
             'aaa,bbb,ccc,ddd,eee,fff,ggg',','
           )
         )[1:3],','
       );
 array_to_string
-----------------
 aaa,bbb,ccc
(1 row)

HTH,

Joe


--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support