Re: [HACKERS] Updating column on row update

Thom Brown <thombrown@gmail.com>

From: Thom Brown <thombrown@gmail.com>
To: Hannu Krosing <hannu@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Craig Ringer <craig@postnewspapers.com.au>, Scott Marlowe <scott.marlowe@gmail.com>, PGSQL Mailing List <pgsql-general@postgresql.org>, pgsql-hackers@postgresql.org
Date: 2009-11-24T09:46:56Z
Lists: pgsql-hackers, pgsql-general
2009/11/24 Hannu Krosing <hannu@2ndquadrant.com>

> On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
> > 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 :-(
>
> What's wrong with 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