\Function and operator for json type PostgreSQL 9.2+
======================================
This PostgreSQL extension implements a group of operator for json type
IMPORTANT: There're bugs in the existing version. I'm working on it and will
be releasing another version very soon.
Building
--------
run make install
in postgresql execute: create extension json_utils
operators
--------
= check that 2 json data are iquals
? check if data (json) contain a specific key.
@> check if data (json) contain a key/value
Example
-------
CREATE TABLE table2( campo1 serial NOT NULL, campo22 json);
with data as
(select '{"field1":"valor1","field2":'||generate_series(1,1000)::text||'}' as j_son)
insert into tabla2 ( campo2) select j_son::json from datos
find a row whit json value '{"field1":"valor1","field2":341}' ... (operator =)
select * from tabla2 where campo2= '{"field1":"valor1","field2":341}'::json
find a row that contain in json data the key/value ='"field2":341' (operator @>)
select * from tabla1 where campo2 @> '"field2":341'
--
Anthony R. Sotolongo leon
asotolongo@uci.cu
Daymel Bonne
dbonne@uci.cu
