From dja.mnurdin@cma-cgm.com Mon Nov  29 02:30:25 2004
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 3EB2C3A4D95
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Nov 2004 02:30:25 +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 99505-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Nov 2004 02:30:20 +0000 (GMT)
Received: from mms22bas.mms.us.syntegra.com (relay22.mms.us.syntegra.com
	[192.12.251.30])
	by svr1.postgresql.org (Postfix) with ESMTP id 3CAEB3A4BEA
	for <pgsql-sql@postgresql.org>; Mon, 29 Nov 2004 02:30:20 +0000 (GMT)
Received: from mms24es.mms.us.syntegra.com (mms24es.mms.us.syntegra.com
	[150.143.232.70]) by mms22bas.mms.us.syntegra.com with ESMTP
	for pgsql-sql@postgresql.org; Mon, 29 Nov 2004 02:30:20 Z
Received: from mms22bas.mms.us.syntegra.com (mms22bas.mms.us.syntegra.com
	[192.12.251.30]) by mms24es.mms.us.syntegra.com with ESMTP for
	pgsql-sql@postgresql.org; Mon, 29 Nov 2004 02:30:20 Z
Received: from cmamail.cma-cgm.com (cmamail.cma-cgm.com [193.109.119.1]) by
	relay22.ob.gen.mms.us.syntegra.com with ESMTP for
	pgsql-sql@postgresql.org; Mon, 29 Nov 2004 02:30:19 Z
Received: from CMAP4110 ([10.11.3.138] [10.11.3.138]) by cmamail.cma-cgm.com
	for pgsql-sql@postgresql.org; Mon, 29 Nov 2004 03:29:01 +0100
Message-Id: <005a01c4d5bb$8d27e860$8a030b0a@JACARTA.CMACGM.COM>
Reply-To: "Nurdin" <dja.mnurdin@cma-cgm.com>
From: "Nurdin" <dja.mnurdin@cma-cgm.com>
To: "pgsql-sql" <pgsql-sql@postgresql.org>
Subject: count record in plpgsql
Date: Mon, 29 Nov 2004 09:31:35 +0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0057_01C4D5F6.387E2A00"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=HTML_50_60,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200411/280
X-Sequence-Number: 19598

This is a multi-part message in MIME format.

------=_NextPart_000_0057_01C4D5F6.387E2A00
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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?

thnx
best and regard

nurdin
------=_NextPart_000_0057_01C4D5F6.387E2A00
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1476" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>how can i know the count of record in=20
plpgsql.example if i'm query with query komponent from delphi i will =
know the=20
record count of record.but how with plpgsql.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>any ideas?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>thnx</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>best and regard</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>nurdin</FONT></DIV></BODY></HTML>

------=_NextPart_000_0057_01C4D5F6.387E2A00--




From jasiek@klaster.net Mon Nov  29 09:30:23 2004
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



From dev@archonet.com Mon Nov  29 09:43:14 2004
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 B8AB53A4B27
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Nov 2004 09:43:14 +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 41953-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Nov 2004 09:43:11 +0000 (GMT)
Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net
	[194.217.242.92])
	by svr1.postgresql.org (Postfix) with ESMTP id CC8143A42F3
	for <pgsql-sql@postgresql.org>; Mon, 29 Nov 2004 09:43:11 +0000 (GMT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-34.mail.demon.net with esmtp (Exim 4.42)
	id 1CYi3p-000HPi-Di; Mon, 29 Nov 2004 09:43:11 +0000
Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id AF882169EF; Mon, 29 Nov 2004 09:42:59 +0000 (GMT)
Message-ID: <41AAEF22.10804@archonet.com>
Date: Mon, 29 Nov 2004 09:42:58 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 0.9 (X11/20041103)
X-Accept-Language: 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 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/282
X-Sequence-Number: 19600

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