Errata for Seven Databases in Seven Weeks
We try to keep our books accurate, but sometimes mistakes creep
in. This page lists the errors submitted by our astute readers.
If you've found a new error, please
submit it.
The latest version of the book is P1.0,
released 8 days ago.
If you've bought a PDF of the book and would like to upgrade
it to this version (for free), visit your
home page.
| PDF |
Paper |
Description |
Found in |
Fixed in |
| 45 |
|
#49205: When combining the metaphone search and ordering by Levenshtein distance, I believe the results shown are incorrect. I get the results show below, correctly sorted as the Levenshtein distance from "Robin Williams" to "Robin Williams" is 0, and should be the first result in the list. Robin Williams cannot rank #3 if the sort is done correctly. I'm using Postgres 9.1.3 on Mac.
book=# select * from actors where metaphone(name,8) % metaphone('Robin Williams',8)
book-# order by levenshtein(lower('Robin Williams'),lower(name));
actor_id | name
----------+-----------------
4093 | Robin Williams
2442 | John Williams
4479 | Steven Williams
4090 | Robin Shou
(4 rows)--Todd Diehl #49205: When combining the metaphone search and ordering by Levenshtein distance, I believe the results shown are incorrect. I get the results show b ...more... |
B6.0
26-Apr-12
|
|
| 56 |
|
#49204: Using a Mac with Postgres 9.1.3.
Twice near the bottom of the page there are SQL queries that have & instead of & in them.
WHERE to_tsvector(title) @@ to_tsquery('english', 'night & day');
should be
WHERE to_tsvector(title) @@ to_tsquery('english', 'night & day');
SELECT to_tsvector('A Hard Day''s Night'), to_tsquery('english', 'night & day');
should be
SELECT to_tsvector('A Hard Day''s Night'), to_tsquery('english', 'night & day');--Todd Diehl #49204: Using a Mac with Postgres 9.1.3.
Twice near the bottom of the page there are SQL queries that have & instead of & in them.
WHERE to_ ...more... |
B6.0
26-Apr-12
|
|
| 271 |
|
#49365: Under Neo4j's Weaknesses its stated that "Edges in Neo4j cannot direct a vertex back on itself." As I read it, that would say that a node cannot have relationships with itself.
In practice it works, and it's also mentioned in the Docs: docs.neo4j.org/annotated/#graphdb-neo4j-relationships
Its possible I'm misreading it, graph theory isn't my thing :)
--Ethan Soutar-Rau #49365: Under Neo4j's Weaknesses its stated that "Edges in Neo4j cannot direct a vertex back on itself." As I read it, that would say that a node cann ...more... |
P1.0
22-May-12
|
|
