Hey Stefano,
Not all SQL types are supported for conversion to Python Objects; right now the only types that are supported are strings, numeric types, decimals and date/date time objects. JSON objects are not currently supported, so you would indeed need to store them as strings.
Regards,
Mark
----- Original Message -----
From: "Stefano Fioravanzo"
To: "users-list"
Sent: Wednesday, June 1, 2016 2:28:55 PM
Subject: query json from embedded py
Hello,
I am trying to query a table with a JSON field with a loopback query in embedded python.
I get this error:
SQL Query Failed: MALException:pyapi.eval:Unsupported SQL Type: son
Is JSON not supported? Do I have to store the JSON object as a string in case I want to query it from python?
Thank you,
Stefano
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
