Received: from cyber.cs.net.pl (qmailr@cyber.cs.net.pl [195.117.250.3])
	by hub.org (8.10.1/8.11.0) with SMTP id e9KIRAJ85488
	for <pgsql-interfaces@postgresql.org>;
	Fri, 20 Oct 2000 14:27:11 -0400 (EDT)
	(envelope-from depesz@cyber.cs.net.pl)
Received: (qmail 26983 invoked by uid 1158); 20 Oct 2000 18:27:08 -0000
Message-ID: <20001020202708.A26979@cyber.cs.net.pl>
Date: Fri, 20 Oct 2000 20:27:08 +0200
From: hubert depesz lubaczewski <depesz@depesz.pl>
To: pgsql-interfaces@postgresql.org
Subject: Re: Help for plpgsql!!
Reply-To: depesz@depesz.pl
References: <F212RelSbxpqyDp6fwq00008e81@hotmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 8bit
X-Mailer: Mutt 0.93i
In-Reply-To: <F212RelSbxpqyDp6fwq00008e81@hotmail.com>;
	from joel_xue@hotmail.com on Wed, Oct 18, 2000 at 09:53:23PM +0000
X-Mutt-Fcc: /dev/null
X-Archive-Number: 200010/178
X-Sequence-Number: 1535

On Wed, Oct 18, 2000 at 09:53:23PM +0000, joel xue wrote:
> create function isFull()
> returns opaque as '
>   begin
>     select count(*) into tmp1 from emp;
                           ^^^^

you didn't declare tmp1. before begin write
declare
tmp1 int4;

depesz

-- 
hubert depesz lubaczewski
------------------------------------------------------------------------
     najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
      jest niesamowita wręcz łatwość unikania kontaktów z nim ...