fix: return interval as string

soedirgo · soedirgo · commit 288baa29ea4b · 2024-07-04T20:56:14.000+08:00
diff --git a/src/lib/db.ts b/src/lib/db.ts
@@ -12,6 +12,7 @@ pg.types.setTypeParser(pg.types.builtins.INT8, (x) => {
   }
 })
 pg.types.setTypeParser(pg.types.builtins.DATE, (x) => x)
+pg.types.setTypeParser(pg.types.builtins.INTERVAL, (x) => x)
 pg.types.setTypeParser(pg.types.builtins.TIMESTAMP, (x) => x)
 pg.types.setTypeParser(pg.types.builtins.TIMESTAMPTZ, (x) => x)
 pg.types.setTypeParser(1115, parseArray) // _timestamp
diff --git a/test/server/query.ts b/test/server/query.ts
@@ -539,3 +539,21 @@ test('very big number', async () => {
     ]
   `)
 })
+
+// issue: https://github.com/supabase/supabase/issues/27626
+test('return interval as string', async () => {
+  const res = await app.inject({
+    method: 'POST',
+    path: '/query',
+    payload: {
+      query: `SELECT '1 day 1 hour 45 minutes'::interval`,
+    },
+  })
+  expect(res.json()).toMatchInlineSnapshot(`
+    [
+      {
+        "interval": "1 day 01:45:00",
+      },
+    ]
+  `)
+})

Original file line number	Diff line number	Diff line change
`@@ -12,6 +12,7 @@ pg.types.setTypeParser(pg.types.builtins.INT8, (x) => {`
`12`	`12`	`}`
`13`	`13`	`})`
`14`	`14`	`pg.types.setTypeParser(pg.types.builtins.DATE, (x) => x)`
	`15`	`+pg.types.setTypeParser(pg.types.builtins.INTERVAL, (x) => x)`
`15`	`16`	`pg.types.setTypeParser(pg.types.builtins.TIMESTAMP, (x) => x)`
`16`	`17`	`pg.types.setTypeParser(pg.types.builtins.TIMESTAMPTZ, (x) => x)`
`17`	`18`	`pg.types.setTypeParser(1115, parseArray) // _timestamp`