Hello,
I am using Odoo16 Enterprise edition with postgresql version 14.8
and I am facing this error.
I am looking forward to your solutions.
Thank you.


self._cr.execute(f'''
  File "/opt/odoo16/odoo/odoo/sql_db.py", line 321, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function substring(jsonb, integer, integer) does not exist
LINE 2: ...           select am.id,am.invoice_date as ldate, SUBSTRING(...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.