Received: from mail1.rdc2.bc.home.com (mail1.rdc2.bc.home.com [24.2.10.84]) by hub.org (8.10.1/8.10.1) with ESMTP id e557a0O97119 for ; Mon, 5 Jun 2000 03:36:00 -0400 (EDT) Received: from cr699264-a ([24.113.17.57]) by mail1.rdc2.bc.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20000605073554.LMNF11070.mail1.rdc2.bc.home.com@cr699264-a> for ; Mon, 5 Jun 2000 00:35:54 -0700 Reply-To: From: "Rob S." To: Subject: Default timestamp value Date: Mon, 5 Jun 2000 00:34:47 -0700 Message-ID: <001101bfcec0$8683f1e0$39117118@cr699264-a.rct1.bc.wave.home.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 Importance: Normal X-Archive-Number: 200006/32 As a precursor to this question, I read: CREATE TABLE Date/Time Types (and corresponding input/output) Date/Time Functions ...but I still don't see how to have the default value of a timestamp to be the time at which the individual record is inserted. I just get the time I created the table. Specifically, what to put where the '?' is at. ... "TimeDate" TIMESTAMP DEFAULT ? ... I tried 'now' and 'current' but it just makes the default value the time when I create the table, and 'current' gives me the word 'current' back in psql, so I imagine I'm not taking that in quite the right way =) I can see why it does this for both of these, althought in the docs, it says current is current time, deferred, but I dunno what that means. Any help or pointers to a nice resource? IMHO, the PG docs are a great reference, but not much in the way of terrific examples =) - r