Re: Changing column types... - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Changing column types...
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEPPCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Changing column types...  (Thomas Lockhart <lockhart@fourpalms.org>)
Responses Re: Changing column types...  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
> > 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.

Does this mean that hacking the type of an int4 column to become abstime is
a bad idea?

Yes in theory - no in practice?

Chris



pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: What's the CURRENT schema ?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Changing column types...