Hmm, some light misinformation is being disseminated here (in my opinion). Adobe Lightroom and Adobe Photoshop are very different products, made for different purposes. I like to think of it this way:
Adobe Lightroom = Adobe Bridge + Adobe Camera Raw
Adobe Photoshop = Adobe Lightroom (via Camera Raw and Bridge) + the ability to perform significant digital editing.
Lightroom can be photographers best friend because it catalogs thousands of photos superbly and does so using metadata that is stored in a central database away from the photos themselves. This combined with Lightrooms ability to perform non-destructive and dramatic adjustments to RAW digital files make it a premier tool. It does not, on the other hand, replace Photoshop's ability to perform significant digital editing to photos and make artistic, finite adjustments to details.
Here's a link to a photo I editing for my potfolio: http://www.flickr.com/photos/daxalexander/5230919502/
I took it using my Nikon DSLR tethered to my laptop using Lightroom 3's Capture function. I made some exposure adjustments (basically fake bracketing) in Lightroom, and then took it into photoshop for a great deal of finite airbrushing, making, and compositing. I wouldn't have been able to achieve the photo without using both.
Again, this is just my opinion for what it's worth.