Why not try doing the update and if that fails i.e. returns a value of 0 (no row updated), then do the insert. Thus if your high runner case is that the entry exists, then you are going to bypass having to test if the entry exists.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoff Ellis Sent: Thursday, September 18, 2003 6:41 AM To: [EMAIL PROTECTED] Subject: [ADMIN] Testing for a record before update or insert without using a function. Is it possible to test if a record exists in a table and then if it does do an update on that table or if it doesn't do an insert ? I've looked around the documents and it seems everything points towards a function? Is this the only way or has someone done this before..... TIA Geoff ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
