Re: PLPGSQL - Trigger Insert acting strange

Hadley Willan <hadley(dot)willan(at)deeper(dot)co(dot)nz> writes:
> CREATE OR REPLACE FUNCTION fn_del_pol_grp_folder_unit(
> VARCHAR(32),
> INTEGER,
> INTEGER ) RETURNS BOOLEAN AS'
> DECLARE
> _policy_group ALIAS FOR $1;
> _folder ALIAS FOR $2;
> _unit ALIAS FOR $3;
> BEGIN
> RAISE NOTICE ''fn_del_pol_grp_folder_unit, %,%,%'',
> _policy_group, _folder, _unit;

> DELETE FROM policy_group_folder_unit
> WHERE policy_group = quote_literal(_policy_group)
> AND folder = _folder
> AND unit_number = _unit;

> RETURN TRUE;
> END;'
> language 'plpgsql';

I don't believe you want quote_literal() here. plpgsql can pass
variables into queries just fine...

regards, tom lane