如何在postgresql中第4次出现字符之前剪掉字符串？

I know in a lot of databases the charindex function can accept getting the character on the third occurrence but the strpos in postgresql doesn't accept it.I know in a lot of databases the charindex func