Received: from localhost (IDENT:root@hectic-2.jpl.nasa.gov [128.149.68.204]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA55308 for ; Wed, 30 Jun 1999 22:45:14 -0400 (EDT) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id CAA14918; Thu, 1 Jul 1999 02:45:50 GMT Sender: lockhart@hub.org Message-ID: <377AD65E.353EFEB2@alumni.caltech.edu> Date: Thu, 01 Jul 1999 02:45:50 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Pablo Saul Salazar - CESERCOMP CC: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] How does operation with data types time??? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > I have another question, please should someone help me?? Sure. I understand this one, but didn't quite follow the previous question. Sorry... > How may does operation in fields of type "time"?? > for example , i want does the following query: > lab=>update ctrl set curren_time = current_time - 3; > is tell o want subtract three minutes to values in field current_time that > is of tipe time, It looks to me that we are missing a math routine to make this transparent (at least once you make the "3" into "timespan '3 min'"). But there is a workaround: postgres=> select time(datetime('today', time '3:30') - timespan '3 min'); time -------- 03:27:00 (1 row) Hope this helps... - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California