X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 50F223A4D58
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Nov 2004 09:30:23 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 38940-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Nov 2004 09:30:13 +0000 (GMT)
Received: from bt2.jordan.pl (unknown [62.121.132.241])
	by svr1.postgresql.org (Postfix) with ESMTP id 04BBA3A4C01
	for <pgsql-sql@postgresql.org>; Mon, 29 Nov 2004 09:30:12 +0000 (GMT)
Received: from localhost (localhost [127.0.0.1])
	by bt2.jordan.pl (Postfix) with ESMTP id 92DF819C009;
	Mon, 29 Nov 2004 10:29:40 +0100 (CET)
Received: from bt2.jordan.pl ([127.0.0.1])
	by localhost (bt2 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
	id 18547-09; Mon, 29 Nov 2004 10:29:39 +0100 (CET)
Received: from [192.168.24.1] (chello083144087237.chello.pl [83.144.87.237])
	by bt2.jordan.pl (Postfix) with ESMTP id 728DB19C002;
	Mon, 29 Nov 2004 10:29:39 +0100 (CET)
Message-ID: <41AAEC39.3060600@klaster.net>
Date: Mon, 29 Nov 2004 10:30:33 +0100
From: Tomasz Myrta <jasiek@klaster.net>
Organization: KLASTER
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: Nurdin <dja.mnurdin@cma-cgm.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: count record in plpgsql
References: <005a01c4d5bb$8d27e860$8a030b0a@JACARTA.CMACGM.COM>
In-Reply-To: <005a01c4d5bb$8d27e860$8a030b0a@JACARTA.CMACGM.COM>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at bt2.jordan.pl
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200411/281
X-Sequence-Number: 19599


> 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