Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C8E7A8D31EE for ; Sun, 4 Mar 2012 07:29:42 -0400 (AST) Received: from outbound.icp-osb-irony-out9.iinet.net.au ([203.59.1.110]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S49dE-0007Kr-As for pgsql-sql@postgresql.org; Sun, 04 Mar 2012 11:29:42 +0000 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApMBAD5RU098qYNP/2dsb2JhbAAMN6cmkB8BAQEEOEARCw0LCRYPCQMCAQIBDzYTBgIBAcAwiS2EDoMiBJU+hgOFGoR1gnc X-IronPort-AV: E=Sophos;i="4.73,529,1325433600"; d="scan'208";a="75751786" Received: from unknown (HELO [192.168.0.2]) ([124.169.131.79]) by outbound.icp-osb-irony-out9.iinet.net.au with ESMTP/TLS/DHE-RSA-CAMELLIA256-SHA; 04 Mar 2012 19:29:24 +0800 Message-ID: <4F535213.7070402@iinet.net.au> Date: Sun, 04 Mar 2012 22:29:23 +1100 From: Peter Faulks User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.1) Gecko/20120208 Thunderbird/10.0.1 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: date arithmetic with columns References: <4F4E818F.9030402@iinet.net.au> <87hay4pump.fsf@hf.protecting.net> In-Reply-To: <87hay4pump.fsf@hf.protecting.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/28 X-Sequence-Number: 36423 Good question. I'm porting a (never actually finished) app from Firebird to Postgres. Now that I've re-read how the timestamptz (which Firebird doesn't have) actually works, I think I'll change the tables and get rid of the timezone lookup. Thanks On 4/03/2012 8:45 PM, hari.fuchs@gmail.com wrote: > 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? > >