RE: Row Versioning, for jdbc updateable result sets

Don't know about JDBC, but couldn't you just use UPDATE <xxx> SET
<yyy>=<zzz> WHERE xmin=<stored/old xmin> AND primarykey=<stored/old pk> and
get the number of altered records? (if its zero then you know somethings
wrong and can investigate further)
- Stuart

> -----Original Message-----
> From: Dave Cramer [SMTP:dave(at)fastcrypt(dot)com]
> Sent: Thursday, June 14, 2001 4:34 AM
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: Row Versioning, for jdbc updateable result sets
>
> In order to be able to implement updateable result sets there needs to be
> a mechanism for determining if the underlying data has changed since the
> resultset was fetched. Short of retrieving the current data and comparing
> the entire row, can anyone think of a way possibly using the row version
> to determine if the data has been concurrently changed?
>
> Dave