Errata

Print Print Icon

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By
Safari Books Online 3.3
Safari Online Problem 3.3

This seems to be a simpler solution in PostgreSQL. The INTERSECT in
the WHERE predicate seems unnecessary.

select * from emp where (ename, job, sal) in (select * from v);

 Anonymous 
Safari Books Online 3.5
Solution 3.5

select * from dept d where d.deptno not in (select distinct deptno
from emp);
deptno | dname | loc
--------+-------------+------------
40 | OPERATIONS | BOSTON
(1 row)

This seems to be a simpler solution in PostgreSQL.

 Anonymous 

"...this cookbook will help you take your SQL skills to the next level."
--John Vacca, "Tech Write Independent Reviewer", Amazon.com