Re: Number of rows affected by an update

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: David Witham <davidw(at)unidial(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Number of rows affected by an update
Date: 2003-03-19 08:12:06
Message-ID: 3E782656.8020404@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Uz.ytkownik David Witham napisa?:
> Hi,
>
> Is there a way of capturing how many rows a select, delete or update affect from within a PL/pgSQL function?
Read Postgres documentation.
19.5.5. Obtaining result status

GET DIAGNOSTICS var_integer = ROW_COUNT;

Regards,
Tomasz Myrta

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Victor Yegorov 2003-03-19 08:38:46 vacuum all but system tables
Previous Message David Loh 2003-03-19 05:43:48 Casting with character and character varying