2 ms·
As I said, to get rid of the superflous ".data->>" everywhere. Take this query for example: SELECT cities.data ->> '$.name' AS city_name, coun
by TekMol 2y ago
As I said, to get rid of the superflous ".data->>" everywhere. Take this query for example:
SELECT
cities.data ->> '$.name' AS city_name,
countries.data ->> '$.name' AS country_name
FROM
cities
JOIN
countries ON cities.data -> '$.country_id' = countries.data -> '$.id';
It could be much smaller if the DB knew that all my tables are of the "single data column with JSON" form.