Re: [HACKERS] Updating column on row update
| От | Thom Brown |
|---|---|
| Тема | Re: [HACKERS] Updating column on row update |
| Дата | |
| Msg-id | bddc86150911240146l645825f2h568026460f92db4f@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] Updating column on row update (Hannu Krosing <hannu@2ndQuadrant.com>) |
| Ответы |
Re: [HACKERS] Updating column on row update
|
| Список | pgsql-general |
2009/11/24 Hannu Krosing <hannu@2ndquadrant.com>
On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:What's wrong with abstime ?
> Craig Ringer <craig@postnewspapers.com.au> writes:
> > I do think this comes up often enough that a built-in trigger "update
> > named column with result of expression on insert" trigger might be
> > desirable.
>
> There's something of the sort in contrib already, I believe, though
> it's so old it still uses abstime :-(
it is valid for timestamps up to 2038-01-19 and it's on-disk size
smaller than other timestamp options
But it's very very deprecated and could be removed at any time. It's been so for years now, and I wouldn't want to *start* using something which is deprecated.
Thom
В списке pgsql-general по дате отправления: