The behavior you're talking about is actually implemented by the script itself, not Apache. That is, note the following site on the official WordPress blog site, which does the same thing (this is just a random blog I found on the front page):
http://bestblog.wordpress.com/2007/06/13/elle-effect/
The same URL can be accessed by going to any combination of the following:
This "pretty URL" is actually enforced by mod_rewrite rules, which rewrites the URL to something that the script can understand, i.e.:
RewriteRule ^([12][0-9]{3})/([0-9]{2})/([0-9]{2})/(.*)$ /somescript.php?year=$1&month=$2&day=$3&title=$4
And so on. The script receives the post title, realizes there's nothing by that name, and searches for titles in the database to see if it can find a match. If it does, it redirects.
I really hope this clarifies what you're looking for!
Andrew