pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: hubert depesz lubaczewski <depesz@depesz.pl>
To: pgsql-interfaces@postgresql.org
Subject: Re: Help for plpgsql!!
Date: Fri, 20 Oct 2000 20:27:08 +0200
Message-ID: <20001020202708.A26979@cyber.cs.net.pl> (raw)
In-Reply-To: <F212RelSbxpqyDp6fwq00008e81@hotmail.com>
References: <F212RelSbxpqyDp6fwq00008e81@hotmail.com>

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 ...



view thread (2+ messages)

Message-ID: <20001020202708.A26979@cyber.cs.net.pl>
Permalink:  ../20001020202708.A26979@cyber.cs.net.pl/
Also on:    postgresql.org/message-id/20001020202708.A26979@cyber.cs.net.pl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: depesz@depesz.pl
  Subject: Re: Help for plpgsql!!
  In-Reply-To: <20001020202708.A26979@cyber.cs.net.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox