Collation order in Rails with Postgresql

rubyonrails-talk
1

Hi All!

I am trying to get a rails postgres table ordered by the exact values of the ascii characters such that:

<none> Alpha Bravo Charlie ...

Unfortunately, even when I try to escape the < characters and enter them directly in the Postgresql table, I get:

Alpha Bravo

2

possibly model.all.order(:name) where name is the column you want to sort on.

Colin