PostgreSQL 7.4.6 ʸ��
��Υڡ��	��ᤷ		��	��Υڡ��

�� 9�ϴؿ��ȱ黻��

�ܼ�

9.12.1. CASE
9.12.2. COALESCE
9.12.3. NULLIF

9.13. ��¾�δؿ�

9.14. ��ؿ��ȱ黻��

9.15. ��ؿ�

9.16. ��䤤��碌��

9.16.1. EXISTS
9.16.2. IN
9.16.3. NOT IN
9.16.4. ANY/SOME
9.16.5. ALL
9.16.6. �Ԥ˴ؤ��Ƥ��

9.17. �Ԥ��

9.17.1. IN
9.17.2. NOT IN
9.17.3. ANY/SOME (��)
9.17.4. ALL (��)
9.17.5. �Ԥ˴ؤ��Ƥ��

PostgreSQL��Ȥ߹��ߥǡ��Ф��ƿ�¿��δؿ��ȱ黻�Ҥ��Ѱդ��Ƥ��ޤ�� ޤ��ѡ��V�ǲ��⤷�Ƥ��褦�ˡ��桼��ȼ��δؿ��ȱ黻�Ҥ��뤳�Ȥ�Ǥ��ޤ�� psql��\df��ޥ�ɤ�\do��ޥ�ɤϤ��줾�줹�٤Ƥλ��Ѳ�ǽ�ʴؿ��ȱ黻�ҤΥꥹ�Ȥ�ɽ��ޤ��

�⤷�ܿ��ˤʤ�ΤǤ��С��ܾϤ��¿��δؿ��ȱ黻�Ҥϡ��ۤȤ�ɤδ��Ū��ѱ黻�ҡ��ӱ黻�Ҥ��Ӵ��Ĥ��Ū�˰��Ĥ��ؿ��ơ�ɸ��SQL�ǵ��ꤵ��Ƥ��ʤ��դ��Ƥ�� ĥ��ǽ�Τ��Ĥ��ϡ�¾��SQL�ǡ��١��ƥ�ˤ��äƤ��ꡢ¿��ξ�礳�ε�ǽ�ˤϳƼ��֤Ǹߴ��ޤ��

9.1. ��黻��

�̾��黻�Ҥϻ��ѤǤ��ޤ��

AND

OR

NOT

SQL��3�ͤΥ֡��黻��Ѥ��NULL�ͤ�"��"��̣��ޤ�� ʲ��ο��ɽ�򻲾Ȥ��Ƥ��

`a`	`b`	`a` AND `b`	`a` OR `b`
TRUE	TRUE	TRUE	TRUE
TRUE	FALSE	FALSE	TRUE
TRUE	NULL	NULL	TRUE
FALSE	FALSE	FALSE	FALSE
FALSE	NULL	FALSE	NULL
NULL	NULL	NULL	NULL

`a`	NOT `a`
TRUE	FALSE
FALSE	TRUE
NULL	NULL

AND�黻�Ҥ�OR�黻�Ҥϸ򴹲�ǽ�Ǥ�� Ĥޤꡢ��̤˱ƶ��Ϳ��뤳�Ȥʤ��Υ��ڥ��ɤ�򴹤��뤳�Ȥ��Ǥ��ޤ�� ɾ��ˤĤ��ƤΤ��ܺ٤ˤĤ��4.2.11�򻲾Ȥ��Ƥ��

��Υڡ��	�ۡ��	��Υڡ��
��ǡ��	��	��ӱ黻��

�� 9�ϴؿ��ȱ黻��

9.1. �����黻��

9.1. ��黻��