or clerics/paladins could use magic to heal them, which iirc (not 100% sure about this) gets them back up if they go back to positive hp.
In 3rd Edition, at least, this is true. Their bleeding out is also stabilized if they receive
any form of healing, such as a Cure Minor Wounds or having a Goodberry shoved down their throat(wait, does that work?), even if their hitpoints are still -9 - 0, though they go back to dying if they receive any damage after that.
The if I remember correctly(though I only played the demo), in Baldur's Gate II you can't resurrect {
Khaleid} because {
his} corpse was desecrated, not just dissected.
Arcanum: Of Steamworks and Magick Obscura has an interesting take on this. Except for your character(and don't know if it's ever explained why), it's supposedly possible to resurrect
anyone at
any time, by a sufficiently-skilled master of White Necromancy(healing magic, though some forms of Black Necromancy can probably pull it off) at only the cost of the mental concentration of the spell. Even a skilled technologist can do it using a device that's essentially built from scrap.
Kergan, the main villain, wants to wipe out all life to prevent there ever being anyone capable of casting resurrection. It's not strictly an evil desire; having been dead and resurrected before, he feels that being dead is a lot more peaceful than the conflicts of life. If you've done Vergil's sidequest, which involves him getting killed and being resurrected, he concedes that Kergan has a point. If you're a master of persuasion, you can convince him to allow you to use a device(which you were going to do anyway if you don't join him) that completely cuts his soul from life, permanently preventing him from resurrection, which is what he really does want.
There are some quest-related dead people who cannot be resurrected for some reason; trying will result in saying that there's powerful magic preventing it. Oddly, you can raise zombies from them and conjure their spirit, but they have nothing to say(the latter because conjure spirit is
extremely torturous, especially if they've recently died and are reliving their death).
Another game is an H-game RPG {
Knights of Xentar} where if any of your characters reach 0 HP, they're dead and it's game over.
Yet another game(this one is NOT an H-game) is Darklands, where two stats are involved: Strength and Endurance. You lose both when hit. If your Endurance hits zero, you're unconscious and if your party is wiped out what happens is dependent on what you're fighting - wild animals will probably kill and eat one or more of your party, bandits will steal your stuff and leave you to die, etc. Strength on the other hand, if that hits zero you're dead, and since it's mythologically accurate medieval Germany, you can't come back because only Jesus can do that. The idea is that, particularly with good armor, Endurance will drain faster than Strength.