Thread: 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
Re: Testing for a record before update or insert without using a function.
From
"Chris White (cjwhite)"
Date:
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: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Geoff Ellis Sent: Thursday, September 18, 2003 6:41 AM To: pgsql-admin@postgresql.org 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