Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id CB559B5DF7D for ; Thu, 3 Nov 2011 15:21:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 80044-04-6 for ; Thu, 3 Nov 2011 18:21:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from proton.planetargon.com (proton.planetargon.com [198.145.115.11]) by mail.postgresql.org (Postfix) with ESMTP id B7B9BB5DDB4 for ; Thu, 3 Nov 2011 15:21:10 -0300 (ADT) Received: by proton.planetargon.com (Postfix, from userid 502) id 73FC782DDDF; Thu, 3 Nov 2011 11:21:08 -0700 (PDT) Received: from [192.168.1.131] (unknown [68.64.144.221]) by proton.planetargon.com (Postfix) with ESMTP id 6BCC382DDDC; Thu, 3 Nov 2011 11:21:04 -0700 (PDT) Subject: Re: intervals Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Michael Glaesemann In-Reply-To: Date: Thu, 3 Nov 2011 14:20:40 -0400 Cc: "Edward W. Rouse" , pgsql-sql@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <1EB4ED36-3679-4E6F-B065-911BCB7F518D@seespotcode.net> References: <00ee01cc9a4e$2b41f050$81c5d0f0$@com> To: bricklen X-Mailer: Apple Mail (2.1084) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201111/10 X-Sequence-Number: 35983 On Nov 3, 2011, at 13:43, bricklen wrote: > On Thu, Nov 3, 2011 at 10:29 AM, Edward W. Rouse = wrote: >> expire :=3D '% days'::interval, limit; >=20 > A couple ways spring to mind immediately. Using 10 as the example: >=20 > expire :=3D 10 * '1 day'::INTERVAL; good. > expire :=3D ('10' || ' days')::INTERVAL; bad. Michael Glaesemann grzm seespotcode net