How to query inside JSON array in postgresql

Question

I have a column named data in my table Engine as JSON array.

 [
        {
            "operation": "U",
            "taxCode": "1000",
            "description": "iva description",
            "tax": "12"
        },
        {
            "operation": "U",
            "taxCode": "1001",
            "description": "iva description",
            "tax": "12"
        },
        {
            "operation": "U",
            "taxCode": "1002",
            "description": "iva description",
            "tax": "12"
        }
    ]

I need to get the operation and desc value from this

The query which I formed is

select Id, data.operation, data.description 
from Engine,
     jsonb_to_recordset(Engine.data) as data(operation text, description text)

When I am running this query I'm getting error like no function matches the given name and argument type. you might need to add explicit type cast.

I don't know what I am doing wrong. Can anyone help me in this. I am new to postgres.

question from:https://stackoverflow.com/questions/65841730/how-to-query-inside-json-array-in-postgresql

Answer 1

Waitting for answers