Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 243B7475EB8
	for <pgsql-sql@postgresql.org>; Mon, 24 Jun 2002 08:24:08 -0400 (EDT)
Mailbox-Line: From joseph@asti.dost.gov.ph  Mon Jun 24 08:24:08 2002
Received: from kitana.asti.dost.gov.ph (kitana.asti.dost.gov.ph
 [202.90.128.8])
	by postgresql.org (Postfix) with ESMTP id 3CC3F475B12
	for <pgsql-sql@postgresql.org>; Sun, 23 Jun 2002 22:39:07 -0400 (EDT)
Received: from Askr (askr.asti.dost.gov.ph [10.10.5.36])
	by kitana.asti.dost.gov.ph (Postfix) with ESMTP id B585825845
	for <pgsql-sql@postgresql.org>; Mon, 24 Jun 2002 10:37:50 +0800 (PHT)
Subject: assign count() result to a declared variable in plpgsql
From: Joseph Syjuco <joseph@asti.dost.gov.ph>
To: postgres <pgsql-sql@postgresql.org>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Evolution/1.0.2-5mdk 
Date: 24 Jun 2002 11:25:30 -0400
Message-Id: <1024932336.15861.8.camel@Askr>
Mime-Version: 1.0
X-Spam-Status: No, hits=3.3 required=5.0 tests=DATE_IN_FUTURE_12_24
	version=2.30
X-Spam-Level: ***
X-Archive-Number: 200206/319
X-Sequence-Number: 8284


i want to put my count() result in a plpgsql declared integer variable


declare f_count_var integer;
begin
	select into f_count_var count(empno) from employee
end;

tried this one but it doesnt work