Is it really possible to use real nappies at night?

Many parents who use real nappies on their baby during the day would never trust them for nights. What’s your experience?