SD900 is a nice camera, they're going to be releasing the SD1000 too if it isn't yet already out. We have a 5 megapixel SD500 for over a year now, it still works great and takes really good pictures.
Here's a review of the SD900:
http://www.steves-digicams.com/2006_reviews/sd900.html