Re: datetime field as key

2002-12-23 Thread Michael She
Hi, you can use a DateTime field, but it is possible to get duplicate datetimes if you insert multiple queries fast enough. At 04:17 PM 12/23/2002 -0200, João Borsoi Soares wrote: I would like to use a datetime field as a key. I'm wondering if I will have any problems with key violation. I foun

datetime field as key

2002-12-23 Thread João Borsoi Soares
I would like to use a datetime field as a key. I'm wondering if I will have any problems with key violation. I found in the document something saying that timestamp fields are precise, like unix time, but I don't want it to be changing on update. Does anyone has some experience with it? Thanks, J