Kibana入门

FIND_IN_SET()函数无法识别

方案一（有效果，但不多，mybatis中会出问题）

解决方案

CREATE OR REPLACE  FUNCTION find_in_set(str text, strlist text) RETURNS int
AS
DECLARE b1 VARCHAR;
begin
 b1:=array_position(string_to_array($2, ','),$1); 
 RETURN b1;
end;

测试

SELECT t.dept_id FROM sys_dept t WHERE find_in_set(#{deptId}, ancestors) 

方案二，有效

SELECT t.dept_id FROM sys_dept t WHERE find_in_set(#{deptId}, ancestors)
SELECT t.dept_id FROM sys_dept t WHERE position(#{deptId} in ancestors)