e.  If the entries are all quoted literal constants,
   coercing the first is sufficient to determine the assumed type for all:

</P><PRE
CLASS="PROGRAMLISTING"
>SELECT * FROM machines
WHERE ip_address IN (VALUES('192.168.0.1'::inet), ('192.168.0.10'), ('192.168.1.43'));</PRE
><P></P
><DIV
CLASS="TIP"
><BLOCKQUOTE
CLASS="TIP"
><P
><B
>Tip: </B
>    For simple <TT
CLASS="LITERAL"
>IN</TT
> tests, it's better to rely on the
    list-of-scalars form of <TT
CLASS="LITERAL"
>IN</TT
> than to write a <TT
CLASS="C