Re: Knowing new item in table...

On Fri, 03 Aug 2001 20:26, 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...

Here's mine:

Make sure the tables you wish to check have an id field of type SERIAL.
Then check the last entry number in the associated sequence when you wish to
check for new entries.

That will tell you if there are any new entries.

--
Sincerely etc.,

NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ paradise . net . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

-> Please refrain from using HTML or WORD attachments in e-mails to me <-