Re: [GENERAL] A few things on intervals

2006-04-28 Thread Bruno Wolff III
On Fri, Apr 28, 2006 at 13:52:09 +0200, Alban Hertroys <[EMAIL PROTECTED]> wrote: > I realize that this isn't possible for intervals like '1 year 3 months', > but we only use relatively simple intervals like '3 months', '6 weeks' > and '100 hours'. > > Is there some easy way to query such inte

[GENERAL] A few things on intervals

2006-04-28 Thread Alban Hertroys
I am trying to get infinity in an interval type on PostgreSQL 7.4.7. I can't seem to get this done, even though there's allegedly an isfinite(interval) function. For now we use NULL instead, but what would have worked? Next to that I noticed: select age('infinity'::timestamp);