'Test PostgreSQL version parsing from `SELECT version()` output'

def test_parsing(self):

    self.assert_parses(u'PostgreSQL    8.3    beta4', 80300)
    self.assert_parses(u'PostgreSQL    8.3', 80300)
    self.assert_parses(u'EnterpriseDB    8.3', 80300)
    self.assert_parses(u'PostgreSQL    8.3.6', 80306)
    self.assert_parses(u'PostgreSQL    8.4beta1', 80400)
    self.assert_parses(u'PostgreSQL    8.3.1    on    i386-apple-darwin9.2.2,    compiled    by    GCC    i686-apple-darwin9-gcc-4.0.1    (GCC)    4.0.1    (Apple    Inc.    build    5478)', 80301)
