Re: Changing column types...

> 1. What is the difference between abstime and timestamp - they seem to
> display equally...

abstime is four bytes with a range of +/- 68 years. timestamp is eight
bytes with a range from 4212BC to way into the future.

> 2. Since int4 and abstime are binary compatible (ie int4::abstime works), is
> there any serious problem with updating a pg_attribute row for an int4 and
> changing it to and abstime?  My experiments seem to work.

A few integer values are reserved values in abstime, to allow
implementation of infinity, -infinity, etc.
                   - Thomas