How do I order results by hstore attribute in Rails 4?
Double quotes are used to quote identifiers (such as table and column names) in PostgreSQL (and other databases that follow the standard). So when you say:
hstore("platform")PostgreSQL sees "platform" as a quoted column name and since there is no platform column, you get an error.
Strings in standard SQL are quoted with single quotes, you want to say:
.order("products.properties @> hstore('platform')")This will probably still fail though, hstore('platform') doesn't make much sense and neither does using @> here; a @> b means
does the hstore
acontain the hstoreb
If you're trying to sort on the value of the 'platform' key in the properties hstore then you'd want to use -> to lookup the 'platform' key like this:
.order("products.properties -> 'platform'")