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

Reply via email to