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(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
/----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
/--------------------------------------------------------/