CREATE TABLE test_json ( a json, id serial);
INSERT INTO test_json (a) VALUES ( '{"a":"foo", "b":"bar"}' );
SELECT * FROM test_json WHERE a->>'b' = 'bar';
SELECT * FROM test_json WHERE a->a='foo';
ALTER TABLE test_json ADD json_data json ;
--
CREATE TEMP TABLE x (aa text,bb TIMESTAMP );SELECT json_agg(( phonenumber,created_at )::x ) FROM (SELECT phonenumber,created_at FROM inventory.phonenumber WHERE json_data->>'Phonenumber'>'0426085000' LIMIT 3 ) a
-[ RECORD 1 ]------------------------------------------------
json_agg | [{"aa":"04611920056","bb":"2015-03-03 08:20:12"},
| {"aa":"0462770051","bb":"2015-03-03 08:20:12"},
| {"aa":"0462770303","bb":"2015-03-03 08:20:12"}]
Comments