[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source PGBaseTest.cs,1.9,1.
Status: Inactive
Brought to you by:
carlosga_fb
From: <car...@us...> - 2003-07-30 18:39:35
|
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(); } |