Re: Fwd: [GENERAL] Approximate join on timestamps

2007-03-20 Thread Jorge Godoy
"Rhys Stewart" <[EMAIL PROTECTED]> writes: > had a similar problem a while back. so i made and abs_time function: > > CREATE OR REPLACE FUNCTION abs_time(interval) > RETURNS interval AS > $BODY$ > BEGIN > if >$1 < '00:00:00'::interval > then >return ($1 * -1)::interval; > else >

Fwd: [GENERAL] Approximate join on timestamps

2007-03-20 Thread Rhys Stewart
-- Forwarded message -- From: Rhys Stewart <[EMAIL PROTECTED]> Date: Mar 20, 2007 6:50 PM Subject: Re: [GENERAL] Approximate join on timestamps To: Phil Endecott <[EMAIL PROTECTED]> had a similar problem a while back. so i made and abs_time function: CREATE OR REPLACE FUNCTION a