<!--

$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.13 2000/11/29 20:15:59 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.14 2000/12/09 22:59:25 momjian Exp $

-->

<chapter id="sql">

SELECT PNAME, PRICE

FROM PART

WHERE PNAME = 'Bolt' AND

(PRICE = 0 OR PRICE < 15);

(PRICE = 0 OR PRICE <= 15);

</programlisting>

will lead to the result:

INTERSECT

SELECT S.SNO, S.SNAME, S.CITY

FROM SUPPLIER S

WHERE S.SNO> 2;

WHERE S.SNO< 3;

</programlisting>

gives the result:

<programlisting>

SELECT * FROM London_Suppliers

WHEREP.PNAME = 'Screw';

WHERE PNAME = 'Screw';

</programlisting>

which will return the following table: