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" <percunium@gmail.com>
> 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
>
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list