Re: Time Stamp auto Field - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Time Stamp auto Field
Date
Msg-id 20061206152936.GB12499@wolff.to
Whole thread Raw
In response to Time Stamp auto Field  ("deepak pal" <deepak.05pal@gmail.com>)
List pgsql-general
On Tue, Dec 05, 2006 at 17:31:53 +0530,
  deepak pal <deepak.05pal@gmail.com> wrote:
> hi can we make a field auto incrementing field using Time Stamp data type

You can use a column default that uses current_timestamp for its expression.
If you also want to handle updates or override cases where people supply
values for that column, then you should look at using before triggers.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Array shift equivalent?
Next
From: Bernhard Weisshuhn
Date:
Subject: Re: Error in installing compat-postgresql-libs rpm