I've had a death in the family.
What 'pastoral' response have we had:
From the paid pastor wonderful...training brings its benefits...he listened quietly and gently encouraged the conversation.
From others in 'ministry' roles, but unpaid: a copy of an insulting book by on grief and death by the Dutch Roman 'priest' Henri Nouwen, a card with a verse of a psalm in very poor distorting translation, and wanting to 'help'. See the paragraph above for the receipe for that.
Others come out with that great conversation ender: "I'll pray for you."
Maybe this is good to say sometimes, but rarely...and only after proper loving attention has been committed to the conversation. Too often "I'll pray for you" is the conversation killer because the speaker does not have the ability to engage in a conversation without 'giving advice' but doesn't know what else to do. Again, see the receipe for this above!
The recipe, to summarise: simply act like a decent friend and listen, no santimonious self agrandizement please. And of course you'll pray; you are a Christian aren't you? No song and dance about it, please. It is unhelpful.