Need to add explicit type casts error, after install with PostgreSQL


I tried to install using the pwd.yml docker file with PostgreSQL 13.9/14.6
However after installation and login, I got this error while clicking some modules like CRM, stock, buying.

	"erpnext": "14.15.1",
	"frappe": "14.25.1"

Error in query:
function if(boolean, numeric, unknown) does not exist
LINE 1: select t2.item_code, t2.item_name,SUM(IF(t1.transaction_date...
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Is there some settings I need to do to let ERPNext fully compatible with PostgreSQL?

found this, maybe there’s some more to fix