/usr/share/doc/haskell-hsql-doc/html/Database-HSQL.html is in libghc-hsql-doc 1.8.1-3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Database.HSQL</title><link href="ocean.css" rel="stylesheet" type="text/css" title="Ocean" /><script src="haddock-util.js" type="text/javascript"></script><script type="text/javascript">//<![CDATA[
window.onload = function () {pageLoad();setSynopsis("mini_Database-HSQL.html");};
//]]>
</script></head><body><div id="package-header"><ul class="links" id="page-menu"><li><a href="src/Database-HSQL.html">Source</a></li><li><a href="index.html">Contents</a></li><li><a href="doc-index.html">Index</a></li></ul><p class="caption">hsql-1.8.1: Simple library for database access from Haskell.</p></div><div id="content"><div id="module-header"><table class="info"><tr><th>Safe Haskell</th><td>Safe-Infered</td></tr></table><p class="caption">Database.HSQL</p></div><div id="table-of-contents"><p class="caption">Contents</p><ul><li><a href="#g:1">Connect/Disconnect
</a></li><li><a href="#g:2">Command Execution Functions
</a></li><li><a href="#g:3">Retrieving Statement values and types
</a></li><li><a href="#g:4">Transactions
</a></li><li><a href="#g:5">Utilities
</a></li><li><a href="#g:6">SQL Exceptions handling
</a></li><li><a href="#g:7">Metadata
</a></li><li><a href="#g:8">Extra types
</a></li></ul></div><div id="description"><p class="caption">Description</p><div class="doc empty"> </div></div><div id="synopsis"><p id="control.syn" class="caption expander" onclick="toggleSection('syn')">Synopsis</p><ul id="section.syn" class="hide" onclick="toggleSection('syn')"><li class="src short"><span class="keyword">data</span> <a href="#t:Connection">Connection</a> </li><li class="src short"><a href="#v:disconnect">disconnect</a> :: <a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:execute">execute</a> :: <a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><span class="keyword">data</span> <a href="#t:Statement">Statement</a> </li><li class="src short"><a href="#v:query">query</a> :: <a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="Database-HSQL.html#t:Statement">Statement</a></li><li class="src short"><a href="#v:closeStatement">closeStatement</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:fetch">fetch</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a></li><li class="src short"><span class="keyword">type</span> <a href="#t:FieldDef">FieldDef</a> = (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>, <a href="Database-HSQL.html#t:SqlType">SqlType</a>, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)</li><li class="src short"><span class="keyword">class</span> <a href="#t:SqlBind">SqlBind</a> a <span class="keyword">where</span><ul class="subs"><li><a href="#v:fromSqlCStringLen">fromSqlCStringLen</a> :: <a href="Database-HSQL.html#t:FieldDef">FieldDef</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Foreign-C-String.html#t:CString">CString</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li></ul></li><li class="src short"><a href="#v:getFieldValue">getFieldValue</a> :: <a href="Database-HSQL.html#t:SqlBind">SqlBind</a> a => <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li><li class="src short"><a href="#v:getFieldValueMB">getFieldValueMB</a> :: <a href="Database-HSQL.html#t:SqlBind">SqlBind</a> a => <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> a)</li><li class="src short"><a href="#v:getFieldValue-39-">getFieldValue'</a> :: <a href="Database-HSQL.html#t:SqlBind">SqlBind</a> a => <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> a -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li><li class="src short"><a href="#v:getFieldValueType">getFieldValueType</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> (<a href="Database-HSQL.html#t:SqlType">SqlType</a>, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)</li><li class="src short"><a href="#v:getFieldsTypes">getFieldsTypes</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> [(<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>, <a href="Database-HSQL.html#t:SqlType">SqlType</a>, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)]</li><li class="src short"><a href="#v:inTransaction">inTransaction</a> :: <a href="Database-HSQL.html#t:Connection">Connection</a> -> (<a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li><li class="src short"><a href="#v:forEachRow">forEachRow</a> :: (<a href="Database-HSQL.html#t:Statement">Statement</a> -> s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> s) -> <a href="Database-HSQL.html#t:Statement">Statement</a> -> s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> s</li><li class="src short"><a href="#v:forEachRow-39-">forEachRow'</a> :: (<a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a>) -> <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:collectRows">collectRows</a> :: (<a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a) -> <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [a]</li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlError">SqlError</a> <ul class="subs"><li>= <a href="#v:SqlError">SqlError</a> { <ul class="subs"><li><a href="#v:seState">seState</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></li><li><a href="#v:seNativeError">seNativeError</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></li><li><a href="#v:seErrorMsg">seErrorMsg</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></li></ul> }</li><li>| <a href="#v:SqlNoData">SqlNoData</a> </li><li>| <a href="#v:SqlInvalidHandle">SqlInvalidHandle</a> </li><li>| <a href="#v:SqlStillExecuting">SqlStillExecuting</a> </li><li>| <a href="#v:SqlNeedData">SqlNeedData</a> </li><li>| <a href="#v:SqlBadTypeCast">SqlBadTypeCast</a> { <ul class="subs"><li><a href="#v:seFieldName">seFieldName</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></li><li><a href="#v:seFieldType">seFieldType</a> :: <a href="Database-HSQL.html#t:SqlType">SqlType</a></li></ul> }</li><li>| <a href="#v:SqlFetchNull">SqlFetchNull</a> { <ul class="subs"><li><a href="#v:seFieldName">seFieldName</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></li></ul> }</li><li>| <a href="#v:SqlUnknownField">SqlUnknownField</a> { <ul class="subs"><li><a href="#v:seFieldName">seFieldName</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></li></ul> }</li><li>| <a href="#v:SqlUnsupportedOperation">SqlUnsupportedOperation</a> </li><li>| <a href="#v:SqlClosedHandle">SqlClosedHandle</a> </li></ul></li><li class="src short"><a href="#v:catchSql">catchSql</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a -> (<a href="Database-HSQL.html#t:SqlError">SqlError</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li><li class="src short"><a href="#v:handleSql">handleSql</a> :: (<a href="Database-HSQL.html#t:SqlError">SqlError</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li><li class="src short"><a href="#v:sqlExceptions">sqlExceptions</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Control-Exception-Base.html#t:Exception">Exception</a> x => x -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HSQL.html#t:SqlError">SqlError</a></li><li class="src short"><a href="#v:tables">tables</a> :: <a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>]</li><li class="src short"><a href="#v:describe">describe</a> :: <a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HSQL.html#t:FieldDef">FieldDef</a>]</li><li class="src short"><span class="keyword">data</span> <a href="#t:Point">Point</a> = <a href="#v:Point">Point</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></li><li class="src short"><span class="keyword">data</span> <a href="#t:Line">Line</a> = <a href="#v:Line">Line</a> <a href="Database-HSQL.html#t:Point">Point</a> <a href="Database-HSQL.html#t:Point">Point</a></li><li class="src short"><span class="keyword">data</span> <a href="#t:Path">Path</a> <ul class="subs"><li>= <a href="#v:OpenPath">OpenPath</a> [<a href="Database-HSQL.html#t:Point">Point</a>] </li><li>| <a href="#v:ClosedPath">ClosedPath</a> [<a href="Database-HSQL.html#t:Point">Point</a>] </li></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:Box">Box</a> = <a href="#v:Box">Box</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></li><li class="src short"><span class="keyword">data</span> <a href="#t:Circle">Circle</a> = <a href="#v:Circle">Circle</a> <a href="Database-HSQL.html#t:Point">Point</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></li><li class="src short"><span class="keyword">data</span> <a href="#t:Polygon">Polygon</a> = <a href="#v:Polygon">Polygon</a> [<a href="Database-HSQL.html#t:Point">Point</a>]</li><li class="src short"><span class="keyword">data</span> <a href="#t:INetAddr">INetAddr</a> = <a href="#v:INetAddr">INetAddr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></li><li class="src short"><span class="keyword">data</span> <a href="#t:MacAddr">MacAddr</a> = <a href="#v:MacAddr">MacAddr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlType">SqlType</a> <ul class="subs"><li>= <a href="#v:SqlInteger">SqlInteger</a> </li><li>| <a href="#v:SqlBigInt">SqlBigInt</a> </li><li>| <a href="#v:SqlSmallInt">SqlSmallInt</a> </li><li>| <a href="#v:SqlTinyInt">SqlTinyInt</a> </li><li>| <a href="#v:SqlMedInt">SqlMedInt</a> </li><li>| <a href="#v:SqlDecimal">SqlDecimal</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlNumeric">SqlNumeric</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlReal">SqlReal</a> </li><li>| <a href="#v:SqlDouble">SqlDouble</a> </li><li>| <a href="#v:SqlFloat">SqlFloat</a> </li><li>| <a href="#v:SqlMoney">SqlMoney</a> </li><li>| <a href="#v:SqlChar">SqlChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlVarChar">SqlVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlLongVarChar">SqlLongVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlText">SqlText</a> </li><li>| <a href="#v:SqlWChar">SqlWChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlWVarChar">SqlWVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlWLongVarChar">SqlWLongVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlDate">SqlDate</a> </li><li>| <a href="#v:SqlTime">SqlTime</a> </li><li>| <a href="#v:SqlTimeTZ">SqlTimeTZ</a> </li><li>| <a href="#v:SqlAbsTime">SqlAbsTime</a> </li><li>| <a href="#v:SqlRelTime">SqlRelTime</a> </li><li>| <a href="#v:SqlTimeInterval">SqlTimeInterval</a> </li><li>| <a href="#v:SqlAbsTimeInterval">SqlAbsTimeInterval</a> </li><li>| <a href="#v:SqlTimeStamp">SqlTimeStamp</a> </li><li>| <a href="#v:SqlDateTime">SqlDateTime</a> </li><li>| <a href="#v:SqlDateTimeTZ">SqlDateTimeTZ</a> </li><li>| <a href="#v:SqlYear">SqlYear</a> </li><li>| <a href="#v:SqlBit">SqlBit</a> </li><li>| <a href="#v:SqlENUM">SqlENUM</a> </li><li>| <a href="#v:SqlPoint">SqlPoint</a> </li><li>| <a href="#v:SqlLSeg">SqlLSeg</a> </li><li>| <a href="#v:SqlPath">SqlPath</a> </li><li>| <a href="#v:SqlBox">SqlBox</a> </li><li>| <a href="#v:SqlPolygon">SqlPolygon</a> </li><li>| <a href="#v:SqlLine">SqlLine</a> </li><li>| <a href="#v:SqlCircle">SqlCircle</a> </li><li>| <a href="#v:SqlINetAddr">SqlINetAddr</a> </li><li>| <a href="#v:SqlCIDRAddr">SqlCIDRAddr</a> </li><li>| <a href="#v:SqlMacAddr">SqlMacAddr</a> </li><li>| <a href="#v:SqlBinary">SqlBinary</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlVarBinary">SqlVarBinary</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlLongVarBinary">SqlLongVarBinary</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlSET">SqlSET</a> </li><li>| <a href="#v:SqlBLOB">SqlBLOB</a> </li><li>| <a href="#v:SqlUnknown">SqlUnknown</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> </li></ul></li></ul></div><div id="interface"><h1 id="g:1">Connect/Disconnect
</h1><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Connection" class="def">Connection</a> <a href="src/Database-HSQL-Types.html#Connection" class="link">Source</a></p><div class="doc"><p>A <code><a href="Database-HSQL.html#t:Connection">Connection</a></code> type represents a connection to a database,
through which you can operate on the it.
In order to create the connection you need to use the <code>connect</code> function
from the module for your prefered backend.
</p></div></div><div class="top"><p class="src"><a name="v:disconnect" class="def">disconnect</a> :: <a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a><a href="src/Database-HSQL.html#disconnect" class="link">Source</a></p><div class="doc"><p>Closes the connection. Performing <code><a href="Database-HSQL.html#v:disconnect">disconnect</a></code> on a connection that has
already been closed has no effect.
All other operations on a closed connection will fail.
</p></div></div><h1 id="g:2">Command Execution Functions
</h1><div class="doc"><p>Once a connection to a database has been successfully established,
the functions described here are used to perform
SQL queries and commands.
</p></div><div class="top"><p class="src"><a name="v:execute" class="def">execute</a><a href="src/Database-HSQL.html#execute" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HSQL.html#t:Connection">Connection</a></td><td class="doc"><p>the database connection
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc"><p>the text of SQL command
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div><div class="doc"><p>Submits a command to the database.
</p></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Statement" class="def">Statement</a> <a href="src/Database-HSQL-Types.html#Statement" class="link">Source</a></p><div class="doc"><p>The <code><a href="Database-HSQL.html#t:Statement">Statement</a></code> type represents a result from the execution of given
SQL query.
</p></div></div><div class="top"><p class="src"><a name="v:query" class="def">query</a><a href="src/Database-HSQL.html#query" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HSQL.html#t:Connection">Connection</a></td><td class="doc"><p>the database connection
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc"><p>the text of SQL query
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="Database-HSQL.html#t:Statement">Statement</a></td><td class="doc"><p>the associated statement. Must be closed with
the <code><a href="Database-HSQL.html#v:closeStatement">closeStatement</a></code> function
</p></td></tr></table></div><div class="doc"><p>Executes a query and returns a result set
</p></div></div><div class="top"><p class="src"><a name="v:closeStatement" class="def">closeStatement</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a><a href="src/Database-HSQL.html#closeStatement" class="link">Source</a></p><div class="doc"><p><code><a href="Database-HSQL.html#v:closeStatement">closeStatement</a></code> stops processing associated with a specific statement,
closes any open cursors associated with the statement, discards pending
results, and frees all resources associated with the statement.
Performing <code><a href="Database-HSQL.html#v:closeStatement">closeStatement</a></code> on a statement that has already been closed
has no effect. All other operations on a closed statement will fail.
</p></div></div><div class="top"><p class="src"><a name="v:fetch" class="def">fetch</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a><a href="src/Database-HSQL.html#fetch" class="link">Source</a></p><div class="doc"><p><code><a href="Database-HSQL.html#v:fetch">fetch</a></code> fetches the next rowset of data from the result set.
The values from columns can be retrieved with <code><a href="Database-HSQL.html#v:getFieldValue">getFieldValue</a></code> function.
</p></div></div><h1 id="g:3">Retrieving Statement values and types
</h1><div class="top"><p class="src"><span class="keyword">type</span> <a name="t:FieldDef" class="def">FieldDef</a> = (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>, <a href="Database-HSQL.html#t:SqlType">SqlType</a>, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)<a href="src/Database-HSQL-Types.html#FieldDef" class="link">Source</a></p></div><div class="top"><p class="src"><span class="keyword">class</span> <a name="t:SqlBind" class="def">SqlBind</a> a <span class="keyword">where</span><a href="src/Database-HSQL-Types.html#SqlBind" class="link">Source</a></p><div class="subs methods"><p class="caption">Methods</p><p class="src"><a name="v:fromSqlCStringLen" class="def">fromSqlCStringLen</a> :: <a href="Database-HSQL.html#t:FieldDef">FieldDef</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Foreign-C-String.html#t:CString">CString</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a<a href="src/Database-HSQL-Types.html#fromSqlCStringLen" class="link">Source</a></p><div class="doc"><p>This allows for faster conversion for eq. integral numeric types,
etc. Default version uses fromSqlValue.
</p></div></div><div class="subs instances"><p id="control.i:SqlBind" class="caption collapser" onclick="toggleSection('i:SqlBind')">Instances</p><div id="section.i:SqlBind" class="show"><table><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Float">Float</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int64">Int64</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Integer">Integer</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="/usr/share/doc/ghc-doc/html/libraries/old-time-1.1.0.0/System-Time.html#t:ClockTime">ClockTime</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Circle">Circle</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Polygon">Polygon</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Box">Box</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Path">Path</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Line">Line</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Point">Point</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:MacAddr">MacAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:INetAddr">INetAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> a => <a href="Database-HSQL.html#t:SqlBind">SqlBind</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> a)</td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><a name="v:getFieldValue" class="def">getFieldValue</a><a href="src/Database-HSQL.html#getFieldValue" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HSQL.html#t:SqlBind">SqlBind</a> a</td><td class="doc empty"> </td></tr><tr><td class="src">=> <a href="Database-HSQL.html#t:Statement">Statement</a></td><td class="doc"><p>result table data
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc"><p>field name
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</td><td class="doc"><p>field value
</p></td></tr></table></div><div class="doc"><p>Retrieves the value of field with the specified name.
</p></div></div><div class="top"><p class="src"><a name="v:getFieldValueMB" class="def">getFieldValueMB</a> :: <a href="Database-HSQL.html#t:SqlBind">SqlBind</a> a => <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> a)<a href="src/Database-HSQL.html#getFieldValueMB" class="link">Source</a></p></div><div class="top"><p class="src"><a name="v:getFieldValue-39-" class="def">getFieldValue'</a><a href="src/Database-HSQL.html#getFieldValue%27" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HSQL.html#t:SqlBind">SqlBind</a> a</td><td class="doc empty"> </td></tr><tr><td class="src">=> <a href="Database-HSQL.html#t:Statement">Statement</a></td><td class="doc empty"> </td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc"><p>Field name
</p></td></tr><tr><td class="src">-> a</td><td class="doc"><p>Default field value
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</td><td class="doc"><p>Field value
</p></td></tr></table></div><div class="doc"><p>Retrieves the value of field with the specified name.
If the field value is <code>null</code> then the function will return the default value.
</p></div></div><div class="top"><p class="src"><a name="v:getFieldValueType" class="def">getFieldValueType</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> (<a href="Database-HSQL.html#t:SqlType">SqlType</a>, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)<a href="src/Database-HSQL.html#getFieldValueType" class="link">Source</a></p><div class="doc"><p>Returns the type and the <code>nullable</code> flag for field with specified name
</p></div></div><div class="top"><p class="src"><a name="v:getFieldsTypes" class="def">getFieldsTypes</a> :: <a href="Database-HSQL.html#t:Statement">Statement</a> -> [(<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>, <a href="Database-HSQL.html#t:SqlType">SqlType</a>, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)]<a href="src/Database-HSQL.html#getFieldsTypes" class="link">Source</a></p><div class="doc"><p>Returns the list of fields with their types and <code>nullable</code> flags
</p></div></div><h1 id="g:4">Transactions
</h1><div class="top"><p class="src"><a name="v:inTransaction" class="def">inTransaction</a><a href="src/Database-HSQL.html#inTransaction" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HSQL.html#t:Connection">Connection</a></td><td class="doc"><p>Database connection
</p></td></tr><tr><td class="src">-> (<a href="Database-HSQL.html#t:Connection">Connection</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a)</td><td class="doc"><p>an action
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</td><td class="doc"><p>the returned value is the result
returned from action
</p></td></tr></table></div><div class="doc"><p>The <code><a href="Database-HSQL.html#v:inTransaction">inTransaction</a></code> function executes the specified action in transaction
mode.
If the action completes successfully then the transaction will be commited.
If the action completes with an exception then the transaction will be
rolled back and the exception will be throw again.
A transaction is to catch ANY exception, so <code><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Control-Exception-Base.html#t:SomeException">SomeException</a></code> is adequate.
</p></div></div><h1 id="g:5">Utilities
</h1><div class="top"><p class="src"><a name="v:forEachRow" class="def">forEachRow</a><a href="src/Database-HSQL.html#forEachRow" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: (<a href="Database-HSQL.html#t:Statement">Statement</a> -> s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> s)</td><td class="doc"><p>an action
</p></td></tr><tr><td class="src">-> <a href="Database-HSQL.html#t:Statement">Statement</a></td><td class="doc"><p>the statement
</p></td></tr><tr><td class="src">-> s</td><td class="doc"><p>initial state
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> s</td><td class="doc"><p>final state
</p></td></tr></table></div><div class="doc"><p>The <code><a href="Database-HSQL.html#v:forEachRow">forEachRow</a></code> function iterates through the result set in <code><a href="Database-HSQL.html#t:Statement">Statement</a></code>
and executes the given action for each row in the set.
The function closes the <code><a href="Database-HSQL.html#t:Statement">Statement</a></code> after the last row processing or if
the given action raises an exception.
</p></div></div><div class="top"><p class="src"><a name="v:forEachRow-39-" class="def">forEachRow'</a> :: (<a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a>) -> <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a><a href="src/Database-HSQL.html#forEachRow%27" class="link">Source</a></p><div class="doc"><p>The 'forEachRow\'' function is analogous to <code><a href="Database-HSQL.html#v:forEachRow">forEachRow</a></code> but doesn't
provide state.
The function closes the <code><a href="Database-HSQL.html#t:Statement">Statement</a></code> after the last row processing or if the
given action raises an exception.
</p></div></div><div class="top"><p class="src"><a name="v:collectRows" class="def">collectRows</a> :: (<a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a) -> <a href="Database-HSQL.html#t:Statement">Statement</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [a]<a href="src/Database-HSQL.html#collectRows" class="link">Source</a></p><div class="doc"><p>The <code><a href="Database-HSQL.html#v:collectRows">collectRows</a></code> function iterates through the result set in <code><a href="Database-HSQL.html#t:Statement">Statement</a></code>
and executes the given action for each row in the set. The values returned
from action are collected and returned as list. The function closes the
<code><a href="Database-HSQL.html#t:Statement">Statement</a></code> after the last row processing or if the given action raises an
exception.
</p></div></div><h1 id="g:6">SQL Exceptions handling
</h1><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlError" class="def">SqlError</a> <a href="src/DB-HSQL-Error.html#SqlError" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlError" class="def">SqlError</a></td><td class="doc empty"> </td></tr><tr><td colspan="2"><div class="subs fields"><p class="caption">Fields</p><dl><dt class="src"><a name="v:seState" class="def">seState</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:seNativeError" class="def">seNativeError</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:seErrorMsg" class="def">seErrorMsg</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></dt><dd class="doc empty"> </dd></dl><div class="clear"></div></div></td></tr><tr><td class="src"><a name="v:SqlNoData" class="def">SqlNoData</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlInvalidHandle" class="def">SqlInvalidHandle</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlStillExecuting" class="def">SqlStillExecuting</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlNeedData" class="def">SqlNeedData</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlBadTypeCast" class="def">SqlBadTypeCast</a></td><td class="doc empty"> </td></tr><tr><td colspan="2"><div class="subs fields"><p class="caption">Fields</p><dl><dt class="src"><a name="v:seFieldName" class="def">seFieldName</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:seFieldType" class="def">seFieldType</a> :: <a href="Database-HSQL.html#t:SqlType">SqlType</a></dt><dd class="doc empty"> </dd></dl><div class="clear"></div></div></td></tr><tr><td class="src"><a name="v:SqlFetchNull" class="def">SqlFetchNull</a></td><td class="doc empty"> </td></tr><tr><td colspan="2"><div class="subs fields"><p class="caption">Fields</p><dl><dt class="src"><a name="v:seFieldName" class="def">seFieldName</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></dt><dd class="doc empty"> </dd></dl><div class="clear"></div></div></td></tr><tr><td class="src"><a name="v:SqlUnknownField" class="def">SqlUnknownField</a></td><td class="doc empty"> </td></tr><tr><td colspan="2"><div class="subs fields"><p class="caption">Fields</p><dl><dt class="src"><a name="v:seFieldName" class="def">seFieldName</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></dt><dd class="doc empty"> </dd></dl><div class="clear"></div></div></td></tr><tr><td class="src"><a name="v:SqlUnsupportedOperation" class="def">SqlUnsupportedOperation</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlClosedHandle" class="def">SqlClosedHandle</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:SqlError" class="caption collapser" onclick="toggleSection('i:SqlError')">Instances</p><div id="section.i:SqlError" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:SqlError">SqlError</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Typeable-Internal.html#t:Typeable">Typeable</a> <a href="Database-HSQL.html#t:SqlError">SqlError</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Control-Exception-Base.html#t:Exception">Exception</a> <a href="Database-HSQL.html#t:SqlError">SqlError</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><a name="v:catchSql" class="def">catchSql</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a -> (<a href="Database-HSQL.html#t:SqlError">SqlError</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a<a href="src/DB-HSQL-Core.html#catchSql" class="link">Source</a></p><div class="doc"><p>DEPRECATED: catchSql: Use Control.Exception.catch instead.
</p></div></div><div class="top"><p class="src"><a name="v:handleSql" class="def">handleSql</a> :: (<a href="Database-HSQL.html#t:SqlError">SqlError</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a<a href="src/DB-HSQL-Core.html#handleSql" class="link">Source</a></p><div class="doc"><p>DEPRECATED: handleSql: Use Control.Exception.handle instead.
</p></div></div><div class="top"><p class="src"><a name="v:sqlExceptions" class="def">sqlExceptions</a><a href="src/DB-HSQL-Core.html#sqlExceptions" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Control-Exception-Base.html#t:Exception">Exception</a> x</td><td class="doc empty"> </td></tr><tr><td class="src">=> x</td><td class="doc"><p>the exception thinc to cast to SQLError
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HSQL.html#t:SqlError">SqlError</a></td><td class="doc empty"> </td></tr></table></div><div class="doc"><p>Casts, if possible, an Exception to an SqlError:
</p></div></div><h1 id="g:7">Metadata
</h1><div class="top"><p class="src"><a name="v:tables" class="def">tables</a><a href="src/Database-HSQL.html#tables" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HSQL.html#t:Connection">Connection</a></td><td class="doc"><p>Database connection
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>]</td><td class="doc"><p>The names of all tables in the database.
</p></td></tr></table></div><div class="doc"><p>List all tables in the database.
</p></div></div><div class="top"><p class="src"><a name="v:describe" class="def">describe</a><a href="src/Database-HSQL.html#describe" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HSQL.html#t:Connection">Connection</a></td><td class="doc"><p>Database connection
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc"><p>Name of a database table
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HSQL.html#t:FieldDef">FieldDef</a>]</td><td class="doc"><p>The list of fields in the table
</p></td></tr></table></div><div class="doc"><p>List all columns in a table along with their types and <code>nullable</code> flags
</p></div></div><h1 id="g:8">Extra types
</h1><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Point" class="def">Point</a> <a href="src/DB-HSQL-Type-Geometric.html#Point" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:Point" class="def">Point</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:Point" class="caption collapser" onclick="toggleSection('i:Point')">Instances</p><div id="section.i:Point" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:Point">Point</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:Point">Point</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Point">Point</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Line" class="def">Line</a> <a href="src/DB-HSQL-Type-Geometric.html#Line" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:Line" class="def">Line</a> <a href="Database-HSQL.html#t:Point">Point</a> <a href="Database-HSQL.html#t:Point">Point</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:Line" class="caption collapser" onclick="toggleSection('i:Line')">Instances</p><div id="section.i:Line" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:Line">Line</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:Line">Line</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Line">Line</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Path" class="def">Path</a> <a href="src/DB-HSQL-Type-Geometric.html#Path" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:OpenPath" class="def">OpenPath</a> [<a href="Database-HSQL.html#t:Point">Point</a>]</td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:ClosedPath" class="def">ClosedPath</a> [<a href="Database-HSQL.html#t:Point">Point</a>]</td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:Path" class="caption collapser" onclick="toggleSection('i:Path')">Instances</p><div id="section.i:Path" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:Path">Path</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:Path">Path</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Path">Path</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Box" class="def">Box</a> <a href="src/DB-HSQL-Type-Geometric.html#Box" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:Box" class="def">Box</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:Box" class="caption collapser" onclick="toggleSection('i:Box')">Instances</p><div id="section.i:Box" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:Box">Box</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:Box">Box</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Box">Box</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Circle" class="def">Circle</a> <a href="src/DB-HSQL-Type-Geometric.html#Circle" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:Circle" class="def">Circle</a> <a href="Database-HSQL.html#t:Point">Point</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:Circle" class="caption collapser" onclick="toggleSection('i:Circle')">Instances</p><div id="section.i:Circle" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:Circle">Circle</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:Circle">Circle</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Circle">Circle</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Polygon" class="def">Polygon</a> <a href="src/DB-HSQL-Type-Geometric.html#Polygon" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:Polygon" class="def">Polygon</a> [<a href="Database-HSQL.html#t:Point">Point</a>]</td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:Polygon" class="caption collapser" onclick="toggleSection('i:Polygon')">Instances</p><div id="section.i:Polygon" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:Polygon">Polygon</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:Polygon">Polygon</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:Polygon">Polygon</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:INetAddr" class="def">INetAddr</a> <a href="src/DB-HSQL-Type-NetAddress.html#INetAddr" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:INetAddr" class="def">INetAddr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:INetAddr" class="caption collapser" onclick="toggleSection('i:INetAddr')">Instances</p><div id="section.i:INetAddr" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:INetAddr">INetAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:INetAddr">INetAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:INetAddr">INetAddr</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:MacAddr" class="def">MacAddr</a> <a href="src/DB-HSQL-Type-NetAddress.html#MacAddr" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:MacAddr" class="def">MacAddr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:MacAddr" class="caption collapser" onclick="toggleSection('i:MacAddr')">Instances</p><div id="section.i:MacAddr" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:MacAddr">MacAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:MacAddr">MacAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HSQL.html#t:SqlBind">SqlBind</a> <a href="Database-HSQL.html#t:MacAddr">MacAddr</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlType" class="def">SqlType</a> <a href="src/DB-HSQL-Type.html#SqlType" class="link">Source</a></p><div class="doc"><p>Differentiation of data types used in DBs.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlInteger" class="def">SqlInteger</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlBigInt" class="def">SqlBigInt</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlSmallInt" class="def">SqlSmallInt</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlTinyInt" class="def">SqlTinyInt</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlMedInt" class="def">SqlMedInt</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlDecimal" class="def">SqlDecimal</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlNumeric" class="def">SqlNumeric</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlReal" class="def">SqlReal</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlDouble" class="def">SqlDouble</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlFloat" class="def">SqlFloat</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlMoney" class="def">SqlMoney</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlChar" class="def">SqlChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlVarChar" class="def">SqlVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlLongVarChar" class="def">SqlLongVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlText" class="def">SqlText</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlWChar" class="def">SqlWChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlWVarChar" class="def">SqlWVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlWLongVarChar" class="def">SqlWLongVarChar</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlDate" class="def">SqlDate</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlTime" class="def">SqlTime</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlTimeTZ" class="def">SqlTimeTZ</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlAbsTime" class="def">SqlAbsTime</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlRelTime" class="def">SqlRelTime</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlTimeInterval" class="def">SqlTimeInterval</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlAbsTimeInterval" class="def">SqlAbsTimeInterval</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlTimeStamp" class="def">SqlTimeStamp</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlDateTime" class="def">SqlDateTime</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlDateTimeTZ" class="def">SqlDateTimeTZ</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlYear" class="def">SqlYear</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlBit" class="def">SqlBit</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlENUM" class="def">SqlENUM</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlPoint" class="def">SqlPoint</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlLSeg" class="def">SqlLSeg</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlPath" class="def">SqlPath</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlBox" class="def">SqlBox</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlPolygon" class="def">SqlPolygon</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlLine" class="def">SqlLine</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlCircle" class="def">SqlCircle</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlINetAddr" class="def">SqlINetAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlCIDRAddr" class="def">SqlCIDRAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlMacAddr" class="def">SqlMacAddr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlBinary" class="def">SqlBinary</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlVarBinary" class="def">SqlVarBinary</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlLongVarBinary" class="def">SqlLongVarBinary</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlSET" class="def">SqlSET</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlBLOB" class="def">SqlBLOB</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlUnknown" class="def">SqlUnknown</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc"><p>HSQL returns <code>SqlUnknown tp</code> for all
columns for which it cannot determine
the right type. The <code>tp</code> here is the
internal type code returned from the
backend library
</p></td></tr></table></div><div class="subs instances"><p id="control.i:SqlType" class="caption collapser" onclick="toggleSection('i:SqlType')">Instances</p><div id="section.i:SqlType" class="show"><table><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Eq.html#t:Eq">Eq</a> <a href="Database-HSQL.html#t:SqlType">SqlType</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Text-Show.html#t:Show">Show</a> <a href="Database-HSQL.html#t:SqlType">SqlType</a></td><td class="doc empty"> </td></tr></table></div></div></div></div></div><div id="footer"><p>Produced by <a href="http://www.haskell.org/haddock/">Haddock</a> version 2.10.0</p></div></body></html>
|