subject:"\[GENERAL\] Help function to sort string"

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;