From what I know:
A Bayer filter array CCD has RGB colour filters over the pixels, with twice as many greens ones. A 4Mp sensor would have 1m red, 1m blue and 2m green. Each colour channel uses Bayer interpolation to fill in the gaps and the colour channels are combined for the final image.
A SuperCCD is similar, but with octagonal photo sites.
A Foveon type has an red, green and blue sensor at each pixel location, so a 3Mp Foveon produces a 1Mp image, but as there is no interpolation the image is sharper.
Is this correct? Someone is telling me that a standard CCD has pixels made of three subpixels, like a monitor.
Thanks in advance