I take it, following this thread, is that REPLACE is not in the SQL
standard?
Bruno Wolff III wrote:
>On Thu, Aug 21, 2003 at 12:56:18 -0400,
> Edmund Dengler <edmundd@eSentire.com> 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
>
>
>