Received: from smtp6.mindspring.com (smtp6.mindspring.com [207.69.200.110]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA10039 for ; Tue, 2 Nov 1999 22:11:18 -0500 (EST) (envelope-from davidrugge@mindspring.com) Received: from localhost.mindspring.com (user-37ka37u.dialup.mindspring.com [207.69.12.254]) by smtp6.mindspring.com (8.8.5/8.8.5) with ESMTP id WAA08917 for ; Tue, 2 Nov 1999 22:11:17 -0500 (EST) Received: from localhost (localhost [[UNIX: localhost]]) by localhost.mindspring.com (8.9.3/8.9.3) id VAA00894 for pgsql-sql@postgreSQL.org; Tue, 2 Nov 1999 21:56:15 -0500 From: David Rugge Reply-To: davidrugge@mindspring.com To: pgsql-sql@postgreSQL.org Subject: timestamps Date: Tue, 2 Nov 1999 21:51:52 -0500 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <99110221560802.00836@joplin> Content-Transfer-Encoding: 8bit I created a table using this statement: create table timestamptest (creation_date timestamp default text 'now') But I get the creation date of the table instead of the date of the transaction. This is the format suggested in the manual to workaround the default value being set at table creation, but it doesn't work! What can I do to make a timestamp that is the date the row was inserted into the table? -- David Rugge http://www.mindspring.com/~davidrugge/index.html