Received: from proxy.bazzanese.com (sferac@ip157.tol11.interbusiness.it [195.120.106.157]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA05726 for ; Thu, 11 Jun 1998 08:29:46 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id LAA03780; Thu, 11 Jun 1998 11:41:24 GMT Date: Thu, 11 Jun 1998 11:41:24 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy To: Hannu cc: Byron Nikolaidis , interfaces postgres Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs In-Reply-To: <357F9271.D4F12B47@trust.ee> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Thu, 11 Jun 1998, Hannu wrote: > Byron Nikolaidis wrote: > > > > 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? > > Why not use the system column tmin for this purpose? > > hannu=> create table test(i int); > CREATE > hannu=> insert into test values(5); > INSERT 17454 1 > hannu=> select tmin,tmax,i from test; > tmin |tmax |i > -----------------------------+-------+- > Thu Jun 11 11:12:17 1998 EEST|current|5 > (1 row) > > hannu=> update test set i=2; > UPDATE 1 > hannu=> select tmin,tmax,i from test; > tmin |tmax |i > -----------------------------+-------+- > Thu Jun 11 11:13:00 1998 EEST|current|2 > (1 row) > > ------ > Hannu > One minute! what's that tmin? What version do you have? I have v6.3.2 and it doesn't know tmin. prova=> create table test(i int); CREATE prova=> insert into test values(5); INSERT 15650 1 prova=> select tmin,tmax,i from test; ERROR: attribute 'tmin' not found Jose'