Re: Changing column types...

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

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: What's the CURRENT schema ?
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Changing column types...