One source is the fact that when Rav Yochanon became psychotic [Rashi] after causing his beloved student Reish Lakish to die - the Rabbis prayed that he die and he did. This indicates that a state of insanity is worse than death.
Bava Metzia (84a): One day R. Johanan was bathing in the Jordan, when Resh Lakish saw him and leapt into the Jordan after him. Said he [R. Johanan] to him, ‘Your strength should be for the Torah.’ — ‘Your beauty,’ he replied, ‘should be for women.’ ‘If you will repent,’ said he, ‘I will give you my sister [in marriage], who is more beautiful than I.’ He undertook [to repent]; then he wished to return and collect his weapons, but could not. Subsequently, [R. Johanan] taught him Bible and Mishnah, and made him into a great man. Now, one day there was a dispute in the schoolhouse [with respect to the following. Viz.,] a sword, knife, dagger, spear, hand-saw and a scythe — at what stage [of their manufacture] can they become unclean? When their manufacture is finished. And when is their manufacture finished? — R. Johanan ruled: When they are tempered in a furnace. Resh Lakish maintained: When they have been furbished in water. Said he to him: ‘A robber understands his trade.’ Said he to him, ‘And wherewith have you benefited me: there [as a robber] I was called Master, and here I am called Master.’ ‘By bringing you under the wings of the Shechinah,’ he retorted. R. Johanan therefore felt himself deeply hurt, [as a result of which] Resh Lakish fell ill. His sister [sc. R. Johanan's, the wife of Resh Lakish] came and wept before him: ‘Forgive him for the sake of my son,’ she pleaded. He replied: ‘Leave thy fatherless children. I will preserve them alive.’ ‘For the sake of my widowhood then!’ ‘And let thy widows trust in me,’ he assured her. Resh Lakish died, and R. Johanan was plunged into deep grief. Said the Rabbis, ‘Who shall go to ease his mind? Let R. Eleazar b. Pedath go, whose disquisitions are very subtle.’ So he went and sat before him; and on every dictum uttered by R. Johanan he observed: ‘There is a Baraitha which Supports you.’ ‘Are you as the son of Lakisha?’ he complained: ‘when I stated a law, the son of Lakisha used to raise twenty-four objections, to which I gave twenty-four answers, which consequently led to a fuller comprehension of the law; whilst you say, "A Baraitha has been taught which supports you:" do I not know myself that my dicta are right?’ Thus he went on rending his garments and weeping, ‘Where are you, O son of Lakisha, where are you, O son of Lakisha;’ and he cried thus until his mind was turned. Thereupon the Rabbis prayed for him, and he died.


