Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F14D52E004A for ; Wed, 26 Mar 2008 13:06:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 82961-01 for ; Wed, 26 Mar 2008 13:05:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.xmtservices.net (unknown [66.224.65.210]) by postgresql.org (Postfix) with SMTP id C14F12E0031 for ; Wed, 26 Mar 2008 13:05:57 -0300 (ADT) Received: (qmail 2351 invoked from network); 26 Mar 2008 16:05:56 -0000 Received: from unknown (HELO vaio.xmtservices.net) (192.168.0.101) by errol.xmtservices.net with SMTP; 26 Mar 2008 16:05:56 -0000 From: Shawn To: pgsql-sql@postgresql.org Subject: Question 2 Interval and timestamptz Date: Wed, 26 Mar 2008 16:05:56 +0000 User-Agent: KMail/1.9.9 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803261605.56116.postgres@xmtservices.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/172 X-Sequence-Number: 30500 Hello! The second part of my question is: Given a value as an interval, see previous posting, is there a simply method to take a given timestamptz value and a given interval value and create the sum or difference of the 2 in timestamptz format? The scenario is that the afore mentioned tables, see previous post, in addition to the duration varchar field, also have a field called event_at_utc which is a timestamptz type. I need to calculate the end time of the event given the interval calculated from the duration (varchar) field. Any all all help is greatly appreciated. Shawn