Others way to search in JSONB fields

[prest]

Others way to search in JSONB fields

[avelino]

Would that be JSON Functions and Operators?

https://www.postgresql.org/docs/9.4/static/functions-json.html

[marioidival]

@avelino yes!

[avnermiz]

Hi @avelino - perhaps you can help me with something. I'd like to use pREST to extract nested JSON values. Here's the query I would do in postgres:

select FIELD1 -> 'jsonField' -> 'jsonNestedField' --> 'jsonDoubleNestedField' FROM TABLE where FIELD2 = VALUE

Is there some way to convert that into a pRest GET request?

From what I see, the json GET request does not support nested JSON and requires you to specify a value you want to filter on for the json field.

Any help would be much appreciated. Thanks