| 631 | self.assertEqual(big, naive_big) |
| 632 | |
| 633 | async def test_interval(self): |
| 634 | res = await self.con.fetchval("SELECT '5 years'::interval") |
| 635 | self.assertEqual(res, datetime.timedelta(days=1825)) |
| 636 | |
| 637 | res = await self.con.fetchval("SELECT '5 years 1 month'::interval") |
| 638 | self.assertEqual(res, datetime.timedelta(days=1855)) |
| 639 | |
| 640 | res = await self.con.fetchval("SELECT '-5 years'::interval") |
| 641 | self.assertEqual(res, datetime.timedelta(days=-1825)) |
| 642 | |
| 643 | res = await self.con.fetchval("SELECT '-5 years -1 month'::interval") |
| 644 | self.assertEqual(res, datetime.timedelta(days=-1855)) |
| 645 | |
| 646 | async def test_numeric(self): |
| 647 | # Test that we handle dscale correctly. |