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