From: Richard Huxton <dev@archonet.com>
To: Nurdin <dja.mnurdin@cma-cgm.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: count record in plpgsql
Date: Mon, 29 Nov 2004 09:42:58 +0000
Message-ID: <41AAEF22.10804@archonet.com> (raw)
In-Reply-To: <005a01c4d5bb$8d27e860$8a030b0a@JACARTA.CMACGM.COM>
References: <005a01c4d5bb$8d27e860$8a030b0a@JACARTA.CMACGM.COM>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, dja.mnurdin@cma-cgm.com
Subject: Re: count record in plpgsql
In-Reply-To: <41AAEF22.10804@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox