Re: Changing column types...

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: Changing column types...
Дата
Msg-id 3CACFE0B.B670CBD9@fourpalms.org
обсуждение исходный текст
Ответ на Changing column types...  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: Changing column types...  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What's the CURRENT schema ?
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: What's the CURRENT schema ?