Informix 使用参数定义 INTERVAL

Question

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

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

但是，我想在存储过程中配置间隔，但我做不到

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

Answer 1

我自己找到了答案。

不能用变量动态定义间隔。但是你可以使用“单位秒”，所以我的程序变成

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