Page 1 of 1

sort result according to letter list

Posted: Sat Apr 14, 2007 8:22 am
by rhaynes
Hi, I am trying to build a postgresql query which will order returns based on a letter list, not alphabetically.

For example I would like returns arranged by the first letter of the word based on the list

{G,V,E,N,M}

so that Elephant, Goat, Mother, Nan, Violin would be arranged as

Goat,Violin,Elephant,Nan,Mother.

Thanks,
R Haynes