"Pretend" update

Поиск
Список
Период
Сортировка
От Perry Smith
Тема "Pretend" update
Дата
Msg-id 1444DFEC-2E77-482C-8068-A180BDC8D3B3@gmail.com
обсуждение исходный текст
Ответы Re: "Pretend" update  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
With "make" I can do "make -n" and it just tells me what it would do but doesn't actually do anything.

How could I do that with SQL?

I want to write a really complicated (for me) SQL UPDATE statement.  I'm sure I won't get it right the first time.  Is
therean easy way to not really make the changes? 

I've thought about starting a transaction and then roll it back.  That would undo the changes.  But I won't be able to
tellwhat the changes were. 

Thank you for your time,
Perry


Вложения

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

Предыдущее
От: Carlos Eduardo Sotelo Pinto
Дата:
Сообщение: Help on ṕerformance
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: "Pretend" update