Sorting in Rails: SQLite vs PostgreSQL
|Added at||2017-01-04 18:01|
When I order by a column (id type INT) in Rails 5 with sqlite as the development db, it sorts as expected (1,2,3,4...) but the same thing on my production environment (PostgreSQL) results in unexpected behaviour (1, 101, 102,...2, 201,...) and so on.
If I format the order as per PostgreSQL (
Am I overlooking something? I'm quite new to programming.