From what I understand, it was a poor-quality wine. In fact, the word "vinegar" comes from the French "vin aigre" which essentially means "sour wine." Vinegar can be made from wine, beer, fruit juice, and lots of other stuff. The vinegar offered to Jesus was obviously wine vinegar, then.
So, when Jesus asked for a drink, they gave him extremely sour/bitter wine.