Re: Changing column types...

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <lockhart(at)fourpalms(dot)org>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing column types...
Date: 2002-04-05 03:08:36
Message-ID: GNELIHDDFBOCMGBFGEFOGEPPCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-04-05 03:10:07 Re: Changing column types...
Previous Message Hiroshi Inoue 2002-04-05 03:08:04 Re: What's the CURRENT schema ?