Oh it's really worrying that you post a link to a SO page as the recommended 'cookbook' for something that's referred to as a powerful feature. And both of the answers only have a single up vote each. Seems like there's a serious gap here.
You can help out by posting answer / upvoting good answer.
I don't think Stack Overflow is a good place for good documentation. I think the Postgres documentation should be better.