Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id RAA58961 for ; Tue, 27 Apr 1999 17:14:47 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id RAA00327; Tue, 27 Apr 1999 17:14:14 -0400 Received: by localhost with Microsoft MAPI; Tue, 27 Apr 1999 17:17:00 -0400 Message-ID: <01BE90D1.C30E2000.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'Jackson, DeJuan'" , "'pgsql-sql@hub.org'" Subject: RE: [SQL] incrementing by the second Date: Tue, 27 Apr 1999 17:16:59 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit That worked "mahvelous" - thanks much! No duplicate values! jt -----Original Message----- From: Jackson, DeJuan [SMTP:djackson@cpsgroup.com] Sent: Tuesday, April 27, 1999 4:42 PM To: JT Kirkpatrick; 'pgsql-sql@hub.org' Subject: RE: [SQL] incrementing by the second > I have 96,000 records in a postgres table that has an unpopulated field > for > datetime. I need the value in that field to be unique, but the ACTUAL > value isn't really that important. I'd like to begin with the first > record, enter a date and time, and then increment that value by one second > > for the next field, one second for the next, and so on. Can I do this > directly from within psql?? I could do this in dbase w/ no problem, but > I'm really not that familiar with sql syntax. . . > > jt > You might be able to do it with a creative use of a sequence. create sequence my_seq; create table test ( my_d datetime PRIMARY KEY DEFAULT now()+(nextval('my_seq') || ' seconds'), ...) You still have problems with duplicates happening as in my reply to your othe message. you can take the default (now()+(nextval('my_seq') || ' seconds')) and use it in an INSERT statement to the same effect. -DEJ