Ritchie,
I think we're all thinking of the tune played by David Bromberg on his album of the same name. It was written by Benny Thomason, but (I think) credited to Luke Thomason.

I've heard other words put to this tune. I can't remember them all, but I'll look them up. Here are the first two lines:

There are times when I'm so blue thinking of you and me
At midnight on the water and how it used to be.