Hi,
As far as I know, most compact cameras used CCD sensors mostly made by Sony. The G9 had a CCD sensor according to DxO-mark for instance, that was 2007. I don't know if that was a Sony sensor, there were quite a few vendors than as there are quite a few vendors now.
Best regards
Erik
Anything specific ?