ERROR:0A000:set-returningfunctionsarenotallowedinindexexpressionsLINE1:createindexidx_a_1ona (jsonb_array_elements(js)); ^LOCATION: check_srf_call_placement, parse_func.c:2251 5、创建一个UDF,将SRF结果转换为ARRAY postgres=#createor replacefunctionsrf_to_arr(jsonb)returnstext[]as$$selectarray(s...
SQL error "0A000" - ERROR: set-returning functions are not allowed in CASE LINE 4:... expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_mem...^ HINT: You might be able to move the set-returning function into a LATERAL FROM item.QUERY:SELECT group_idFROM group_memberWHERE ...