No, it wont work automatically. You need to enable xinerama extensions in xorg.conf, and edit your serverlayout for the two heads. You need to decide whether you want one big desktop, or just two identical displays. You also need to rebuild your WM/Desktop software to support xinerama if it doesn't already.
This guide is kind of old, but should get you started: