How do I perform a query in postgresql to get data in JOSN?
I have tried this way below, but it presents the error: db query error: pq: operator does not exist: text ->> unknown
SELECT ((old_data->>‘plano_id’)::NUMERIC) as value
FROM admcore_additive