I have a table similar to what is below. I have listed only one column since that's what I'm interested in.
| column --------- | foo | foo | foo | bar | bar | bar
Below is the output that I desire but I can't seem to figure out how to make it happen. This column is not a primary key or serial key.
| column --------- | foo 1 | foo 2 | foo 3 | bar 1 | bar 2 | bar 3
I want to increment the string if there are duplicates.