Knowing new item in table...

From: "macky" <macky(at)edsamail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: Knowing new item in table...
Date: 2001-08-03 08:26:12
Message-ID: 006501c11bf5$f4b20750$5764a8c0@edsamail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jason Wong 2001-08-03 08:56:14 Re: Knowing new item in table...
Previous Message Horst Herb 2001-08-03 03:59:26 Re: [INTERFACES] Using mod_python apache module

Browse pgsql-sql by date

  From Date Subject
Next Message Jason Wong 2001-08-03 08:56:14 Re: Knowing new item in table...
Previous Message Tom Lane 2001-08-03 05:25:41 Re: converting timestamps to ints