On 02/05/16 01:03, Alberto Ferrari wrote:
Can anyone help with json.filters? I have this example table ...
CREATE TABLE tblJson ( "id" INT, "json_data" JSON, );
... with these values...
INSERT INTO tblJson (id, json_data) VALUES (1, '{"data":{"time":"2015-10-09 10:36:35","others":"xxx"}}'), (2, '{"data":{"time":"2015-10-09 12:18:20","others":"yyy"}}'), (3, '{"data":{"time":"2015-12-30 16:31:22","others":"zzz"}}'); The data is ok, I can select the rows, it's ok. Also I can select only the "time" field, like this... SELECT json.filter(json_data, 'data.time') FROM tblJson;
But now I want to filter the content in "json_data" specific field, i.e. SELECT all the rows where "time like '2015-10-09%'" , or maybe "time = '2015-10-09 12:18:20'" of course not, SQL does not know anything about the Json internal structure. You first have to extract the time component and then apply the like operation.
I tried but can't do it. Any help? Thanks!
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list