|
I'd like to use the rank() function PostgreSQL on one of my columns. But since I don't have a rank column in my table rails doesn't include it with the query. What would be the correct way to get the rank included in my ActiveRecord object? |
|||||
|
|
try this: it should return you Character objects with a rank attribute, as documented here. However, this may not be database-agnostic and tends to get messy if you pass around the objects. another (expensive) solution is to add a rank column to your table, and have a callback recalculate all records' rank using .order whenever a record is saved or destroyed. edit : another idea suitable for single-record queries can ben seen here |
|||||||||||||
|
