Compact camera and low light are like oil and water.
They do not mix.
Any camera that has a full set of manual controls can do OK in low light.
None of the ultra small, ultra thin cameras have manual controls.
The Canon A75 (now replaced by the A510)is about the smallest camera with manual controls.
To function well in low light, you will have to learn how to use the manual controls. In low light situations, any digital camera in auto mode will very seldom select the proper settings.
...
..
.
I'm looking for a compact camera that works well in low light conditions.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic