Re: How to find the number of rows deleted

Поиск
Список
Период
Сортировка
От Ropel
Тема Re: How to find the number of rows deleted
Дата
Msg-id 42DB90F7.7070805@ropel.it
обсуждение исходный текст
Ответ на How to find the number of rows deleted  ("Andrus" <eetasoft@online.ee>)
Список pgsql-general
At least, you can do a "select count(*) from ..." just before the
delete, better if inside a transaction, if the query itself is not too
much expensive

Andrus wrote:

>I ran DELETE command from my ODBC client application.
>I want to get the number of rows deleted by this DELETE command.
>
>I read the DELETE command docs but havent found any function.
>
>Any idea ?
>
>Andrus.
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
>
>
>



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

Предыдущее
От: Janning Vygen
Дата:
Сообщение: Changes to not deferred FK in 8.0.3 to 7.4?
Следующее
От: "David Esposito"
Дата:
Сообщение: Re: index bloat