Rails PostgreSQL sort by integer value of string

Question

I made a strategic mistake when developing database architecture on my Rails app

Now I have to implement sorting by price feature using

MyModel.order('price DESC')

price is a string type in the database, which cause 50 to be greater than 2000 for example

Are there any ways to implement such .order() without changing database structure?

EDIT:

I switched to correct type (integer) for price column. It took me an hour only to refactor.

I think it is better to migrate column type from string to float if possible. Otherwise you should cast column: ORDER BY price::float. — Oleksandr Avoiants
– Oleksandr Avoiants, Commented Oct 21, 2016 at 15:49
Yea Oleksandr Avoyants is right you really should just migrate the database table to have the right value. You are going to really hinder yourself if you just keep finding work arounds. — C dot StrifeVII
– C dot StrifeVII, Commented Oct 21, 2016 at 15:54

Community · Accepted Answer · 2017-05-23 11:47:09Z

17

With PostgreSQL you will want to cast your string to integer/float/decimal (after you decide you 100% will not go and change the column type to correct one):

MyModel.order('price::integer DESC')

Consider this answer to make it work fast.

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Oct 21, 2016 at 16:13

Andrey Deineko

52.5k11 gold badges119 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails PostgreSQL sort by integer value of string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related