这可能为时过早,postgres 9.4仍处于测试阶段.我一直在试验jsonb类型.我没有运气将jsonb类型传递给plv8函数,它以类型字符串形式出现.我想知道我做错了吗？
create or replace function jt ( o json ) returns integer language plv8 immutable
AS $function$
plv8.elog(INFO,'type is ',typeof o);
plv8.elog(INFO,'argument is ',o);
plv8.elog(INFO,'member is ',o['member']);
$function$;
create or replace function jt ( o jsonb ) returns integer language plv8 immutable
AS $function$
plv8.elog(INFO,o['member']);
$function$;
然后,当我使用json运行时：
psql=# select jt('{"member":"test"}'::json); INFO: type is object INFO: argument is [object Object] INFO: member is test
但是,当我用jsonb运行时：
psql=# select jt('{"member":"test"}'::jsonb); INFO: type is string INFO: argument is {"member": "test"} INFO: member is undefined
-G
