New features of Photoshop CS4 include Auto Align and Auto Blend. These can be used to artificially create images with massively increased depth of field. Start with a series of images with limited depth of field, but focused at different points in the scene:

/70731e|5146_9938-premerge.jpg

Photoshop CS4 can combine these images to produce a result like this:

/0c4898|fc2b_9938-edof02.jpg

----