On Nov 3, 2011, at 13:43, bricklen wrote:

> On Thu, Nov 3, 2011 at 10:29 AM, Edward W. Rouse <ero...@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




-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to