This site begins with basic color definitions, providing examples from well known artists, and expands to psychological effects and responses, print, digital etc. It's worth a moment's (or more!) study, particularly for those who have never mixed pigments.
http://www.writedesignonline.com/resources/design/rules/color.html
http://www.writedesignonline.com/resources/design/rules/color.html