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
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 Miller||Date: 2001-09-01 23:32:09|
|Subject: Porting to Native WindowsNT/2000|
|Previous:||From: Vladimir V. Zolotych||Date: 2001-09-01 12:18:37|
|Subject: DIVIDEBY in PostgreSQL |
pgsql-patches by date
|Next:||From: Rene Pijlman||Date: 2001-09-02 14:26:55|
|Subject: PostgreSQL/JDBC Test Suite Howto|
|Previous:||From: Barry Lind||Date: 2001-09-01 02:29:41|
|Subject: Re: Read transactions don't work on 7.0.x db's|