Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv3457
Modified Files:
PGBaseTest.cs
Log Message:
Added creation of a new function for use with DeriveParameters test
Index: PGBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGBaseTest.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** PGBaseTest.cs 28 Jul 2003 18:26:41 -0000 1.9
--- PGBaseTest.cs 30 Jul 2003 18:39:32 -0000 1.10
***************
*** 170,173 ****
--- 170,185 ----
PGCommand command = new PGCommand(commandText.ToString(), connection);
command.ExecuteNonQuery();
+
+ commandText = new StringBuilder();
+ commandText.Append("CREATE OR REPLACE FUNCTION public.DeriveCount(int4)");
+ commandText.Append("RETURNS int8 AS");
+ commandText.Append("'");
+ commandText.Append("select count(*) from test_table where int4_field < $1;");
+ commandText.Append("'");
+ commandText.Append("LANGUAGE 'sql' VOLATILE;");
+
+ command.CommandText = commandText.ToString();
+ command.ExecuteNonQuery();
+
command.Dispose();
}
|
