Re: [Dbmail] Patch for mysql/dbmysql.c

2002-12-18 Thread Philip Warner
At 02:00 PM 18/12/2002 +1300, Craig Whitmore wrote: The postgreSQL version hasn't been changed as I don't know if if it has a similar command as REPLACE that mysql does. It doesn't, so no need to worry about that. Philip Warner

[Dbmail] Patch for mysql/dbmysql.c

2002-12-18 Thread Craig Whitmore
Hi there DBMailers.. Below is a patch for mysql/dbmysql.c to make the update of the pbsp table easier. It uses the command REPLACE which will do an INSERT or an UPDATE depending of the entry is there or not. This means only 1 SQL query instead of 2 (1 to see if its there and one to INSERT or UPDAT