pg_cron
pg_cron copied to clipboard
Setting Values to Condicion Query
Hello I have trying to set values to condition in query of cron.schedule:
SELECT sc.minute_execution_cron,
sc.hour_execution_cron,
sc.day_month_execution_cron,
sc.month_execution_cron,
sc.day_week_execution_cron,
sc.interval_config_mount_delete,
sc.interval_config_type_delete into
x_minute_cron_cl, x_hour_cron_cl, x_day_month_cron_cl,
x_month_cron_cl, x_day_week_cron_cl, x_interval_mount_cron_cl,
x_interval_type_cron_cl
FROM public."setting-cron" as sc
WHERE sc.country = 'XX';
x_time_cron_cl = x_minute_cron_cl || ' ' || x_hour_cron_cl || ' ' ||x_day_month_cron_cl || ' ' || x_month_cron_cl || ' ' || x_day_week_cron_cl;
x_invertal_cron_cl = x_interval_mount_cron_cl || ' ' || x_interval_type_cron_cl;
raise notice 'Value: %', x_invertal_cron_cl;
--perform public."deleteLogs"('2022-08-30 12:45:00', x_invertal_cron_cl, 'CL');
PERFORM cron.schedule('delete-logs-cl',x_time_cron_cl, $$select * from public."deleteLogs"('2022-08-30 12:45:00', x_invertal_cron_cl, 'XX')$$);
and the error is: 2022-09-23 03:51:00.013 UTC [1057] ERROR: column "x_invertal_cron_cl" does not exist at character 58 2022-09-23 03:51:00.013 UTC [1057] STATEMENT: select * from public."deleteLogs"('2022-08-30 12:45:00', x_invertal_cron_cl, 'XX')
so, is it possible?