Re: [HACKERS] Re: [COMMITTERS] pgsql/src/include/catalog (pg_type.h) - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] Re: [COMMITTERS] pgsql/src/include/catalog (pg_type.h)
Date
Msg-id 3883D022.8386A215@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] Re: [COMMITTERS] pgsql/src/include/catalog (pg_type.h)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Date/time types (Re: [HACKERS] Re: [COMMITTERS] pgsql/src/include/catalog (pg_type.h))
List pgsql-hackers
> We are going to internally move everything to the more standard ANSI
> names, right, or do we give preference to the older types?

Well, that could be up for discussion. The "internal" abstime/reltime
types are direct copies of Unix system time, which most systems
support at a fundamental level. Moving to timestamp/interval will
double the storage size of those fields, with no increase in
functionality afaik.

Peter brought up changing one field to timestamp; that would have the
benefit of being able to specify times past y2038.
                  - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: "Adam Walczykiewicz"
Date:
Subject: plpgsql -record in -record out
Next
From: Thomas Lockhart
Date:
Subject: Re: FreeBSD postgresql doc-HOWTO was: Re: [HACKERS] Revised nonblocking patches + quasi docs