From: Tomasz Myrta <jasiek@klaster.net>
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 10:30:33 +0100
Message-ID: <41AAEC39.3060600@klaster.net> (raw)
In-Reply-To: <005a01c4d5bb$8d27e860$8a030b0a@JACARTA.CMACGM.COM>
References: <005a01c4d5bb$8d27e860$8a030b0a@JACARTA.CMACGM.COM>
> 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.
>
> any ideas?
Is it what you need:
GET DIAGNOSTICS n = ROW_COUNT;
after executing query ?
Regards,
Tomasz Myrta
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: jasiek@klaster.net, dja.mnurdin@cma-cgm.com
Subject: Re: count record in plpgsql
In-Reply-To: <41AAEC39.3060600@klaster.net>
* 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