David Brain wrote:
> Is there a way of using EXECUTE in trigger functions to to do something
> like:
>
> CREATE OR REPLACE FUNCTION insert_trigger()
> RETURNS trigger AS
> $BODY$
> BEGIN
> EXECUTE('INSERT INTO public_partitions.table_'
> || date_part('year',NEW.eventdate)::VarChar
>
Hi,
Is there a way of using EXECUTE in trigger functions to to do
something like:
CREATE OR REPLACE FUNCTION insert_trigger()
RETURNS trigger AS
$BODY$
BEGIN
EXECUTE('INSERT INTO public_partitions.table_'
|| date_part('year',NEW.eventdate)::VarChar
|| lpad(date_part(