Collation order in Rails with Postgresql

Hi All!

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

Alpha Bravo Charlie ...

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

Alpha
Bravo
*
*
*
Lima
Mike

November
Oscar

I tried @@@@ in place of and it is positioned as I expect, but
@none@ is handled the same as .

I’ve searched the web, but there are too many different solutions. It
will take me all day and night to try them out,

Can anyone point me in the right direction?

Thanks,

Don Z.

On 12 March 2016 at 00:49, Donald Z. [email protected] wrote:

November Oscar

I tried @@@@ in place of and it is positioned as I expect, but @none@
is handled the same as .

I’ve searched the web, but there are too many different solutions. It will
take me all day and night to try them out,

Can anyone point me in the right direction?

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

Colin

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs