Bruno Wolff III wrote:
On Thu, Aug 21, 2003 at 12:56:18 -0400,
Edmund Dengler <[EMAIL PROTECTED]> wrote:
Wasn't there a feature in some SQL database which was the equivalent of
UPDATE OR INSERT ... based on the primary key? Would this accomplish what
you want (I know that I have a desire for this feature a couple of times,
as I simply have code or triggers to essentially do the equivalent)? Is
this a desirable feature for Postgresql?
I remember people asking for the equivalent of MYSQL's REPLACE command in previous threads.
Another alternative is allowing the clients to determine what do do after an error so that you could try an insert first and then do an update if it failed without aborting your transaction.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
