create table test1 as (
select
aaaa,
trim(BOTH from unnest(string_to_array(initcap(bbbbb),';'))) as ccccc
from mytable
);;That trim function there works in postgresql, but throws an error in the JSQLParser. Stack trace:
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:137)
at com.shonetic.esquel.analyzer.tester.run(tester.java:30)
at com.shonetic.util2.ScriptClass.doMain(ScriptClass.java:240)
at com.shonetic.esquel.analyzer.tester.main(tester.java:36)
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 4, column 7.
That trim function there works in postgresql, but throws an error in the JSQLParser. Stack trace: