Re: [GENERAL] Time Stamp auto Field

2006-12-06 Thread Bruno Wolff III
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

[GENERAL] Time Stamp auto Field

2006-12-05 Thread deepak pal
hi can we make a field auto incrementing field using Time Stamp data type

Re: [GENERAL] Time Stamp auto Field

2006-12-05 Thread A. Kretschmer
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: