Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2021-07-20 Thread Dmitry Yemanov
20.07.2021 14:50, Mark Rotteveel пишет: According to the Firebird Language Reference[1], the RDB$RELATION_FIELDS.RDB$UPDATE_FLAG signals whether a column is a computed column (0) or a regular column (1) (or I guess, updatable (1) vs not-updatable (0)). Updatable vs non-updatable is correct.

[Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2021-07-20 Thread Mark Rotteveel
According to the Firebird Language Reference[1], the RDB$RELATION_FIELDS.RDB$UPDATE_FLAG signals whether a column is a computed column (0) or a regular column (1) (or I guess, updatable (1) vs not-updatable (0)). In practice, this doesn't seem to be the case (see https://stackoverflow.com/ques

Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2012-01-03 Thread Ann Harrison
On Tue, Jan 3, 2012 at 4:56 PM, Mark Rotteveel wrote: >> >> The definitive sign of a computed field is RDB$COMPUTED_BLR in either >> RDB$FIELDS or RDB$DOMAINS if the field is defined through a domain > There is no RDB$DOMAINS ... Too many databases... indeed, it's RDB$FIELDS not system.domai

Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2012-01-03 Thread Mark Rotteveel
On 3-1-2012 22:38, Ann Harrison wrote: > Mark, > >> I am currently going over the JDBC metadata returned by Jaybird, and I >> was looking for a way to see if a column is COMPUTER BY / GENERATED >> ALWAYS AS. >> >> I found that I should probably look at RDB$FIELDS.RDB$COMPUTED_BLR or >> RDB$COMPUTED

Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2012-01-03 Thread Mark Rotteveel
On 3-1-2012 22:25, Mark Rotteveel wrote: > What is the exact meaning of this field? Is it only 0 for computed > columns, or also in other cases (eg views)? Both the Interbase 6 as > Helen's book mention it is not used, but apparently it is used (or at > least: being set). Ok, I already answered pa

Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2012-01-03 Thread Ann Harrison
Mark, > I am currently going over the JDBC metadata returned by Jaybird, and I > was looking for a way to see if a column is COMPUTER BY / GENERATED > ALWAYS AS. > > I found that I should probably look at RDB$FIELDS.RDB$COMPUTED_BLR or > RDB$COMPUTED_SOURCE for this, but I noticed that > RDB$RELAT

[Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2012-01-03 Thread Mark Rotteveel
I am currently going over the JDBC metadata returned by Jaybird, and I was looking for a way to see if a column is COMPUTER BY / GENERATED ALWAYS AS. I found that I should probably look at RDB$FIELDS.RDB$COMPUTED_BLR or RDB$COMPUTED_SOURCE for this, but I noticed that RDB$RELATION_FIELDS.RDB$U