Where does Catholicism stand on suicide (the soul of someone who committed suicide)

In the bible, is there somewhere where it says that the souls of those who commit suicide go to purgatory?

I know of an instance where someone committed suicide, yet, his funeral was held in a Catholic Church and he had a Catholic burial.