How to check if a JSON stored in a Postgres column has a key after a join

Question

I tried something like this...

result = User.includes(:detail).where("detail.strings->'the_key') IS NOT NULL")

But that doesn't seem to work. I want to join User to Detail and then check the column strings in the table Detail to see if the json stored in strings has the_key. That doesn't work. I also tried use strings-> but that didn't work as well

stackoverflow.com/questions/19422640/…

max
– max

2019-05-14 13:41:02 +00:00
Commented May 14, 2019 at 13:41 — max
– max, Commented May 14, 2019 at 13:41

Roman Alekseiev · Accepted Answer · 2019-05-14 13:25:45Z

0

Try this

User.joins(:detail).where("detail.strings ->> 'the_key' IS NOT NULL")

answered May 14, 2019 at 13:25

Roman Alekseiev

1,92120 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to check if a JSON stored in a Postgres column has a key after a join

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related