Re: [PERFORM] INSERT OR UPDATE WITHOUT SELECT

2006-06-04 Thread A. Kretschmer
am 30.05.2006, um 17:47:47 -0300 mailte [EMAIL PROTECTED] 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-E

[PERFORM] INSERT OR UPDATE WITHOUT SELECT

2006-06-03 Thread wmiro
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,