error of cast with pgsql
Hi Firstly , thanks for this plugin.
I use postgresql instead of mysql and I have the next error:
`limonsurvey-lime-db-1 | 2022-03-22 12:12:44.836 UTC [917] ERROR: operator does not exist: text * integer at character 104
limonsurvey-lime-db-1 | 2022-03-22 12:12:44.836 UTC [917] HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
limonsurvey-lime-db-1 | 2022-03-22 12:12:44.836 UTC [917] STATEMENT: SELECT COUNT(*) FROM "lime_survey_582551" "t" WHERE submitdate IS NOT NULL AND concat('',"582551X4X20" * 1) = "582551X4X20"`
I think that ""582551X4X20" * 1" only works in mysql.
is there any way to fix this?
Thank you in advance.