In conjunction with Jonathan, this has gotten me to the point where it works, sort of. Now I just need to change it so that it does more than 1 at a time. Since it currently isn't in a loop, it affects one and quits. But I needed to get it to do that first, putting it in a loop should be the easy part.
Thanks. > -----Original Message----- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of bricklen > Sent: Thursday, November 03, 2011 1:44 PM > To: Edward W. Rouse > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] intervals > > 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; > expire := ('10' || ' days')::INTERVAL; > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
