Received: from mail01.edsamail.com.ph (mail01.edsamail.com.ph [210.16.71.2]) by postgresql.org (8.11.3/8.11.1) with SMTP id f738UBf35232 for ; Fri, 3 Aug 2001 04:30:12 -0400 (EDT) (envelope-from macky@edsamail.com) Received: (qmail 27956 invoked from network); 3 Aug 2001 08:30:08 -0000 Received: from unknown (HELO antivirus.edsamail.com) (210.16.70.21) by mail01.edsamail.com.ph with SMTP; 3 Aug 2001 08:30:08 -0000 Received: (qmail 23222 invoked from network); 3 Aug 2001 07:04:53 -0000 Received: from unknown (HELO gatekeeper.edsamail.com) (210.16.70.21) by 210.16.70.21 with SMTP; 3 Aug 2001 07:04:53 -0000 Received: from macky (internal-87 [192.168.100.87]) by gatekeeper.edsamail.com (8.9.3/8.9.3) with SMTP id QAA32424; Fri, 3 Aug 2001 16:30:08 +0800 Message-ID: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> From: "macky" To: , Subject: Knowing new item in table... Date: Fri, 3 Aug 2001 16:26:12 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200108/8 X-Sequence-Number: 1814 im still in the dark when it comes to postgres..... is there a way i can know if there was a new entry on a table... scenario... i have a script that runs every 5 minutes... that script checks if there's a new entry in that table... and if YES there's a new entry ill do some processing... is there an internal utility that i can use in postgres that can tell me that this rows a new commers... hehehe.... if someone has other ideas on how to deal with this speak out... thanks in advance...... btw.. my idea is that that table will have an addtional column as reference lets say column "READ" 1 for yes 0 for NO