Re: How to use JSON in MonetDB

Hi Art, JSON is a column type, so you first need to define a table with a column of type JSON, something like: CREATE TABLE A (js JSON); Once you inserted json documents into the table, you can do a query like: select json.filter(js, 'store') from js; Arjen ----- Original Message -----

From: "Art Apl" To: users-list@monetdb.org Sent: Monday, November 24, 2014 2:34:47 PM Subject: How to use JSON in MonetDB

Hello! MonetDB documentation says, that JSON is supported in MonetDB, but I can`t find any example. When I try to implement this query in MonetDB client: json . filter ({ "store" : { "bicycle" : { "color" : "red" , "price" : 19.95 }}}, '$' )

I get this error: syntax error, unexpected IDENT in: "json"

THX

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list