ruby sequel access json field -
i have following schema:
column | type | modifiers ---------+-----------------------------+------------------------ id | text | not null data | json | not null created | timestamp without time zone | not null default now() if open psql can run query.
select id, data->'amount' amount plans; but ruby sequel gem ruins it.
puts $db.run("select id, data->'amount' amount plans") what's wrong?
needed #literal method.
$db.run("select id, data -> #{ $db.literal('amount') } amount plans")
Comments
Post a Comment