Skip site navigation (1) Skip section navigation (2)

Re: INTERVAL type: SQL92 implementation

From: "Ken Hirsch" <kenhirsch(at)myself(dot)com>
To: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: INTERVAL type: SQL92 implementation
Date: 2001-09-01 21:17:43
Message-ID: 006b01c1332e$63659b40$52463dd0@hppav (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches
Thomas Lockhart <lockhart(at)fourpalms(dot)org> wrote:
> We have a copy of an SQL99 draft which seems to be reasonably complete.
> afaik we haven't come across an actual released version. Let me know if
> you want me to forward it; perhaps it is on the ftp or web site?

Mostly the same files are at
(or ftp).

I didn't know until recently that the ANSI standard was available in PDF
form for an almost reasonable price ($18/part) compared to the outrageous
ISO price ($98 to $275 per part).


> Not sure what you mean here. The existing type does keep years/months
> stored separately from the days/hours/minutes/seconds (a total of two
> internal fields) but SQL99 asks that these be kept completely away from
> each other from what you've said. Does it define any arithmetic between
> the two kinds of intervals?

No.  Days/hours/minutes/seconds are exact quantities whereas years and
months are not, so they don't mix.

In response to


pgsql-hackers by date

Next:From: Dwayne MillerDate: 2001-09-01 23:32:09
Subject: Porting to Native WindowsNT/2000
Previous:From: Vladimir V. ZolotychDate: 2001-09-01 12:18:37
Subject: DIVIDEBY in PostgreSQL

pgsql-patches by date

Next:From: Rene PijlmanDate: 2001-09-02 14:26:55
Subject: PostgreSQL/JDBC Test Suite Howto
Previous:From: Barry LindDate: 2001-09-01 02:29:41
Subject: Re: Read transactions don't work on 7.0.x db's

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group