pg jsonpath 为JSONB数据类型向Postgres添加JSONPath支持

通过plpython2向PostgreSQL添加JSONPath支持。需要jsonpath python包：pip2 install --allow-external jsonpath --allow-unverified jsonpath。在PostgreSQL 9.3.5上测试。例子：CREATE TABLE events (id SERIAL, data JSON); SELECT id FROM events WHERE jsonpath(data, '$.participants[?(@.name==\"Dolphins\")].name')='Dolphins'; SELECT id FROM events WHERE 'Dolphins' = ANY (jsonpatharr(data, '$.participants[*].n'))