Received: from fanthom.math.put.poznan.pl (root@fanthom.math.put.poznan.pl
	[150.254.5.54]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA48355
	for <pgsql-interfaces@postgresql.org>;
	Mon, 7 Jun 1999 11:52:04 -0400 (EDT)
	(envelope-from kelman@fanthom.math.put.poznan.pl)
Received: from pb104.poznan.ppp.tpnet.pl ([212.160.11.104])
	by fanthom.math.put.poznan.pl (8.8.7/8.8.7) with SMTP id RAA21323
	for <pgsql-interfaces@postgresql.org>; Mon, 7 Jun 1999 17:52:42 GMT
Date: Mon, 7 Jun 1999 17:49:44 +0200
From: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
X-Mailer: The Bat! (v1.31) UNREG
Reply-To: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
Organization: PUT
X-Priority: 3 (Normal)
Message-ID: <14742.990607@fanthom.math.put.poznan.pl>
To: PgSQL-interfaces <pgsql-interfaces@postgresql.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

hi,

i'm trying to drop table in plpgsql trigger.
the problem is that table name depends on ID of object
that is to be removed.

so:
<cut>
declare
  t text;
begin
  t := 'objects' || trim(OLD.id);
  drop table t;
end
</cut>

psql prints error:
<cut>
ERROR: parser: parse error at or near "$1"
</cut>

what may be the problem? what does it mean "$1"? i don't have
any function arguments.

any ideas? thanx.


/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/