Is it a commonly known fact that one-night-stands should stay one night stands?

Don’t mean to sound piggish and I’m sorry for my double question marks, it’s become my trademark. Ok, so, I’m under the impression because I’ve learned from somewhere or someone, be it the media or some drunken bar conversation with a man older than I’ll ever be, that when you have a one nighter you should sneak away like a thief in the night. Also that you shouldnt try to stay friends with this person, partly based on the logic that you were both drunk and werent in your right minds. That unless you can manage to stay drunk, it’s just not going to work out. Is this true, and is it common knowledge??