Re: subtratcing dates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fran Fabrizio <ffabrizio(at)exchange(dot)webmd(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: subtratcing dates
Date: 2001-05-07 16:00:29
Message-ID: 21666.989251229@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fran Fabrizio <ffabrizio(at)exchange(dot)webmd(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wall 2001-05-07 16:20:35 Re: Timestamp Resolution in Postgres
Previous Message Bruce Momjian 2001-05-07 15:58:54 Re: Re: Metaphone function attachment