Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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"}]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement