ct2" id="RANGETYPES-DEFINING"><div class="titlepage"><div><div><h3 class="title">8.17.8. Defining New Range Types <a href="#RANGETYPES-DEFINING" class="id_link">#</a></h3></div></div></div><p>
   Users can define their own range types. The most common reason to do
   this is to use ranges over subtypes not provided among the built-in
   range types.
   For example, to define a new range type of subtype <code class="type">float8</code>:

</p><pre class="programlisting">
CREATE TYPE floatrange AS RANGE (
   