NOOOO! Consecutive responses from ejmartin, BJL, and bjanes!? The concentration of expertise is reaching dangerous levels. Please disperse immediately to other web sites or the informative value of this thread may reach critical mass and go supernova.
I will try to water it down with the usual inaccurate rules of thumb, common misconceptions, and old wive's tales. Just give me a minute to come up with some inappropriate ones.
EDIT: Sorry, I just couldn't come up with anything that was incorrect or misleading, so I'm going try for on-topic and informative instead.
On the other hand, my understanding was that diffraction in general was related to the relationship between the size of the interfering object and the wavelength, that is the ratio of the absolute sizes. Thus, say if you're looking several lenses at f/10 (to make the math easy) a one meter lens would have a working aperture of 100mm and a 100mm lens would have a working aperture of 10mm, a 10mm superwide, one of only 1mm! It would seem that, assuming that the working wavelengths of light are the same, the amount of diffraction through a 1mm hole and its effect upon the sensor would be quite different than coming through a 100mm one.
Now I did look at the airy disk math and this is apparently not the case, and the fact is that for a given camera the loss of sharpness at f/10 would be identical for both the 10mm and 1,000 mm lens. I just don't understand why.
I'm going to repeat what BJL said in a different way. The amount of diffraction "per subject detail" *does* scale with iris diameter. To demonstrate:
In the 1000mm f/10, the subject (say a bird) is very large and nearly fills the frame. Diffraction softens just the minutest feather details.
In the 100mm f/10, the bird is now much smaller, only occupying the tiny center portion of the frame. Diffraction blur is still the same number of pixels, but since the subject is now covering a smaller number of pixels, it is more greatly affected by the diffraction.
In the 10mm f/10, the bird is so small in the frame that nearly all the detail is obscured by diffraction.
Some photographers are not aware of this, so you will hear things like "I crop digitally instead of use a 2X TC because the two-stop increase in diffraction causes too much detail loss." But diffraction is actually the same.
Hope that helps.