On Jan 9, 2008 10:00 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Really? I think you've confused some unimplemented decorative syntax
> with what the underlying datatype will or won't do.
Fair enough. The underlying type certainly will do it since it works
without the opt_interval.
> > This is inc
On Jan 9, 2008 11:06 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Brendan Jurd" <[EMAIL PROTECTED]> writes:
> > On Jan 10, 2008 5:00 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> >> The spec's approach to datetime operations in general is almost totally
> >> brain-dead, ...
>
> > It's true that the spec
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
> On Jan 10, 2008 5:00 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> The spec's approach to datetime operations in general is almost totally
>> brain-dead, ...
> It's true that the spec fails to consider DST, in that it doesn't
> partition "day" and "second"
On Jan 9, 2008 10:44 PM, Brendan Jurd <[EMAIL PROTECTED]> wrote:
> On Jan 10, 2008 5:00 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > The spec's approach to datetime operations in general is almost totally
> > brain-dead, and so you won't find a lot of support around here for hewing
> > to the straig
On Jan 10, 2008 5:00 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> The spec's approach to datetime operations in general is almost totally
> brain-dead, and so you won't find a lot of support around here for hewing
> to the straight-and-narrow-spec-compliance approach. If they have not
> even heard of
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
> On Jan 10, 2008 2:17 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> You'd have to define exactly what that means, which seems a little
>> tricky for incommensurate intervals. For instance what is the
>> result of '1 month' / '1 day' ?
> Postgres has alread
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-hackers-
> [EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: Wednesday, January 09, 2008 10:00 PM
> To: Warren Turkal
> Cc: Brendan Jurd; Ilya А. Кovalenko; pgsql-hackers@postgresql.org
> Subject: Re: [HACK
"Warren Turkal" <[EMAIL PROTECTED]> writes:
> YEAR TO MONTH and DAY TO {HOUR,MINUTE,SECOND} intervals should not
> combine. PostgreSQL correctly doesn't allow {YEAR,MONTH} TO
> {DAY,HOUR,MINUTE,SECOND} intervals,
Really? I think you've confused some unimplemented decorative syntax
with what the u
On Jan 9, 2008 9:29 PM, Brendan Jurd <[EMAIL PROTECTED]> wrote:
> Sorry, a correction. The issue of years vs. days isn't ignored. A
> year is just 12 months, which yields 12 * 30 = 360 days, which is
> actually a pretty significant error (1.4% on average).
YEAR TO MONTH and DAY TO {HOUR,MINUTE,S
On Jan 10, 2008 3:33 PM, Brendan Jurd <[EMAIL PROTECTED]> wrote:
> 1 month is deemed equal to 30 days, 1 day is deemed equal to 24 hours
> (although for some reason we ignore the issue of years vs. days).
>
Sorry, a correction. The issue of years vs. days isn't ignored. A
year is just 12 months,
On Jan 9, 2008 8:33 PM, Brendan Jurd <[EMAIL PROTECTED]> wrote:
> I argued in a long-dead thread that we should disallow these kinds of
> comparisons altogether, but I didn't manage to generate much
> enthusiasm. The overall sentiment seemed to be that the slightly
> bogus results were more useful
On Jan 10, 2008 2:17 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> You'd have to define exactly what that means, which seems a little
> tricky for incommensurate intervals. For instance what is the
> result of '1 month' / '1 day' ?
>
Postgres has already made such definitions, to allow direct
interva
Warren Turkal escribió:
> The year to month and day to second intervals should not overlap. The
> standard doesn't actually allow it IIRC.
They do on Postgres anyway. Otherwise the type is not all that useful,
is it?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The year to month and day to second intervals should not overlap. The
standard doesn't actually allow it IIRC.
wt
On Jan 9, 2008 7:17 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Ilya A. Kovalenko" <[EMAIL PROTECTED]> writes:
> > I suggest one more standard date/time operator, to divide one interva
"Ilya A. Kovalenko" <[EMAIL PROTECTED]> writes:
> I suggest one more standard date/time operator, to divide one interval
> by another with numeric (or float, for example) result.
You'd have to define exactly what that means, which seems a little
tricky for incommensurate intervals. For instance w
am Wed, dem 09.01.2008, um 17:33:00 +0700 mailte Ilya A. Kovalenko folgendes:
>
> I suggest one more standard date/time operator, to divide one interval
> by another with numeric (or float, for example) result.
> I.e. something like that:
>
> database=# SELECT '5400 seconds'::interval / '1 hour'
I suggest one more standard date/time operator, to divide one interval
by another with numeric (or float, for example) result.
I.e. something like that:
database=# SELECT '5400 seconds'::interval / '1 hour'::interval;
?column?
--
1.5
(1 row)
Ilya A. Kovalenko
--
17 matches
Mail list logo
