Re: count record in plpgsql - Mailing list pgsql-sql

From Richard Huxton
Subject Re: count record in plpgsql
Date
Msg-id 41AAEF22.10804@archonet.com
Whole thread Raw
In response to count record in plpgsql  ("Nurdin" <dja.mnurdin@cma-cgm.com>)
List pgsql-sql
Nurdin wrote:
> how can i know the count of record in plpgsql.example if i'm query
> with query komponent from delphi i will know the record count of
> record.but how with plpgsql.

GET DIAGNOSTICS integer_var = ROW_COUNT;

See the manual for details (plpgsql section, "Obtaining the result status").

HTH
--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: count record in plpgsql
Next
From: Christoph Haller
Date:
Subject: version 7.4 autocommit removed