[AppleScript] 纯文本查看 复制代码 Content-Type:application/json; charset=UTF-8, body:..
org.apache.openjpa.persistence.PersistenceException: ERROR: function year(timestamp without time zone) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 9 {prepstmnt 1218325969 SELECT (year(t0.xcreateTime)||month(t0.xcreateTime)), COUNT(t0.xid) FROM public.WCRM_CUSTOMER t0 WHERE (t0.xowneruser = ? AND t0.xowneruser IS NOT NULL AND t0.xcreateTime >= ? AND t0.xcreateTime <= ?) GROUP BY (year(t0.xcreateTime)||month(t0.xcreateTime))} [code=0, state=42883]
从应用市场里安装的CRM模块,点进进入报错了,看起来是sql的语法有问题。
我的问题是,是不是这个只兼容mysql的数据库,不兼容postgresql的数据库?
|