Errata
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted By | Date submitted | Date corrected |
---|---|---|---|---|---|
Printed | Page 44 Second line |
The word "stAtes" should be written as "stAtEs" in order to |
Anonymous | ||
Printed | Page 74 Second paragraph from the bottom |
The text "using the ISO format as instructed" should refer |
Anonymous | ||
Printed | Page 76 Table 3-20 |
The format "01:24:11.112" appears to be detailed to milliseconds, not microseconds as the description indicates. |
Anonymous | ||
Printed | Page 78 Table 3-22 |
Same probleem as Table 3-20. Should be "milliseconds". Also on second line from |
Anonymous | ||
Printed | Page 80 Table 3-23, last 3 constants |
Is midnight at the beginning or the end of each of these days? The description could be either. (As screwed |
Anonymous | ||
Printed | Page 99 Syntax diagram for ALTER TABLE |
The placeholder "table" is used in the syntax diagram |
Anonymous | ||
Printed | Page 110 IN PRINT: Near top, sub-section labeled "table_name" [italics] |
"The name of the table you are copying." |
Anonymous | ||
Printed | Page 114 The 2nd item from the bottom |
In "[ ASC | DESC | USING operator ]" the word operator |
Anonymous | ||
Printed | Page 128 |
"ON" description. The first sentence is a duplicate of the "source2" description. Was that intentional? |
Anonymous | ||
Printed | Page 129 Example 4-37, upper half |
My memory has the authors table as having a column named as "id". Is this example expecting the name to be "author_id"? |
Anonymous | ||
Printed | Page 132 Third sentence |
Currently the third sentence reads: |
Anonymous | ||
Printed | Page 142 Second paragraph, Second sentence |
In the book, this sentence reads: |
Anonymous | ||
Printed | Page 164 fourth line from the bottom |
The word "the" in "...not just "the" sequence..." should |
Anonymous | ||
Printed | Page 174 1-3 lines of Table 5-8 |
The font of "value::type", "value[index]", and "table.column" in |
Anonymous | ||
Printed | Page 193 Syntax for the octet_length() function |
The syntax diagram shows char_length(s); it should show |
Anonymous | ||
Printed | Page 200 1st paragraph, 2nd line |
The text says that the upper() function lowercases text. |
Anonymous | ||
Printed | Page 236 The paragraph under the "Modifying the prompt" |
heading, second sentence(middle of the page); |
Anonymous | ||
Printed | Page 253 Syntax for column constraints |
In the third line of the syntax, the word "table" is a |
Anonymous | ||
Printed | Page 253 Second paragraph from bottom, last sentence |
The term "constraint_name", which is rendered as |
Anonymous | ||
Printed | Page 255 "ON UPDATE action" list item |
The word "action" is a placeholder and should have been |
Anonymous | ||
Printed | Page 257 Second line |
The word "table" in the table constraint syntax is a |
Anonymous | ||
Printed | Page 265 Last paragraph, third sentence |
The "author" in "author_and_titles" should be plural. |
Anonymous | ||
Printed | Page 276 Example 7-31 |
The INSERT statement should use 107 for the customer ID |
Anonymous | ||
Printed | Page 278 Third paragraph |
"sequence_name", "where sequence_name is the name of the |
Anonymous | ||
Printed | Page 308 3rd paragraph |
In the first line of the hostssl description there is a typo, it says |
Anonymous | ||
Printed | Page 313 3rd paragraph, last sentence |
The text refers to the file pga_hba.conf. |
Anonymous | ||
Printed | Page 314 2nd line |
The first line of the first full paragraph on the page |
Anonymous | ||
Printed | Page 337 The code block(middle of the page) |
The first two lines of the code block need equal signs (=) |
Anonymous | ||
Printed | Page 372 middle of the page |
In VALID UNTIL 'infinity', the word infinity is a keyword |
Anonymous | ||
Printed | Page 375 Example 10-5 |
The font of the strings "newuser"(2nd line), and "n"(end |
Anonymous | ||
Printed | Page 393 Example 11-4 |
$ createlang plpgsql -U manager booktown |
Anonymous | ||
Printed | Page 401 Example 11-13 |
The comment about the declaration of the variable named |
Anonymous | ||
Printed | Page 415 3rd line from the bottom |
Example 11-39 shows the result of the in_stock() function, |
Anonymous | ||
Printed | Page 417 NOTE near top of page |
The note should refer to Example 11-40, not 11-38. |
Anonymous | ||
Printed | Page 419 3rd paragraph, 3rd sentence |
Shouldn't the first word be "The" instead of "Th"? |
Anonymous | ||
Printed | Page 419 |
IN PRINT: Same paragraph, last sentence: Shouldn't the keyword in the parenthesis be "EXIT" instead of "ELSE"? I understood EXIT leaves the |
Anonymous | ||
Printed | Page 423 Example 11-45 |
The function being created should not have a "2" at the end |
Anonymous | ||
Printed | Page 430 1st paragraph, 2nd sentence |
The check_shipment_addition trigger function is called |
Anonymous | ||
Printed | Page 614 2nd column |
"E" index items missing.. |
Anonymous |