agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: David Alan Nelson <D.A.Nelson@newcastle.ac.uk>
To: Postgres <postgres@postgres.Berkeley.EDU>
Cc: Neville Smith <n.s.smith@newcastle.ac.uk>
Subject: Time Queries
Date: Thu, 1 Sep 1994 14:03:39 +0100 (BST)
Message-ID: <AA18254.9409011303@swinhoe.ncl.ac.uk> (raw)

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.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: D.A.Nelson@newcastle.ac.uk, n.s.smith@newcastle.ac.uk
  Subject: Re: Time Queries
  In-Reply-To: <AA18254.9409011303@swinhoe.ncl.ac.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox