new type proposal - Mailing list pgsql-general

From Joseph Shraibman
Subject new type proposal
Date
Msg-id 3A8061F0.866AB642@selectacast.net
Whole thread Raw
Responses Re: new type proposal
Re: new type proposal
List pgsql-general
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.

Both of these could be useful to me and I can implement them by myself
(except #2 which I'll just have to trust myself not to screw up) but
general users might find them useful.

What do you think?

pgsql-general by date:

Previous
From: "Dan Wilson"
Date:
Subject: Re: Re: PostreSQL SQL for MySQL SQL
Next
From: "Stefan Waidele jun."
Date:
Subject: Re: clean rebuild process?