"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
>
-- 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