| Subject | Re: [Firebird-Architect] Replace the statement REPLACE |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2006-11-20T09:53:07Z |
Arno Brinkman wrote:
MERGE keyword, so we would have two MERGEs - with a standard syntax and
with a shortcut one. I don't see what problems it would provide us with,
but AFAIS many of you don't like this option.
As for other possibilities, I would prefer INSERT OR UPDATE as the thing
that everyone seems to be comfortable with. Although I have no problems
with REPLACE INTO aside from its a bit non-English nature :-)
Dmitry
>My initial suggestion was to use a shortcut syntax using the standard
> 3 votes for NOT using "REPLACE INTO", but use "UPDATE OR INSERT".
MERGE keyword, so we would have two MERGEs - with a standard syntax and
with a shortcut one. I don't see what problems it would provide us with,
but AFAIS many of you don't like this option.
As for other possibilities, I would prefer INSERT OR UPDATE as the thing
that everyone seems to be comfortable with. Although I have no problems
with REPLACE INTO aside from its a bit non-English nature :-)
Dmitry