Re: new type proposal

Tim Uckun wrote:
>
> At 03:43 PM 2/6/2001 -0500, Joseph Shraibman wrote:
> >I've been thinking on some new pesudo-types like SERIAL.
> >
> >1) LAST_MODIFIED is the timestamp of that last time this row was
> >modified.  Easy enough to do currently with triggers.
> >2) TIME_CREATED is the timestamp of when this row was first created with
> >an INSERT.  I'm not sure how to do this because it needs to be read
> >only.
>
> MS sql server has a TIMESTAMP field which acts exactly like LAST_MODIFIED
> type you proposed. I find this field very handy when attempting to
> synchronize data. I would welcome such a field type in postgres.
>

There already is something called timestamp, and I thought it was a sql
standard type.

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com