What's the difference between a rich Scotsman, a puir Scotsman, and a deid Scotsman?

The rich Scotsman has a canopy over his bed. The puir Scotsman has a can o' pee under his bed. The deid Scotsman canna pee at a'.