On 1/2/06, Julian Scarfe <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
