> Hi , > > Today i m creating a function that includes dynamic concatenation of a > partitioned table name as below :- > > test=# CREATE OR REPLACE FUNCTION tmp_trigger_function() > test-# RETURNS TRIGGER AS $$ > test$# DECLARE > test$# tbl_name text; > test$# abc varchar; > test$# BEGIN > test$# tbl_name := 'tmp'; > test$# select to_char(NEW.a::timestamp,'yyyymmdd') into abc ; > test$# insert into tmp || abc values ( NEW.* ); > test$# RETURN NULL; > test$# END; > test$# $$ > test-# LANGUAGE plpgsql; > ERROR: syntax error at or near "||" > LINE 9: insert into tmp || abc values ( NEW.* ); > ^ > Time: 0.901 ms > test=# > test=# > > I tried with a statement variable also. Any ideas ?
You'll need to create a string and use EXECUTE, something along the lines of:
stmt := 'insert into ' || tmp || abc || ' VALUES ($1)' EXECUTE stmt USING NEW.*;