Hi,
=20
I have a question in PostGreSQL, please go through below mail:
=20
When I send update query command from front end then PostGreSql is
responding with number of rows affected. But when I send same update
query which is embedded in stored procedure (as listed below) then
PostGreSql doesn't respond with a value of -1.
=20
=20
CREATE OR REPLACE FUNCTION samplepro5(deptid int)
RETURNS void AS
$BODY$
UPDATE EmailLoginUsers SET LoginID =3D 'abc@sample.com Where
UserCheckedMailID =3D $1;
$BODY$
LANGUAGE 'sql' VOLATILE
COST 100;
=20
=20
=46rom front end, I have called above listed stored procedure by using
below listed code:
=20
objNpgSQLCommand.CommandText =3D "samplepro5";
objNpgSQLCommand.CommandType =3D CommandType.StoredProcedure;
NpgsqlParameter objParameter;
objparameter.ParameterName =3D "deptid";
objparameter.NpgsqlDbType =3D NpgsqlTypes.NpgsqlDbType.Integer;
objparameter.Value =3D 1;
objparameter.Direction =3D ParameterDirection.Input;
objNpgSQLCommand.Parameters.Add(objParameter);
int numberOfAffectedRows =3D objNpgSQLCommand.ExecuteNonQuery();
After excuting above code, the value of numberOfAffectedRows was -1 but
database was updated with one record.
=20
Please tell me what's wrong.
=20
Thanks,
Sridhar G
=20
