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