Postgres JSON Rails Query

Question

I have a record that looks like this: { properties: [1,2] }

I want to search to find the field where the properties match exactly.

Record.where("(query)")

So far I tried things I found from this answer including

"properties#>>'{array,0}' = '1'"

to try to get the first element of an array to match.

I just don't understand the query interface for postgres columns at all. Can someone help me out? How do I search for an array with contents I know I want to match exactly?

RandallB · Accepted Answer · 2017-10-31 22:14:17Z

1

To access elements of an array, use their numeric index with the format fieldname->>index

So the answer to the original query is:

properties ->>0 is '1' and properties->>1 is '2'

answered Oct 31, 2017 at 22:14

RandallB

5,5956 gold badges36 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Postgres JSON Rails Query

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