Re: subtratcing dates - Mailing list pgsql-general

From Tom Lane
Subject Re: subtratcing dates
Date
Msg-id 21666.989251229@sss.pgh.pa.us
Whole thread Raw
In response to Re: subtratcing dates  (Fran Fabrizio <ffabrizio@exchange.webmd.net>)
List pgsql-general
Fran Fabrizio <ffabrizio@exchange.webmd.net> writes:
> At first, I accidentally tried to do reltime(limit*60) where limit was
> accidentally an interval instead of an integer, and my database crashed
> and exited horribly.

Yeah?  Did you have any nulls in the limit column?
    select reltime(null::interval);
bombs in 7.0 (but is fine in 7.1).  interval_reltime is far from the
only function that's not NULL-proof in pre-7.1 releases :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Metaphone function attachment
Next
From: Lieven Van Acker
Date:
Subject: Re: v7.1.1 Branched, Packaged and Released ...