Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id PAA16775 for ; Wed, 10 Jun 1998 15:16:24 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id PAA25984 for pgsql-interfaces@postgresql.org; Wed, 10 Jun 1998 15:14:03 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA43268; Wed, 10 Jun 1998 15:06:47 -0400 Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03) id AA46176; Wed, 10 Jun 1998 15:06:47 -0400 Message-Id: <357ED903.265DF2DA@insightdist.com> Date: Wed, 10 Jun 1998 15:05:40 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: "Krasnow, Greg" Cc: "Jose' Soares Da Silva" , interfaces postgres , "pgsql-sql@postgreSQL.org" Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Krasnow, Greg wrote: > I haven't looked at DATETIME stuff, but does Postgres not have something > similar to Oracle's SYSDATE? In Oracle you can set an Oracle DATE column to > have a default of SYSDATE. This way Oracle can fill in the column at the > time an insert is done. > Yes, you are right, and I noticed Jose' earlier mail about this on the 'sql' list. If you do: create table x (a timestamp DEFAULT CURRENT_TIMESTAMP, b varchar); It works AND it puts in the current time at INSERT of the new row. (I noticed if you use CURRENT_TIME instead, you get the time you created the table at, for every row, which is not very useful.) The only problem is that it doesn't change the value on an UPDATE! Any thoughts? Byron