"Rob Richardson" <[EMAIL PROTECTED]> writes: > So how do I specify an interval in a function?
Does this help? ([EMAIL PROTECTED]:5432/test) [2008-07-31 15:49:54] # CREATE OR REPLACE FUNCTION time_cmp_with_1w_offset (_l_ts timestamp, _r_ts timestamp) RETURNS boolean AS $$ DECLARE _offset interval; BEGIN _offset = '1 week'; RETURN (_l_ts < _r_ts - _offset); END; $$ LANGUAGE plpgsql; ([EMAIL PROTECTED]:5432/test) [2008-07-31 15:49:28] # SELECT time_cmp_with_1w_offset(CAST('2008-07-10' AS timestamp), ] CAST('2008-07-31' AS timestamp)); time_cmp_with_1w_offset ------------------------- t (1 row) Regards. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general