請(qǐng)幫我看個(gè)函數(shù)出錯(cuò)的問(wèn)題

hmchzb19

這個(gè)函數(shù)定義如下： 我是從這一篇blog 上看來(lái)的：https://blog.interlinked.org/tutorials/postgresql.html

1. create or replace function jmember (j json, key text )
   
2. RETURNS text
   
3. LANGUAGE plv8
   
4. IMMUTABLE
   
5. AS $function$
   
6.   var ej = JSON.parse(j);
   
7.   if (typeof ej != 'object')
   
8.         return NULL;
   
9.   return JSON.stringify(ej[key]);
   
10. $function$;

復(fù)制代碼

The jmember function allows us to parse and read the JSON string and returns the member identified by key:

select jmember(data, 'title') from jsontest;     jmember----------------- "right"(1 row)

Andrew also shows how to build an index to speed up access times in his post.

這個(gè)函數(shù)我不能成功執(zhí)行 報(bào)錯(cuò)如下：

點(diǎn)擊(此處)折疊或打開(kāi)

• postgres=# select jmember(data, 'title') from jsontest;
  
• ERROR: SyntaxError: Unexpected token o
• DETAIL: undefined() LINE 0: [object Object