Received: from ns1.webbtide.com.au (webbt1.lnk.telstra.net [139.130.64.210]) by postgresql.org (8.11.3/8.11.1) with SMTP id f739lQf56859 for ; Fri, 3 Aug 2001 05:47:26 -0400 (EDT) (envelope-from bryanb@webbtide.com.au) Received: (qmail 30248 invoked from network); 3 Aug 2001 10:10:03 -0000 Received: from bjb.webbtide.com.au (HELO webbtide.com.au) (bryanb@192.168.1.11) by ns1.webbtide.com.au with SMTP; 3 Aug 2001 10:10:03 -0000 Message-ID: <3B6A74EF.17020C39@webbtide.com.au> Date: Fri, 03 Aug 2001 19:54:55 +1000 From: Bryan Buchanan Organization: wEbbTide Systems Pty Ltd X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: macky CC: pgsql-sql@postgresql.org, pgsql-novice@postgresql.org Subject: Re: Knowing new item in table... References: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/10 X-Sequence-Number: 1816 macky wrote: > 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 You could have a timestamp field with a default value of 'now' defined, and have your script select all records from the table with a time after 5 minutes ago. Bryan