I may be way too late, or others may have noted these already. This is a few suggestions that I collected in February:
========================================================== Document version: 0.901 P.13 Integer Data Types BIGINT is defined as 64-bit integer, INTEGER is defined as 4-byte integer. SMALLINT reveals nothing about bits or bytes. Not very consistent, but maybe this is all according to SQL rules? The create table example for INTEGER contains CONSTRAINT INTEG_60 is this a good example? P.17 Data Types for Dates and Times There are examples of the extract function (p.18) for TIME, but none for DATE. Extract functions for DATE are only mentioned in passing under TIMESTAMP (p.18). P.22 Table 3.5. Maximum Index Lengths by Page Size and Character Size The text above the column header Maximum length of an indexed string for a character set, bytes/character should just be Bytes/character (for the numbers 1 thru 6 in the column sub-headers). P.30 Table 3.8. Literals with Predefined Values of Date and Time A small glitch with the lines in the lower right of the table (or a pdf rendering problem?). P.31 Shorthand Casts for Date and Time Data Types TIMESTAMP has been split over two lines as TIMES-TAMP. P.32 Implicit Data Type Conversion << Implicit data conversion is not possible in Dialect 3 the CAST function is almost always required to avoid data type clashes. In Dialect 1, in many expressions, one type is implicitly cast to another without the need to use the CAST function. For instance, the following clause in a Dialect 1 SELECT statement is valid: WHERE DOC_DATE < '31.08.2014' and the string type will be cast to the date type implicitly. >> Valid in dialect 3 (as well as in dialect 1), I think. ========================================================== I had a few more, but realized they were the product of my confusion :-/ -- Aage J. ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140 _______________________________________________ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs