HDBC-1.0.1: doc/Database-HDBC-ColTypes.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--Rendered using the Haskell Html Library v0.2-->
<HTML
><HEAD
><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"
><TITLE
>Database.HDBC.ColTypes</TITLE
><LINK HREF="haddock.css" REL="stylesheet" TYPE="text/css"
><SCRIPT SRC="haddock.js" TYPE="text/javascript"
></SCRIPT
></HEAD
><BODY
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="topbar"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD
><IMG SRC="haskell_icon.gif" WIDTH="16" HEIGHT="16" ALT=" "
></TD
><TD CLASS="title"
>Haskell Database Connectivity (HDBC)</TD
><TD CLASS="topbut"
><A HREF="index.html"
>Contents</A
></TD
><TD CLASS="topbut"
><A HREF="doc-index.html"
>Index</A
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="modulebar"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD
><FONT SIZE="6"
>Database.HDBC.ColTypes</FONT
></TD
><TD ALIGN="right"
><TABLE CLASS="narrow" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="infohead"
>Portability</TD
><TD CLASS="infoval"
>portable</TD
></TR
><TR
><TD CLASS="infohead"
>Stability</TD
><TD CLASS="infoval"
>provisional</TD
></TR
><TR
><TD CLASS="infohead"
>Maintainer</TD
><TD CLASS="infoval"
>John Goerzen <jgoerzen@complete.org></TD
></TR
></TABLE
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="section1"
>Description</TD
></TR
><TR
><TD CLASS="doc"
><P
>Definitions of, and utilities for, specifying what type of data is represented
by a column.
</P
><P
>Written by John Goerzen, jgoerzen@complete.org
</P
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="section1"
>Synopsis</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>data</SPAN
> <A HREF="#t%3ASqlColDesc"
>SqlColDesc</A
> = <A HREF="#v%3ASqlColDesc"
>SqlColDesc</A
> {<TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="recfield"
><A HREF="#v%3AcolType"
>colType</A
> :: <A HREF="Database-HDBC-ColTypes.html#t%3ASqlTypeId"
>SqlTypeId</A
></TD
></TR
><TR
><TD CLASS="recfield"
><A HREF="#v%3AcolSize"
>colSize</A
> :: (Maybe Int)</TD
></TR
><TR
><TD CLASS="recfield"
><A HREF="#v%3AcolOctetLength"
>colOctetLength</A
> :: (Maybe Int)</TD
></TR
><TR
><TD CLASS="recfield"
><A HREF="#v%3AcolDecDigits"
>colDecDigits</A
> :: (Maybe Int)</TD
></TR
><TR
><TD CLASS="recfield"
><A HREF="#v%3AcolNullable"
>colNullable</A
> :: (Maybe Bool)</TD
></TR
></TABLE
>}</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>data</SPAN
> <A HREF="#t%3ASqlTypeId"
>SqlTypeId</A
> </TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
>= <A HREF="#v%3ASqlCharT"
>SqlCharT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlVarCharT"
>SqlVarCharT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlLongVarCharT"
>SqlLongVarCharT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlWCharT"
>SqlWCharT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlWVarCharT"
>SqlWVarCharT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlWLongVarCharT"
>SqlWLongVarCharT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlDecimalT"
>SqlDecimalT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlNumericT"
>SqlNumericT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlSmallIntT"
>SqlSmallIntT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntegerT"
>SqlIntegerT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlRealT"
>SqlRealT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlFloatT"
>SqlFloatT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlDoubleT"
>SqlDoubleT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlBitT"
>SqlBitT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlTinyIntT"
>SqlTinyIntT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlBigIntT"
>SqlBigIntT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlBinaryT"
>SqlBinaryT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlVarBinaryT"
>SqlVarBinaryT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlLongVarBinaryT"
>SqlLongVarBinaryT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlDateT"
>SqlDateT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlTimeT"
>SqlTimeT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlTimestampT"
>SqlTimestampT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlUTCDateTimeT"
>SqlUTCDateTimeT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlUTCTimeT"
>SqlUTCTimeT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalT"
>SqlIntervalT</A
> <A HREF="Database-HDBC-ColTypes.html#t%3ASqlInterval"
>SqlInterval</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlGUIDT"
>SqlGUIDT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlUnknownT"
>SqlUnknownT</A
> String</TD
></TR
></TABLE
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>data</SPAN
> <A HREF="#t%3ASqlInterval"
>SqlInterval</A
> </TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
>= <A HREF="#v%3ASqlIntervalMonthT"
>SqlIntervalMonthT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalYearT"
>SqlIntervalYearT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalYearToMonthT"
>SqlIntervalYearToMonthT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalDayT"
>SqlIntervalDayT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalHourT"
>SqlIntervalHourT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalMinuteT"
>SqlIntervalMinuteT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalSecondT"
>SqlIntervalSecondT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalDayToHourT"
>SqlIntervalDayToHourT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalDayToMinuteT"
>SqlIntervalDayToMinuteT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalDayToSecondT"
>SqlIntervalDayToSecondT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalHourToMinuteT"
>SqlIntervalHourToMinuteT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalHourToSecondT"
>SqlIntervalHourToSecondT</A
></TD
></TR
><TR
><TD CLASS="decl"
>| <A HREF="#v%3ASqlIntervalMinuteToSecondT"
>SqlIntervalMinuteToSecondT</A
></TD
></TR
></TABLE
></TD
></TR
></TABLE
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="section1"
>Documentation</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>data</SPAN
> <A NAME="t%3ASqlColDesc"
></A
><B
>SqlColDesc</B
> </TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="ndoc"
><P
>The description of a column.
</P
><P
>Fields are Nothing if the database backend cannot supply the
requested information.
</P
><P
>The colSize field works like this:
</P
><P
>For character types, the maximum width of the column. For numeric
types, the total number of digits allowed. See the ODBC manual for more.
</P
><P
>The colOctetLength field is defined for character and binary types, and
gives the number of bytes the column requires, regardless of encoding.
</P
></TD
></TR
><TR
><TD CLASS="section4"
>Constructors</TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="5" CELLPADDING="0"
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlColDesc"
></A
><B
>SqlColDesc</B
></TD
><TD CLASS="rdoc"
></TD
></TR
><TR
><TD CLASS="body" COLSPAN="2"
><TABLE CLASS="vanilla" CELLSPACING="1" CELLPADDING="0"
><TR
><TD CLASS="arg"
><A NAME="v%3AcolType"
></A
><B
>colType</B
> :: <A HREF="Database-HDBC-ColTypes.html#t%3ASqlTypeId"
>SqlTypeId</A
></TD
><TD CLASS="rdoc"
>Type of data stored here
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3AcolSize"
></A
><B
>colSize</B
> :: (Maybe Int)</TD
><TD CLASS="rdoc"
>The size of a column
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3AcolOctetLength"
></A
><B
>colOctetLength</B
> :: (Maybe Int)</TD
><TD CLASS="rdoc"
>The maximum size in octets
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3AcolDecDigits"
></A
><B
>colDecDigits</B
> :: (Maybe Int)</TD
><TD CLASS="rdoc"
>Digits to the right of the period
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3AcolNullable"
></A
><B
>colNullable</B
> :: (Maybe Bool)</TD
><TD CLASS="rdoc"
>Whether NULL is acceptable
</TD
></TR
></TABLE
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="section4"
><IMG SRC="minus.gif" CLASS="coll" ONCLICK="toggle(this,'i:SqlColDesc')" ALT="show/hide"
> Instances</TD
></TR
><TR
><TD CLASS="body"
><DIV ID="i:SqlColDesc" STYLE="display:block;"
><TABLE CLASS="vanilla" CELLSPACING="1" CELLPADDING="0"
><TR
><TD CLASS="decl"
>Eq <A HREF="Database-HDBC-ColTypes.html#t%3ASqlColDesc"
>SqlColDesc</A
></TD
></TR
><TR
><TD CLASS="decl"
>Read <A HREF="Database-HDBC-ColTypes.html#t%3ASqlColDesc"
>SqlColDesc</A
></TD
></TR
><TR
><TD CLASS="decl"
>Show <A HREF="Database-HDBC-ColTypes.html#t%3ASqlColDesc"
>SqlColDesc</A
></TD
></TR
><TR
><TD CLASS="decl"
>Typeable <A HREF="Database-HDBC-ColTypes.html#t%3ASqlColDesc"
>SqlColDesc</A
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>data</SPAN
> <A NAME="t%3ASqlTypeId"
></A
><B
>SqlTypeId</B
> </TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="ndoc"
><P
>The type identifier for a given column.
</P
><P
>This represents the type of data stored in the column in the underlying
SQL engine. It does not form the entire column type; see <TT
><A HREF="Database-HDBC-ColTypes.html#t%3ASqlColDesc"
>SqlColDesc</A
></TT
> for
that.
</P
><P
>These types correspond mainly to those defined by ODBC.
</P
></TD
></TR
><TR
><TD CLASS="section4"
>Constructors</TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="1" CELLPADDING="0"
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlCharT"
></A
><B
>SqlCharT</B
></TD
><TD CLASS="rdoc"
>Fixed-width character strings
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlVarCharT"
></A
><B
>SqlVarCharT</B
></TD
><TD CLASS="rdoc"
>Variable-width character strings
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlLongVarCharT"
></A
><B
>SqlLongVarCharT</B
></TD
><TD CLASS="rdoc"
>Variable-width character strings, max length implementation dependant
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlWCharT"
></A
><B
>SqlWCharT</B
></TD
><TD CLASS="rdoc"
>Fixed-width Unicode strings
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlWVarCharT"
></A
><B
>SqlWVarCharT</B
></TD
><TD CLASS="rdoc"
>Variable-width Unicode strings
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlWLongVarCharT"
></A
><B
>SqlWLongVarCharT</B
></TD
><TD CLASS="rdoc"
>Variable-width Unicode strings, max length implementation dependant
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlDecimalT"
></A
><B
>SqlDecimalT</B
></TD
><TD CLASS="rdoc"
>Signed exact values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlNumericT"
></A
><B
>SqlNumericT</B
></TD
><TD CLASS="rdoc"
>Signed exact integer values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlSmallIntT"
></A
><B
>SqlSmallIntT</B
></TD
><TD CLASS="rdoc"
>16-bit integer values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntegerT"
></A
><B
>SqlIntegerT</B
></TD
><TD CLASS="rdoc"
>32-bit integer values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlRealT"
></A
><B
>SqlRealT</B
></TD
><TD CLASS="rdoc"
></TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlFloatT"
></A
><B
>SqlFloatT</B
></TD
><TD CLASS="rdoc"
>Signed inexact floating-point values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlDoubleT"
></A
><B
>SqlDoubleT</B
></TD
><TD CLASS="rdoc"
>Signed inexact double-precision values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlBitT"
></A
><B
>SqlBitT</B
></TD
><TD CLASS="rdoc"
>A single bit
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlTinyIntT"
></A
><B
>SqlTinyIntT</B
></TD
><TD CLASS="rdoc"
>8-bit integer values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlBigIntT"
></A
><B
>SqlBigIntT</B
></TD
><TD CLASS="rdoc"
>64-bit integer values
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlBinaryT"
></A
><B
>SqlBinaryT</B
></TD
><TD CLASS="rdoc"
>Fixed-length binary data
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlVarBinaryT"
></A
><B
>SqlVarBinaryT</B
></TD
><TD CLASS="rdoc"
>Variable-length binary data
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlLongVarBinaryT"
></A
><B
>SqlLongVarBinaryT</B
></TD
><TD CLASS="rdoc"
>Variable-length binary data, max length implementation dependant
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlDateT"
></A
><B
>SqlDateT</B
></TD
><TD CLASS="rdoc"
>A date
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlTimeT"
></A
><B
>SqlTimeT</B
></TD
><TD CLASS="rdoc"
>A time
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlTimestampT"
></A
><B
>SqlTimestampT</B
></TD
><TD CLASS="rdoc"
>Combined date and time
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlUTCDateTimeT"
></A
><B
>SqlUTCDateTimeT</B
></TD
><TD CLASS="rdoc"
>UTC date/time
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlUTCTimeT"
></A
><B
>SqlUTCTimeT</B
></TD
><TD CLASS="rdoc"
>UTC time
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalT"
></A
><B
>SqlIntervalT</B
> <A HREF="Database-HDBC-ColTypes.html#t%3ASqlInterval"
>SqlInterval</A
></TD
><TD CLASS="rdoc"
>A time or date difference
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlGUIDT"
></A
><B
>SqlGUIDT</B
></TD
><TD CLASS="rdoc"
>Global unique identifier
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlUnknownT"
></A
><B
>SqlUnknownT</B
> String</TD
><TD CLASS="rdoc"
>A type not represented here; implementation-specific information in the String
</TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="section4"
><IMG SRC="minus.gif" CLASS="coll" ONCLICK="toggle(this,'i:SqlTypeId')" ALT="show/hide"
> Instances</TD
></TR
><TR
><TD CLASS="body"
><DIV ID="i:SqlTypeId" STYLE="display:block;"
><TABLE CLASS="vanilla" CELLSPACING="1" CELLPADDING="0"
><TR
><TD CLASS="decl"
>Eq <A HREF="Database-HDBC-ColTypes.html#t%3ASqlTypeId"
>SqlTypeId</A
></TD
></TR
><TR
><TD CLASS="decl"
>Read <A HREF="Database-HDBC-ColTypes.html#t%3ASqlTypeId"
>SqlTypeId</A
></TD
></TR
><TR
><TD CLASS="decl"
>Show <A HREF="Database-HDBC-ColTypes.html#t%3ASqlTypeId"
>SqlTypeId</A
></TD
></TR
><TR
><TD CLASS="decl"
>Typeable <A HREF="Database-HDBC-ColTypes.html#t%3ASqlTypeId"
>SqlTypeId</A
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>data</SPAN
> <A NAME="t%3ASqlInterval"
></A
><B
>SqlInterval</B
> </TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="ndoc"
>The different types of intervals in SQL.
</TD
></TR
><TR
><TD CLASS="section4"
>Constructors</TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="1" CELLPADDING="0"
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalMonthT"
></A
><B
>SqlIntervalMonthT</B
></TD
><TD CLASS="rdoc"
>Difference in months
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalYearT"
></A
><B
>SqlIntervalYearT</B
></TD
><TD CLASS="rdoc"
>Difference in years
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalYearToMonthT"
></A
><B
>SqlIntervalYearToMonthT</B
></TD
><TD CLASS="rdoc"
>Difference in years+months
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalDayT"
></A
><B
>SqlIntervalDayT</B
></TD
><TD CLASS="rdoc"
>Difference in days
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalHourT"
></A
><B
>SqlIntervalHourT</B
></TD
><TD CLASS="rdoc"
>Difference in hours
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalMinuteT"
></A
><B
>SqlIntervalMinuteT</B
></TD
><TD CLASS="rdoc"
>Difference in minutes
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalSecondT"
></A
><B
>SqlIntervalSecondT</B
></TD
><TD CLASS="rdoc"
>Difference in seconds
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalDayToHourT"
></A
><B
>SqlIntervalDayToHourT</B
></TD
><TD CLASS="rdoc"
>Difference in days+hours
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalDayToMinuteT"
></A
><B
>SqlIntervalDayToMinuteT</B
></TD
><TD CLASS="rdoc"
>Difference in days+minutes
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalDayToSecondT"
></A
><B
>SqlIntervalDayToSecondT</B
></TD
><TD CLASS="rdoc"
>Difference in days+seconds
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalHourToMinuteT"
></A
><B
>SqlIntervalHourToMinuteT</B
></TD
><TD CLASS="rdoc"
>Difference in hours+minutes
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalHourToSecondT"
></A
><B
>SqlIntervalHourToSecondT</B
></TD
><TD CLASS="rdoc"
>Difference in hours+seconds
</TD
></TR
><TR
><TD CLASS="arg"
><A NAME="v%3ASqlIntervalMinuteToSecondT"
></A
><B
>SqlIntervalMinuteToSecondT</B
></TD
><TD CLASS="rdoc"
>Difference in minutes+seconds
</TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="section4"
><IMG SRC="minus.gif" CLASS="coll" ONCLICK="toggle(this,'i:SqlInterval')" ALT="show/hide"
> Instances</TD
></TR
><TR
><TD CLASS="body"
><DIV ID="i:SqlInterval" STYLE="display:block;"
><TABLE CLASS="vanilla" CELLSPACING="1" CELLPADDING="0"
><TR
><TD CLASS="decl"
>Eq <A HREF="Database-HDBC-ColTypes.html#t%3ASqlInterval"
>SqlInterval</A
></TD
></TR
><TR
><TD CLASS="decl"
>Read <A HREF="Database-HDBC-ColTypes.html#t%3ASqlInterval"
>SqlInterval</A
></TD
></TR
><TR
><TD CLASS="decl"
>Show <A HREF="Database-HDBC-ColTypes.html#t%3ASqlInterval"
>SqlInterval</A
></TD
></TR
><TR
><TD CLASS="decl"
>Typeable <A HREF="Database-HDBC-ColTypes.html#t%3ASqlInterval"
>SqlInterval</A
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="botbar"
>Produced by <A HREF="http://www.haskell.org/haddock/"
>Haddock</A
> version 0.7</TD
></TR
></TABLE
></BODY
></HTML
>