Trying to concat two json text fields like so:
SELECT app->>'id' || app->>'version' as foo FROM table, json_array_elements(applications::json) as app;
applications is the data type text, results in the error:
LINE 3: SELECT app->>'id' || app->>'version' as foo ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
I've also tried with jsonb. What is happening here, and how should json text fields be concatenated together?