-- 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
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
return $1;