Don't forget defraction
In each case this is the maximum F-stop to get the full resolution of the camera. It is perfectly OK to stop the lens down further than this, but know that when you do, you will be getting less than the full resolution. This may or may not matter.
Canon 5D : F9
Canon 1Ds: F9
Canon 1Ds Mark II : F8
Nikon D2X : F5.6
Canon 20D : F7.1
Canon G7 : F2
So, for example, if you take a Canon EOS 1Ds Mark II and stop it down to F9, you are going to get greater depth of field, but you will not get the full 16 million pixel resolution – instead you'll get resolution more like a 5D or 1Ds. When I know that I want to make a very large print, I stay at or below the maximum f-stop for diffraction limited resolution.
In the case of the Canon G7 it is diffraction limited at F2. Yet the minimum aperture on the camera is F2.8. What this means is that the camera NEVER can deliver its full stated 10 megapixel resolution. Diffraction will limit it to less than this. The 10 megapixel sensor is thus more of a marketing slogan than reality. It suggests that if Canon wants to come out with a G8 camera, then there is no point in going beyond 10 megapixels – they’d better either upgrade the lens, or admit that diffraction limits the resolution to less than what the sensor is producing.