Re: [GENERAL] last tuple affected

2005-01-27 Thread Bruno Wolff III
On Thu, Jan 27, 2005 at 12:45:13 +0100, Miguel Angel Tribaldos Hervas <[EMAIL PROTECTED]> wrote: > > I only need to know if a table has changed since the last check > (create, update...), but I want to avoid a trigger + artificial records table. > Is this information recorded somewhere, in a sys

Re: [GENERAL] last tuple affected

2005-01-27 Thread Miguel Angel Tribaldos Hervas
I only need to know if a table has changed since the last check (create, update...), but I want to avoid a trigger + artificial records table. Is this information recorded somewhere, in a system table perhaps? What about a hash value refered to any table? Thanks. >>Miguel Angel Tribaldos Hervas

Re: [GENERAL] last tuple affected

2005-01-27 Thread Richard Huxton
Miguel Angel Tribaldos Hervas wrote: Hi all! Two related questions about a problem i'm trying to solve: How can I know the last tuple affected by an insert/update operation per table?? Is there exists any function in Postgres for retrieving some hash value from a table?? You don't define what you m

[GENERAL] last tuple affected

2005-01-27 Thread Miguel Angel Tribaldos Hervas
Hi all! Two related questions about a problem i'm trying to solve: How can I know the last tuple affected by an insert/update operation per table?? Is there exists any function in Postgres for retrieving some hash value from a table?? Thanks in advance. -- Miguel Ángel Tribaldos -