I've been asked to move a blog away from using wordpress but to keep all posts, i've noticed wordpress seems to use a post/revision system in the sql db.
If it do something like this:
SELECT * FROM
wp_websitename_2009_posts WHERE post_type="post"
Will this give me all blog posts which are up to date, or do the revision posts hold the updated blog entries for these posts?