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

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -