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