libpq doing strange things

Hi,

Is there some undocumented feature in libpq to do with executing update 
queries? I just programmed my mail server to put a mark next to a users name 
whenever they check their email, but for some reason the update query does 
not execute properly. It returns PGRES_COMMAND_OK, and if i check the text 
output of the query it says its updated one record. I know that the 
connection is working ok, because it extracts the password and username from 
the database ok in the query before. Is there any other way to check what is 
going wrong, or is there something else i should be doing i don't know about? 
all i do is load the query into a string using sprintf, and then use that 
string to execute the query like PGexec (conn, string)
Heres the exact query and commands in case it helps:

       snprintf (ptr, 256, "update accounting set mail = 1 where time_stamp 
in (select max (time_stamp) from accounting where username='%s') and 
username='%s';", pinfo->userid, pinfo->userid);       syslog(LOG_ERR,ptr);       res2 = PQexec (conn, ptr);       if
(PQresultStatus(res2)!= PGRES_TUPLES_OK) syslog(LOG_ERR, 
 
PQresStatus(PQresultStatus(res2)));

and the output in the syslog is like:

Jan  4 09:21:49 spa teapop[17449]: update accounting set mail = 1 where 
time_stamp in (select max (time_stamp) from accounting where username='bsn') 
and username='bsn';
Jan  4 09:21:49 spa teapop[17449]: PGRES_COMMAND_OK

which seems like it should be doing ok. Can anyone shed some light on what 
might be causing this problem?

Thanks,Daniel Andersen