On 1/2/06, Julian Scarfe <julian@xxxxxxxxxxx> wrote: > I'm keeping config information for an application in a series of related > tables. I'd like a command that INSERTs data if it's new, or UPDATEs it if > the key is duplicated. A MERGE trigger will do exactly what you are asking for. http://archives.postgresql.org/pgsql-sql/2004-05/msg00135.php Send all your data as INSERTS. The trigger will run a function to see if the row exists. If the row exists -> rewrite it as it as an UPDATE If the row does not exist -> leave the INSERT alone Tony
