Function Doesn't Work: ERROR: syntax error at or near "DELETE"

Question

I am trying to create a function inside Postgres. For some reason my query works perfectly fine when I run it from inside the Query tool. Once I added the query to my function, I get the error

ERROR: syntax error at or near "DELETE"

Not sure what is the problem.

CREATE FUNCTION public.remove_email_header()
    RETURNS pg_trigger
    LANGUAGE 'plpgsql'

AS $BODY$
DELETE FROM public.spam_dictionary WHERE words LIKE '%FROM%';
$BODY$;

ALTER FUNCTION public.remove_email_header()
    OWNER TO postgres;

Kaushik Nayak · Accepted Answer · 2019-07-28 05:04:22Z

1

Two Things to note.

A plpgsql Postgres function uses BEGIN END

The plpgsql should not be quoted.

CREATE FUNCTION remove_email_header()
    RETURNS trigger
    LANGUAGE plpgsql

AS $BODY$
BEGIN
DELETE FROM public.spam_dictionary WHERE words LIKE '%FROM%';
END 
$BODY$;

answered Jul 28, 2019 at 5:04

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Function Doesn't Work: ERROR: syntax error at or near "DELETE"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related