Re: new type proposal - Mailing list pgsql-general

From Tim Uckun
Subject Re: new type proposal
Date
Msg-id 5.0.0.25.2.20010206140423.019f4ad8@mail.diligence.com
Whole thread Raw
In response to new type proposal  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
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.

BTW is the currency datatype working with access and ODBC yet?


:wq
Tim Uckun
Due Diligence Inc.  http://www.diligence.com/    Americas Background
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered
the risks of a bad hire.


pgsql-general by date:

Previous
From: "Stefan Waidele jun."
Date:
Subject: Re: clean rebuild process?
Next
From: Culley Harrelson
Date:
Subject: Re: selecting a random record