Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id GAA19720 for postgres-redist; Thu, 1 Sep 1994 06:04:02 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199409011304.GAA19720@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from cheviot.ncl.ac.uk (cheviot.ncl.ac.uk [128.240.2.10]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id GAA19710 for ; Thu, 1 Sep 1994 06:04:00 -0700 Received: from bowes.ncl.ac.uk by cheviot.ncl.ac.uk id (5.65cVUW/NCL-CMA.1.35 for ) with SMTP; Thu, 1 Sep 1994 14:03:41 +0100 From: "David Alan Nelson" Message-Id: Subject: Time Queries To: postgres@postgres.Berkeley.EDU (Postgres) Date: Thu, 1 Sep 1994 14:03:39 +0100 (BST) Cc: n.s.smith@newcastle.ac.uk (Neville Smith) X-Mailer: ELM [version 2.4 PL23] Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Length: 494 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Thu, 01 Sep 94 06:04:01 -0700 Resent-XMts: smtp I have a table with a column in it storing time information, i.e. the column has type abstime. In Postgres 4.1, I need to be able to add a relative time amount on to this, i.e. using the syntax @ '7' "days", as stated in the reference manual. I can not get this to work for either fields of type reltime or type abstime. Can anybody tell me how to do this. Cheers Dave -- Mail ID : D.A.Nelson@newcastle.ac.uk Computing Science, University of Newcastle upon Tyne, UK. (091) 222 8789 ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ==============================================================================