Usually there is an open container law, and you can't carry around drinks when you're not in designated areas (or your own home).
Weird about Vancouver, because I remember visiting there and being able to go and order a drink to go. I can't do that here.
When I was in New Orleans, people were drinking all over the place in the French Quarter. Rule was no glass outside.