Re: "SQL" REPLACE SYNTAX

> Why so many? It is simple enough to attempt a delete and then do an
> insert.

DELETE WHERE what? Alternatively you can attempt and update then do an
insert - question is UPDATE WHERE what?

If the insert fails you need to select from the postgres system catalogs to
find the primary key on the table (if there is one). Next, you need to find
the fields that that primary key is defined over. Next, you need to parse
the insert statement and find the fields being inserted that match the
primary key. Lastly you need to modify the insert statment to an update
statment, take out the values that are part of the primary key and make them
part of the where clause of the update or delete statement.

Chris