Received: from ns1.gremlins.com.hk (ns1.gremlins.com.hk [152.101.50.194]) by postgresql.org (8.11.3/8.11.1) with SMTP id f738uXf43182 for ; Fri, 3 Aug 2001 04:56:34 -0400 (EDT) (envelope-from postgresql@gremlins.com.hk) Received: (qmail 12734 invoked from network); 3 Aug 2001 08:55:09 -0000 Received: from unknown (HELO mojo) (10.0.0.35) by mail.gremlins.com.hk with SMTP; 3 Aug 2001 08:55:09 -0000 Message-ID: <01ad01c11bfa$26e684e0$2300000a@gremlins.com.hk> From: "Jason Wong" To: "macky" , , References: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> Subject: Re: Knowing new item in table... Date: Fri, 3 Aug 2001 16:56:14 +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.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200108/9 X-Sequence-Number: 1815 The best way to do this is probably have an auto-increment field in your table. When your script runs it checks and stores the highest value in that auto-increment field and compares with the value it had the previous time it was run. It then returns all records greater than the previous value of the auto-increment field. regards -- Jason Wong Gremlins Associates ----- Original Message ----- From: macky To: ; Sent: Friday, August 03, 2001 4:26 PM Subject: [NOVICE] Knowing new item in table... > 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 > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >