Re: Function Syntax Help
От | Pavel Stehule |
---|---|
Тема | Re: Function Syntax Help |
Дата | |
Msg-id | CAFj8pRAeWkr13tK6BNBHr_3FoSbvkFzLHBdH=0exG2sOEHC5FA@mail.gmail.com обсуждение исходный текст |
Ответ на | Function Syntax Help (Dennis Ryan <dennis@kabonkulator.com>) |
Список | pgsql-general |
Hello
You are using PLpgSQL CASE statementCREATE 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@kabonkulator.com>:
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 $$BEGINCASEWHEN NEW.period = 201001THEN INSERT INTO sn_dm_b.pm201001 VALUES (NEW.*);END;RETURN NULL;END;$$ LANGUAGE plpgsql;ERROR: syntax error at or near ";"LINE 7: END;
В списке pgsql-general по дате отправления: