Re: [GENERAL] Help function to sort string

2013-10-18 Thread Vincent Veyron
Le mardi 15 octobre 2013 à 08:52 -0700, ginkgo36 a écrit : > 1. I want to sort string follow anphabet and I used this query: > select string_agg(x, ';') from (select > trim(unnest(regexp_split_to_array('ECD FORM; BODY; PREDILUTED; CHROMO-GENIC; > AUTO;RABBIT; FORMAT',';'))) x order by x) a; > > -

[GENERAL] Help function to sort string

2013-10-17 Thread ginkgo36
Hi everyone, Please hepl me this function: 1. I want to sort string follow anphabet and I used this query: select string_agg(x, ';') from (select trim(unnest(regexp_split_to_array('ECD FORM; BODY; PREDILUTED; CHROMO-GENIC; AUTO;RABBIT; FORMAT',';'))) x order by x) a; -- result: AUTO; BODY; CHROMO