Re: intervals - Mailing list pgsql-sql

From bricklen
Subject Re: intervals
Date
Msg-id CAGrpgQ9GwvTi_ywmdAJUzRfoVRxwgAD9U87NURqqw-BWeoYNLQ@mail.gmail.com
Whole thread Raw
In response to intervals  ("Edward W. Rouse" <erouse@comsquared.com>)
Responses Re: intervals  ("Edward W. Rouse" <erouse@comsquared.com>)
Re: intervals  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-sql
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;
expire := ('10' || ' days')::INTERVAL;


pgsql-sql by date:

Previous
From: "Edward W. Rouse"
Date:
Subject: intervals
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: intervals