Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 059E64769DE for ; Mon, 24 Jun 2002 14:10:43 -0400 (EDT) Mailbox-Line: From tgl@sss.pgh.pa.us Mon Jun 24 14:10:43 2002 Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 0299E476604 for ; Mon, 24 Jun 2002 12:12:33 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g5OGCX118789; Mon, 24 Jun 2002 12:12:33 -0400 (EDT) To: Joseph Syjuco Cc: postgres Subject: Re: assign count() result to a declared variable in plpgsql In-reply-to: <1024932336.15861.8.camel@Askr> References: <1024932336.15861.8.camel@Askr> Comments: In-reply-to Joseph Syjuco message dated "24 Jun 2002 11:25:30 -0400" Date: Mon, 24 Jun 2002 12:12:33 -0400 Message-ID: <18786.1024935153@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-5.3 required=5.0 tests=IN_REP_TO,X_NOT_PRESENT version=2.30 X-Spam-Level: X-Archive-Number: 200206/324 X-Sequence-Number: 8289 Joseph Syjuco writes: > 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 Works for me: regression=# create function foo() returns int as ' regression'# declare f_count_var integer; regression'# begin regression'# select into f_count_var count(unique1) from tenk1; regression'# return f_count_var; regression'# end' language plpgsql; CREATE FUNCTION regression=# select foo(); foo ------- 10000 (1 row) What PG version are you using? regards, tom lane