Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8E23A47632C for ; Fri, 11 Oct 2002 08:00:30 -0400 (EDT) Received: from wolff.to (unknown [66.93.197.35]) by postgresql.org (Postfix) with SMTP id C1BC8476317 for ; Fri, 11 Oct 2002 08:00:29 -0400 (EDT) Received: (qmail 29887 invoked by uid 500); 11 Oct 2002 12:09:07 -0000 Date: Fri, 11 Oct 2002 07:09:07 -0500 From: Bruno Wolff III To: Ric =?iso-8859-1?Q?Ma=F1alac?= Cc: pgsql-php@postgresql.org Subject: Re: auto execute Message-ID: <20021011120907.GA29853@wolff.to> Mail-Followup-To: Ric =?iso-8859-1?Q?Ma=F1alac?= , pgsql-php@postgresql.org References: <3DA6432D.E253E07B@webphilippines.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3DA6432D.E253E07B@webphilippines.com> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/33 X-Sequence-Number: 1548 On Fri, Oct 11, 2002 at 11:19:10 +0800, Ric Maņalac wrote: > hello, > > how can i make postgres to execute a query automatically during > scheduled times? > > here's my situation. i store records on a table. these records should be > removed 1 day after they were created. If they new to not be visible exactly 1 day after they are created, you can use a view to do that. You will still want to run a cron job to actually delete the records.