Re: someone working to add merge?

Поиск
Список
Период
Сортировка
От John Hansen
Тема Re: someone working to add merge?
Дата
Msg-id 5066E5A966339E42AA04BA10BA706AE50A93B0@rodrick.geeknet.com.au
обсуждение исходный текст
Ответ на someone working to add merge?  (Jaime Casanova <systemguards@gmail.com>)
Список pgsql-hackers
I Wrote:

> From the mysql manual:
>
> 'REPLACE works exactly like INSERT, except that if an old
> record in the table has the same value as a new record for a
> PRIMARY KEY or a UNIQUE index, the old record is deleted
> before the new record is inserted. See Section 13.2.4,
> "INSERT Syntax".'

It also says:
Note that unless the table has a PRIMARY KEY  or UNIQUE index, using a
REPLACE statement makes no sense. It becomes equivalent to INSERT,
because there is no index to be used to determine whether a new row
duplicates another.


... John


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "John Hansen"
Дата:
Сообщение: Re: someone working to add merge?
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: MERGE vs REPLACE