Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6C8AC475E24 for ; Thu, 10 Oct 2002 23:06:14 -0400 (EDT) Received: from webphilippines.com.ph (unknown [61.9.41.33]) by postgresql.org (Postfix) with SMTP id 3D0C3475C5F for ; Thu, 10 Oct 2002 23:06:12 -0400 (EDT) Received: from [202.8.242.242] (HELO webphilippines.com) by webphilippines.com.ph (Stalker SMTP Server 1.7) with ESMTP id S.0000461523 for ; Fri, 11 Oct 2002 11:06:16 +0800 Message-ID: <3DA6432D.E253E07B@webphilippines.com> Date: Fri, 11 Oct 2002 11:19:10 +0800 From: Ric =?iso-8859-1?Q?Ma=F1alac?= X-Mailer: Mozilla 4.73 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: auto execute Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/30 X-Sequence-Number: 1545 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. thanks. ric