For all the Wordpress users here's a link to a plugin that works pretty well...
http://rawlinson.us/blog/index.php?p=212
For Pivot users go to the Pivot Help files and look at the Tags section,
http://www.pivotlog.net/help/help_template_tags.php
Then look for this tag: [[rss]] and you'll have what you need.