From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Alban Hertroys <alban(at)magproductions(dot)nl> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: A few things on intervals |
Date: | 2006-04-28 17:04:16 |
Message-ID: | 20060428170416.GA20186@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 28, 2006 at 13:52:09 +0200,
Alban Hertroys <alban(at)magproductions(dot)nl> 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 intervals in a way that can be
> reliably split up?
Internally intervals store time in months and seconds (in 7.4.x - 8.1.x also
stores days), so you are not going to be able to do what you want only using
what is stored in an interval. However, you might be able to use that data
combined with your restrictions on allowed values to figure out the desired
type.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Harrison | 2006-04-28 17:29:58 | Re: query that needs two nested queries, is this the best |
Previous Message | Merlin Moncure | 2006-04-28 17:02:59 | Re: Installing PostgreSQL on Win 2003 R2 64-bit |