"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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
