Avoid strange data type mismatch error.

James William Pye · James William Pye · commit 397aedcfd2e4 · 2009-05-25T07:19:40.000-07:00
diff --git a/postgresql/test/test_driver.py b/postgresql/test/test_driver.py
@@ -649,13 +649,13 @@ def testProcExecution(self):
 		self.failUnlessEqual(ifoo(1), 1)
 		self.failUnlessEqual(ifoo(None), None)
 		self.db.execute(
-			"CREATE OR REPLACE FUNCTION ifoo(varchar) RETURNS varchar LANGUAGE SQL AS 'select $1'"
+			"CREATE OR REPLACE FUNCTION ifoo(varchar) RETURNS text LANGUAGE SQL AS 'select $1'"
 		)
 		ifoo = self.db.proc('ifoo(varchar)')
 		self.failUnlessEqual(ifoo('1'), '1')
 		self.failUnlessEqual(ifoo(None), None)
 		self.db.execute(
-			"CREATE OR REPLACE FUNCTION ifoo(varchar,int) RETURNS varchar LANGUAGE SQL AS 'select ($1::int + $2)::varchar'"
+			"CREATE OR REPLACE FUNCTION ifoo(varchar,int) RETURNS text LANGUAGE SQL AS 'select ($1::int + $2)::varchar'"
 		)
 		ifoo = self.db.proc('ifoo(varchar,int)')
 		self.failUnlessEqual(ifoo('1',1), '2')
