Changeset: 08079da80c37 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=08079da80c37 Added Files: sql/test/json/Tests/spaceissue.sql Modified Files: sql/test/json/Tests/All Branch: default Log Message:
merge diffs (21 lines): diff --git a/sql/test/json/Tests/All b/sql/test/json/Tests/All --- a/sql/test/json/Tests/All +++ b/sql/test/json/Tests/All @@ -1,3 +1,4 @@ +spaceissue parsing books pgexample diff --git a/sql/test/json/Tests/spaceissue.sql b/sql/test/json/Tests/spaceissue.sql new file mode 100644 --- /dev/null +++ b/sql/test/json/Tests/spaceissue.sql @@ -0,0 +1,8 @@ +create table txt( js json); +insert into txt values('{"message" : "indoorDeviceLocation", "id" : "00:1b:21:02:30:cd", "dateTime" : "2007-04-05T14:30", "position" : {"X" : "10", "Y" : "10" }}'); +select * from txt; + +select json_text(js, 'message') from txt; +select json_text(js, 'message') = 'indoorDeviceLocation' from txt; + +drop table txt; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list