From: | Bryan Buchanan <bryanb(at)webbtide(dot)com(dot)au> |
---|---|
To: | macky <macky(at)edsamail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Knowing new item in table... |
Date: | 2001-08-03 09:54:55 |
Message-ID: | 3B6A74EF.17020C39@webbtide.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | tamsin | 2001-08-03 10:03:37 | RE: Knowing new item in table... |
Previous Message | Jason Wong | 2001-08-03 08:56:14 | Re: Knowing new item in table... |
From | Date | Subject | |
---|---|---|---|
Next Message | tamsin | 2001-08-03 10:03:37 | RE: Knowing new item in table... |
Previous Message | Christopher Sawtell | 2001-08-03 09:41:40 | Re: Activation of plsql |