<!--

$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.148 2004/09/18 15:28:03 tgl Exp $

$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.149 2004/09/20 04:19:50 tgl Exp $

-->

<chapter id="datatype">

</row>

<row>

<entry><type>bit</type></entry>

<entry><type>bit [ (<replaceable>n</replaceable>) ]</type></entry>

<entry></entry>

<entry>fixed-length bit string</entry>

</row>

<row>

<entry><type>bit varying(<replaceable>n</replaceable>)</type></entry>

<entry><type>varbit(<replaceable>n</replaceable>)</type></entry>

<entry><type>bit varying [(<replaceable>n</replaceable>) ]</type></entry>

<entry><type>varbit</type></entry>

<entry>variable-length bit string</entry>

</row>

</row>

<row>

<entry><type>character varying(<replaceable>n</replaceable>)</type></entry>

<entry><type>varchar(<replaceable>n</replaceable>)</type></entry>

<entry><type>character varying [(<replaceable>n</replaceable>) ]</type></entry>

<entry><type>varchar [(<replaceable>n</replaceable>) ]</type></entry>

<entry>variable-length character string</entry>

</row>

<row>

<entry><type>character(<replaceable>n</replaceable>)</type></entry>

<entry><type>char(<replaceable>n</replaceable>)</type></entry>

<entry><type>character [(<replaceable>n</replaceable>) ]</type></entry>

<entry><type>char [(<replaceable>n</replaceable>) ]</type></entry>

<entry>fixed-length character string</entry>

</row>

</row>

<row>

<entry><type>interval(<replaceable>p</replaceable>)</type></entry>

<entry><type>interval [(<replaceable>p</replaceable>) ]</type></entry>

<entry></entry>

<entry>time span</entry>

</row>

<row>

<entry><type>path</type></entry>

<entry></entry>

<entry>openand closed geometric path in the plane</entry>

<entry>openor closed geometric path in the plane</entry>

</row>

<row>

<row>

<entry><type>timestamp [ (<replaceable>p</replaceable>) ] [ without time zone ]</type></entry>

<entry><type>timestamp</type></entry>

<entry><type></type></entry>

<entry>date and time</entry>

</row>