> 3) continue the status quo, with modest relabeling of the current
> capabilities.
>
> Hmm. Any solution will have some confusion, so it really is not clear
> which labeling path is preferable. Maybe even to those who think it is
> clear ;)
>
> SQL9x "timestamp" has no notion of time zones. PostgreSQL "timestamp"
> does. This is likely the reason for the current labeling scheme (at
> least in pgdump). This also lays the groundwork for more seamless
> upgrade paths later when a "time zone free" timestamp type might be
> available.
Very few people know the standards stuff so it seems we should just call
it timestamp and do the best we can. Basically by mentioning "with
timezone" we are making the standards people happy but confusing our
users.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026