--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

> Not that I approve, but you could use the RDB$DB_KEY
>

--- In firebird-support@yahoogroups.com, Wolfgang Rohdewald
<wolfgang@...> wrote:

>
> doesn't the ROWS keyword do that in FB 2.0? From the release notes:
>
> It can be used in unions, any kind of subquery and in
> UPDATE or DELETE statements
>

Interesting. I'm not (yet) familar with Firebird although I hope to
be soon. I assume I can use this RDB$DB_KEY value identically to how
postgres uses the ctid in my previous example.

So my assumption is the RDB$DB_KEY technique would work for Firebird
1.0, 1.5, and 2.0, while this new ROWS keyword is cleaner but only
works on 2.0.

Thanks for the quick responses!
John