Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3D73B62E50B for ; Sun, 7 Jun 2009 15:59:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99343-05 for ; Sun, 7 Jun 2009 15:59:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp110.biz.mail.mud.yahoo.com (smtp110.biz.mail.mud.yahoo.com [68.142.201.179]) by mail.postgresql.org (Postfix) with SMTP id ED4266338B8 for ; Sun, 7 Jun 2009 15:59:16 -0300 (ADT) Received: (qmail 99225 invoked from network); 7 Jun 2009 18:59:15 -0000 Received: from unknown (HELO ?192.168.5.110?) (rm_pg@76.201.140.35 with plain) by smtp110.biz.mail.mud.yahoo.com with SMTP; 7 Jun 2009 18:59:15 -0000 X-Yahoo-SMTP: acjdBE2swBAAX9ja0RY4hQi0ggqg.Ml3.omUEQJ1xZsuGIb6CRE- X-YMail-OSG: 5Z.QIFsVM1mLqcOgKy8bQeyST4s_E1d3Gs7eK9WziBK.KOVWrCXl91mSvu9vOIX93wwlJcUfw_P1n_yXZ0qanohayTGVviqnjaK_idZQXP_k.yvc7mw4_m0MJ3162WqYoZwlmo4hdUIl5OJvNuG2JWrOBeewwkSA1VauEoSV25HrR1kelE29U8mRAhqpo19KcczdiE6KCBVBYue1AsofR2zj43QDY5AkTXY0HJ.AlasB2E9RBNt4iUaPkPIQ7X8XQIxNnuwrumu7Eju9J6uNLIclYa7zFsTRRFJJCEjQkvoVhwKKcxdPtNLucjSgEtOvw_FGUQ-- X-Yahoo-Newman-Property: ymail-3 Message-ID: <4A2C0E02.9070908@cheapcomplexdevices.com> Date: Sun, 07 Jun 2009 11:59:14 -0700 From: Ron Mayer User-Agent: Thunderbird 2.0.0.21 (X11/20090318) MIME-Version: 1.0 To: Sebastien FLAESCH CC: pgsql-general@postgresql.org, mmoncure@gmail.com Subject: Re: INTERVAL SECOND limited to 59 seconds? References: <4A127038.3010103@4js.com> In-Reply-To: <4A127038.3010103@4js.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200906/367 X-Sequence-Number: 148711 Finally got around to looking at this thread. Looks like the original questions from the thread got resolved, but I found this behaviour surprising: regression=# select interval '1' day to second; interval ---------- @ 1 hour (1 row) Should this be 1 second? If so I can send a patch. regression=# select version(); version ----------------------------------------------------------------------------------------------------------- PostgreSQL 8.4beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.4 (Ubuntu 4.2.4-1ubuntu3), 32-bit (1 row)