Brian,
> SELECT count(theAnswer), theAnswer
> FROM (SELECT unnest(string_to_array(answer, ',')) AS theAnswer
> FROM Answers) AS theAnswer
> GROUP BY theAnswer
>
> This seems to work - any gotchas I might be overlooking or a better way
> of finding the totals?
Well, aside from normalizing the data, that's probably as good as it gets.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com