Re: intervals

From: bricklen <bricklen(at)gmail(dot)com>
To: "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: intervals
Date: 2011-11-03 17:43:39
Message-ID: CAGrpgQ9GwvTi_ywmdAJUzRfoVRxwgAD9U87NURqqw-BWeoYNLQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Nov 3, 2011 at 10:29 AM, Edward W. Rouse <erouse(at)comsquared(dot)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;

In response to

  • intervals at 2011-11-03 17:29:40 from Edward W. Rouse

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Edward W. Rouse 2011-11-03 17:56:09 Re: intervals
Previous Message Jonathan S. Katz 2011-11-03 17:41:16 Re: intervals