Unable to Execute query in query table
I am trying to convert a string into integer array everything work fine in postgres but when I am trying to excute the same in zoho analytics its showing an error
QUERY I am trying to achieve
SELECT
round(sum(ear.chainage_to -ear.chainage_from) / 1000) as diff
FROM tableear ear
INNER JOIN tableH H ON H.ID=ANY(STRING_TO_ARRAY(ear.Comma_Separated_values,',')::interger[])
WHERE ear.status = '2'
Error I am getting
Parsing of SQL query failed. Please check the SQL syntax.
Some tips:
Parse error at line 4, column 107. Encountered: []
Please give suggestion to over come this problem