        7 |           4
(2 rows)</PRE
><P></P
><P
>    The output of the parser this time is the query tree:

</P><PRE
CLASS="PROGRAMLISTING"
>SELECT shoe_ready.shoename, shoe_ready.sh_avail,
       shoe_ready.sl_name, shoe_ready.sl_avail,
       shoe_ready.total_avail
  FROM shoe_ready shoe_ready
 WHERE shoe_ready.total_avail &gt;= 2;</PRE
><P>

    The first rule applied will be the one for the
    <TT
CLASS="LITERAL"
>shoe_ready</TT
> view and it results in the
    query tree:

</P><PRE
CLASS="PROGRAMLIS