Re: update returns 1, but no changes have been made

Поиск
Список
Период
Сортировка
От James Thornton
Тема Re: update returns 1, but no changes have been made
Дата
Msg-id 3C0CCFB3.5A9C614B@cs.baylor.edu
обсуждение исходный текст
Ответ на update returns 1, but no changes have been made  (James Thornton <thornton@cs.baylor.edu>)
Список pgsql-general
Gregory Wood wrote:
> If you return old from an UPDATE, no changes are made (it takes the old
> values and puts them into the database rather than your new values). Of
> course you need to return old from a DELETE (new doesn't exist in a delete
> trigger)...

That was it -- thanks for your help Gregory.


 JT
________________________________________
James Thornton, http://jamesthornton.com

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

Предыдущее
От: "Travis Bear"
Дата:
Сообщение: use BLOBS or use pointers to files on the filesystem?
Следующее
От: mgundlach@comosoft.de (Michael Gundlach)
Дата:
Сообщение: Re: Large tables management question