Great! But I see the table format broken in langref 3.0. Check again. In 4.0 it's ok
Thank you, Ariel El lun., 18 jul. 2022 10:27, Mark Rotteveel <m...@lawinegevaar.nl> escribió: > On 16-07-2022 11:15, Mark Rotteveel wrote: > > On 14-07-2022 18:23, Ariel Álvarez wrote: > >> In language reference it is documented: > >> Table RDB$INDICES > >> Column RDB$INDEX_TYPE: > >> Distinguishes between an expression index (1) and a regular index (0 > >> or null). Not used in databases created before Firebird 2.0; hence, > >> regular indexes in upgraded databases are more more likely to store > >> null in this column > >> > >> But, according to this discussion: > >> https://github.com/FirebirdSQL/firebird/issues/4085 > >> <https://github.com/FirebirdSQL/firebird/issues/4085> > >> > >> RDB$INDEX_TYPE identifies a descending or ascending index. > >> > >> It appears the doc is wrong > > > > It looks like it. The error also occurs in The Firebird Book, Second > > Edition. I guess the error derives from there. The first edition of The > > Firebird Book says "Not currently used; likely to distinguish regular > > indexes from expression indexes when the feature is implemented", so I > > guess when expression indexes were added in Firebird 2, the assumption > > was codified in the book, and then copied when the Language Reference > > was written. > > > > I'll double check this and fix the documentation. > > I published a new version of the docs with this fixed. > > Mark > > -- > Mark Rotteveel > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel >
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
