Re: Re: Data type confusion - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Re: Data type confusion
Date
Msg-id Pine.LNX.4.30.0108060157170.11162-100000@peter.localdomain
Whole thread Raw
In response to Re: Re: Data type confusion  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: Data type confusion
List pgsql-sql
Tom Lane writes:

> It is kinda bogus, given the underlying semantics of intervals
> (integer months plus float seconds).

> This is pretty grotty, and AFAIK not documented anywhere --- I found it
> out by looking at the C code for these operators.  But I'm not sure
> how to do better.

One day we will have to accept the fact that months and seconds must not
be mixed, period.  You can have year/month intervals or
day/hour/minute/second intervals, not a combination.  An interval of '5
years 3 minutes' has no meaning with the natural calendar rules.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Data type confusion
Next
From: Tom Lane
Date:
Subject: Re: Re: Data type confusion