Hi.
I was reading the postgres tutorial and I was confused by this example. I'll post here the example and the given tables.
Example 2-1. The Suppliers and Parts Database
SUPPLIER SNO | SNAME | CITY SELLS SNO | PNO
-----+---------+-------- -----+-----
1 | Smith | London 1 | 1
2 | Jones | Paris 1 | 2
3 | Adams | Vienna 2 | 4
4 | Blake | Rome 3 | 1
3 | 3
4 | 2
PART PNO | PNAME | PRICE 4 | 3
-----+---------+--------- 4 | 4
1 | Screw | 10
2 | Nut | 8
3 | Bolt | 15
4 | Cam | 25
SELECT PNAME, PRICE
FROM PART
WHERE PNAME = 'Bolt' AND
(PRICE = 0 OR PRICE < 15);
will lead to the result:
FROM PART
WHERE PNAME = 'Bolt' AND
(PRICE = 0 OR PRICE < 15);
will lead to the result:
PNAME | PRICE
--------+--------
Bolt | 15
From what I understand, the select statement should query the PART
table for records with PNAME equal to Bolt and having a PRICE of
either 0 or less tahn 15. The row with PNAME Bolt has a PRICE EQUAL
to 15 so the select statement should have resulted to an empty set.
Was my understanding wrong?
Thanks,
yen
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
