Re: Function Syntax Help

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hello

You are using PLpgSQL CASE statement

this start by CASE keyword and finishing by END CASE keywords

CREATE OR REPLACE FUNCTION sn_dm_b.pm_insert_trigger()

RETURNS TRIGGER AS $$

BEGIN

    CASE

        WHEN NEW.period =  201001

                THEN INSERT INTO sn_dm_b.pm201001 VALUES (NEW.*);

    END;

    RETURN NULL;

END CASE; -- <<<<<<<<<<<<<

$$ LANGUAGE plpgsql;

2014-06-26 0:19 GMT+02:00 Dennis Ryan <dennis@xxxxxxxxxxxxxxxx>:

I having trouble with correct syntax to get this trigger function to compile.  I have tried every combination of removing the ‘;’ characters but the function will not compile.  Can someone tell me what I am doing wrong, I am stumped. I will be adding addition when clauses the case statement once I get this simplified version to compile.

I am using 9.3.4, both postgres and psql.

CREATE OR REPLACE FUNCTION sn_dm_b.pm_insert_trigger()

RETURNS TRIGGER AS $$

BEGIN

    CASE

        WHEN NEW.period =  201001

                THEN INSERT INTO sn_dm_b.pm201001 VALUES (NEW.*);

    END;

    RETURN NULL;

END;

$$ LANGUAGE plpgsql;

ERROR:  syntax error at or near ";"

LINE 7:     END;