On 26/06/2014 17:26, Raymond O'Donnell wrote: > On 25/06/2014 23:19, Dennis Ryan wrote: >> 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.*); > > The problem is the semi-colon after (NEW.*). There isn't one inside a > CASE construct. Whoops - Pavel is of course correct - this is a pl/pgsql CASE, not an SQL one. Sorry - my mistake. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx
