Closed
Description
I want use json1 in sql.js, I test some sql snippet in online demo
create table user (name text,phone JSON );
insert into user (name, phone) values("oz",'{"cell":"+491765", "home":"+498973"}');
select user.phone from user where user.name=='oz';
select json_extract(user.phone, '$.cell') from user;
but throw error : Uncaught Error: no such function: json_extract, how can I enable JSON1 extension, should I change Makefile like FTS5 extension.
https://github.com/kripken/sql.js/pull/199
Metadata
Metadata
Assignees
Labels
No labels