Seems like the guy in the link gave a good explanation.
"RCA" is the name of the type of physical connector used for what is properly called "composite video". Calling composite video "RCA" is like calling S-video "mini-DIN".
Composite and S-video are closely related. S-video uses 2 wires to carry the video signal - 1 wire carries the chroma signal, which is the color information for the picture. The second wire caries the luminance signal, which is the brightness information for the picture. The luminance signal can be viewed by itself, since it is really just an old-fashioned black and white picture signal. Keeping the 2 signals separate gives a better picture because the 2 signals can't interfere with each other if they are on separate wires.
If the chroma and luminance information is combined (or "composited") onto a single wire, the result is a composite video signal. So just soldering together the 2 S-video conductors will give you a composite signal.