Re: Changing column types...

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing column types...
Date: 2002-04-05 01:29:47
Message-ID: 3CACFE0B.B670CBD9@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-04-05 02:03:01 Re: What's the CURRENT schema ?
Previous Message Tom Lane 2002-04-05 00:47:16 Re: What's the CURRENT schema ?