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
Error Details:
Parsing of SQL query failed. Please check the SQL syntax.
Some tips:
Parse error at line 4, column 107. Encountered: []