Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 613DB8D31EE for ; Sun, 4 Mar 2012 05:45:51 -0400 (AST) Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S480i-0005iV-Ob for pgsql-sql@postgresql.org; Sun, 04 Mar 2012 09:45:50 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1S480P-0004rx-V5 for pgsql-sql@postgresql.org; Sun, 04 Mar 2012 10:45:29 +0100 Received: from static.187.232.9.176.clients.your-server.de ([176.9.232.187]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 04 Mar 2012 10:45:29 +0100 Received: from hari.fuchs by static.187.232.9.176.clients.your-server.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 04 Mar 2012 10:45:29 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: hari.fuchs@gmail.com Subject: Re: date arithmetic with columns Date: Sun, 04 Mar 2012 10:45:18 +0100 Lines: 8 Message-ID: <87hay4pump.fsf@hf.protecting.net> References: <4F4E818F.9030402@iinet.net.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: static.187.232.9.176.clients.your-server.de X-Archive: encrypt User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux) Cancel-Lock: sha1:KEMkyw81vrBR/UCb0MrvyEDu4CQ= X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/27 X-Sequence-Number: 36422 Peter Faulks writes: > I have two columns in two distinct tables, one is the starting time of > an event, timestamp without time zone. Data is the utc datetime (for > sorting across time zones), the other is the number of minutes to add. Maybe I'm missing something, but why don't you just use timestamp with timezone instead?