From: Michael Glaesemann <grzm@seespotcode.net>
To: bricklen <bricklen@gmail.com>
Cc: Edward W. Rouse <erouse@comsquared.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: intervals
Date: Thu, 3 Nov 2011 14:20:40 -0400
Message-ID: <1EB4ED36-3679-4E6F-B065-911BCB7F518D@seespotcode.net> (raw)
In-Reply-To: <CAGrpgQ9GwvTi_ywmdAJUzRfoVRxwgAD9U87NURqqw-BWeoYNLQ@mail.gmail.com>
References: <00ee01cc9a4e$2b41f050$81c5d0f0$@com>
<CAGrpgQ9GwvTi_ywmdAJUzRfoVRxwgAD9U87NURqqw-BWeoYNLQ@mail.gmail.com>
On Nov 3, 2011, at 13:43, bricklen wrote:
> On Thu, Nov 3, 2011 at 10:29 AM, Edward W. Rouse <erouse@comsquared.com> wrote:
>> expire := '% days'::interval, limit;
>
> A couple ways spring to mind immediately. Using 10 as the example:
>
> expire := 10 * '1 day'::INTERVAL;
good.
> expire := ('10' || ' days')::INTERVAL;
bad.
Michael Glaesemann
grzm seespotcode net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: grzm@seespotcode.net, bricklen@gmail.com, erouse@comsquared.com
Subject: Re: intervals
In-Reply-To: <1EB4ED36-3679-4E6F-B065-911BCB7F518D@seespotcode.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox