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 QAA51809 for ; Tue, 27 Apr 1999 16:11: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 QAA29831 for ; Tue, 27 Apr 1999 16:11:14 -0400 Received: by localhost with Microsoft MAPI; Tue, 27 Apr 1999 16:14:00 -0400 Message-ID: <01BE90C8.F5C15660.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" Subject: incrementing by the second Date: Tue, 27 Apr 1999 16:13: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 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