How to make an index on a JSONB field in PostgreSQL?

Question

PHP

There is a jsonb properties field .
Some entries in properties have a price object .
That is, there is such a json object:

{
    price: {
        id: 222,
        val: 150
    }
}

I want to speed up this SELECT:

SELECT * FROM "TABLE_NAME" WHERE (properties #>> '{price, val}')::int BETWEEN '100' AND'200'

I create an index like this:

CREATE INDEX price_btree_idx ON estates USING btree (((properties -> 'price') -> 'val'))

There are no changes, because apparently the base considers that the val field is text.
How to make such an index?
UPD:
The "properties" field itself is already indexed:

CREATE INDEX properties_gin_idx ON estates USING gin (properties jsonb_path_ops)

Answer 1

I'll be a necroposter
Apparently you need to create an index as described here - https://stackoverflow.com/questions/36075918/postg...
i.e. CREATE INDEX price_btree_idx ON estates ((((properties -> 'price') -> ' val'))::int)

Answer 2

Unfortunately, I don't have postgresql at hand to check, but try to make a functional index on the price field, I think there should be such an opportunity.