Re: PLPGSQL - Trigger Insert acting strange - Mailing list pgsql-general

Hadley Willan <hadley.willan@deeper.co.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