Re: How to find the number of rows deleted

From: Ropel <ropel(at)ropel(dot)it>
To: Andrus <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to find the number of rows deleted
Date: 2005-07-18 11:22:31
Message-ID: 42DB90F7.7070805@ropel.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2005-07-18 11:24:07 Re: How to create unique constraint on NULL columns
Previous Message Janning Vygen 2005-07-18 11:19:22 Changes to not deferred FK in 8.0.3 to 7.4?