Informix用参数定义一个INTERVAL [英] Informix defining an INTERVAL with a parameter

问题描述

我正在Informix中执行以下操作以删除超过20秒的旧行.

I am doing the following in Informix to delete rows more than 20 seconds old.

delete from sometable
where someDateColumn < (current - interval (20) second to second);

但是，我想在存储过程中使时间间隔可配置，但是我不能这样做

However, I want to make the interval configurable in a stored procedure, but I can't do

CREATE PROCEDURE i_hate_informix (prm_timeframe int)
    DELETE   sometable
    WHERE    someDateColumn < (current - interval (prm_timeframe) second to second);
END PROCEDURE;

推荐答案

我自己找到了答案.

不能使用变量动态定义间隔.但是您可以使用第二个单位"，这样我的程序就可以了

Interval can not be defined dynamically with a variable. But you can use "units second" so my procedure becomes

CREATE PROCEDURE i_hate_informix (prm_timeframe int)
   DELETE   sometable
   WHERE    someDateColumn < (current - prm_timeframe units second);
END PROCEDURE;

这篇关于Informix用参数定义一个INTERVAL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！