On Tue, Dec 05, 2006 at 17:31:53 +0530,
deepak pal <[EMAIL PROTECTED]> 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
am Tue, dem 05.12.2006, um 17:31:53 +0530 mailte deepak pal folgendes:
> hi can we make a field auto incrementing field using Time Stamp data type
On INSERT: set the default value for this field to now()
For Update: create a trigger to do this.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz:
hi can we make a field auto incrementing field using Time Stamp data type