Re: INSERT ON DUPLICATE KEY UPDATE

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: INSERT ON DUPLICATE KEY UPDATE
Дата
Msg-id 40D32E2A.2020201@archonet.com
обсуждение исходный текст
Ответ на Re: INSERT ON DUPLICATE KEY UPDATE  (Eduardo Pérez Ureta <eperez@it.uc3m.es>)
Ответы Re: INSERT ON DUPLICATE KEY UPDATE  (Eduardo Pérez Ureta <eperez@it.uc3m.es>)
Список pgsql-general
Eduardo Pérez Ureta wrote:
> On 2004-06-18 17:19:40 UTC, Duane Lee - EGOVX wrote:
>
>>I would suspect you would need to write a trigger to do this.
>
>
> It seems the mysql way of doing this is easier and safer.

And non-standard AFAIK.

> Why is that not implemented in postgresql?
> Is it better done with a trigger or with any other way?

Out of curiosity, why don't you know whether you're inserting or
updating? It always worries me when I don't know what my application is
doing.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Eduardo Pérez Ureta
Дата:
Сообщение: Re: INSERT ON DUPLICATE KEY UPDATE
Следующее
От: Robert Fitzpatrick
Дата:
Сообщение: Re: Trigger to update records out of memory