I see you're leaning towards the G9, so I'm just going to throw something else in to confuse the situation. 
Looking at Amazon prices, the G9 is $450. The Nikon D40 is $480. I would think long and hard about this.
The G9 has longer zoom range, but is not as wide. The G9 has higher MP, but that's not always a good thing. The G9 has movie mode, but honestly, movie mode in just about all cameras are terrible and not that useful (no zoom during filming).
The D40 is so much more flexible. There's more room to grow into a dSLR. And no one else has mentioned this, but you'd probably learn more with a proper dSLR than with a P&S (even a hi-end P&S like the G9). To start, put the D40 in Full Auto mode and shoot away. Study the information on the photos that turn out well and match those settings in the "manual" modes (I guess you could do the same with the G9).
When you have more money to spend, buy some other lenses. You won't have to learn a whole new camera.
As for shooting video, that's best done with a camcorder. Now, I know that camcorders can be a hassle, but a nice miniDV camcorder can be had new for around $300. Also, there are some neat "HD" camcorders that record onto SD cards. Look up Aiptek .. they sell them in Circuit City and other places. Not sure which one is the good one. I saw a clip posted (I think in the Video forum) and it wasn't bad. They go for about $130 or so.
You can compare the video from the Aiptek (if you can find it) vs. the G9 and other digicams. www.dcresource.com has downloadable video clips included in their reviews.
Good Luck
ft
Looking at Amazon prices, the G9 is $450. The Nikon D40 is $480. I would think long and hard about this.
The G9 has longer zoom range, but is not as wide. The G9 has higher MP, but that's not always a good thing. The G9 has movie mode, but honestly, movie mode in just about all cameras are terrible and not that useful (no zoom during filming).
The D40 is so much more flexible. There's more room to grow into a dSLR. And no one else has mentioned this, but you'd probably learn more with a proper dSLR than with a P&S (even a hi-end P&S like the G9). To start, put the D40 in Full Auto mode and shoot away. Study the information on the photos that turn out well and match those settings in the "manual" modes (I guess you could do the same with the G9).
When you have more money to spend, buy some other lenses. You won't have to learn a whole new camera.
As for shooting video, that's best done with a camcorder. Now, I know that camcorders can be a hassle, but a nice miniDV camcorder can be had new for around $300. Also, there are some neat "HD" camcorders that record onto SD cards. Look up Aiptek .. they sell them in Circuit City and other places. Not sure which one is the good one. I saw a clip posted (I think in the Video forum) and it wasn't bad. They go for about $130 or so.
You can compare the video from the Aiptek (if you can find it) vs. the G9 and other digicams. www.dcresource.com has downloadable video clips included in their reviews.
Good Luck
ft