Re: newbie question - delete before insert

On 11/20/2010 02:43 PM, Thomas Kellerer wrote:

Grant Mckenzie wrote on 20.11.2010 07:00:

How do people implement insert or upate ( otherwise known as upsert )
behaviour in postgres i.e. insert a row if it's key does not exist in
the database else update the existing row?

You can simply send the UPDATE, if nothing was updated, it's safe to send the INSERT

Regards
Thomas

something on the line of ....

http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html

Example 38-2. Exceptions with UPDATE/INSERT

-- 


With Regards
Ashish Karalkar