Thread: INSERT OR UPDATE WITHOUT SELECT
Hi, Is there a command to Insert a record If It does not exists and a update if It exists? I do not want to do a select before a insert or update. I mean the postgres should test if a record exist before insert and if It exist then the postgres must do an update instead an insert. Thanks, WMiro.
am 30.05.2006, um 17:47:47 -0300 mailte wmiro@ig.com.br folgendes: > Hi, > > Is there a command to Insert a record If It does not exists and a update if > It exists? Not a single command, but a solution: http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===