(no commit message)

[paste/557.git] / query.sql

SELECT general->"$.country" AS country FROM node_data HAVING country IS NOT NULL\r
\r
-- remove quotes from string data\r
SELECT general->>"$.country" AS country FROM node_data\r