Ordering by json field in ruby Sequel/Postgres

Question

I'm using the Sequel library in Ruby by Jeremy Evans and I'm trying to order by a field in json.

I can get this to work in SQL with this Postgres query:

SELECT * FROM files ORDER BY json->>'filename' ASC

but i can't get this to work with Sequel/Postgres

table.order("json ->'filename'")

This results in the following SQL:

SELECT * FROM "files" ORDER BY 'json ->''filename'''

giving the error:

PG::SyntaxError: ERROR: non-integer constant in ORDER BY LINE 1: ... ORDER BY 'json ->''...

Aslak · Accepted Answer · 2018-03-09 12:28:55Z

2

Problem solved:

table.order(Sequel.lit("json ->'filename'"))

answered Mar 9, 2018 at 12:28

Aslak

1399 bronze badges

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

1 Answer 1