Re: last tuple affected

From: Richard Huxton <dev(at)archonet(dot)com>
To: Miguel Angel Tribaldos Hervas <mitriher(at)teleco(dot)upv(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: last tuple affected
Date: 2005-01-27 11:34:18
Message-ID: 41F8D1BA.3000908@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 mean by "last", and it's not a simple thing.
You could attach triggers to the tables and have them record changes.

Perhaps tell us what you are trying to do, rather than how you want to
do it.
--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Miguel Angel Tribaldos Hervas 2005-01-27 11:45:13 Re: last tuple affected
Previous Message Paul Thomas 2005-01-27 11:30:38 Re: Numeric type