/usr/share/doc/haskell-haskelldb-doc/html/Database-HaskellDB-Sql.html is in libghc-haskelldb-doc 2.1.1-2.
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 | <!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.HaskellDB.Sql</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-HaskellDB-Sql.html");};
//]]>
</script></head><body><div id="package-header"><ul class="links" id="page-menu"><li><a href="src/Database-HaskellDB-Sql.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">haskelldb-2.1.1: A library of combinators for generating and executing SQL statements.</p></div><div id="content"><div id="module-header"><table class="info"><tr><th>Portability</th><td>non-portable</td></tr><tr><th>Stability</th><td>experimental</td></tr><tr><th>Maintainer</th><td>haskelldb-users@lists.sourceforge.net</td></tr><tr><th>Safe Haskell</th><td>None</td></tr></table><p class="caption">Database.HaskellDB.Sql</p></div><div id="description"><p class="caption">Description</p><div class="doc"><p>A data type for SQL.
</p></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">type</span> <a href="#t:SqlTable">SqlTable</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"><span class="keyword">type</span> <a href="#t:SqlColumn">SqlColumn</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"><span class="keyword">type</span> <a href="#t:SqlName">SqlName</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"><span class="keyword">data</span> <a href="#t:SqlOrder">SqlOrder</a> <ul class="subs"><li>= <a href="#v:SqlAsc">SqlAsc</a> </li><li>| <a href="#v:SqlDesc">SqlDesc</a> </li></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlType">SqlType</a> <ul class="subs"><li>= <a href="#v:SqlType">SqlType</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:SqlType1">SqlType1</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/Data-Int.html#t:Int">Int</a> </li><li>| <a href="#v:SqlType2">SqlType2</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/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></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlSelect">SqlSelect</a> <ul class="subs"><li>= <a href="#v:SqlSelect">SqlSelect</a> { <ul class="subs"><li><a href="#v:options">options</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:attrs">attrs</a> :: [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)]</li><li><a href="#v:tables">tables</a> :: [(<a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a>, <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a>)]</li><li><a href="#v:criteria">criteria</a> :: [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</li><li><a href="#v:groupby">groupby</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:Mark">Mark</a></li><li><a href="#v:orderby">orderby</a> :: [(<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>, <a href="Database-HaskellDB-Sql.html#t:SqlOrder">SqlOrder</a>)]</li><li><a href="#v:extra">extra</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:SqlBin">SqlBin</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-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> </li><li>| <a href="#v:SqlTable">SqlTable</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> </li><li>| <a href="#v:SqlEmpty">SqlEmpty</a> </li></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlUpdate">SqlUpdate</a> = <a href="#v:SqlUpdate">SqlUpdate</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)] [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlDelete">SqlDelete</a> = <a href="#v:SqlDelete">SqlDelete</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlInsert">SqlInsert</a> <ul class="subs"><li>= <a href="#v:SqlInsert">SqlInsert</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>] [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>] </li><li>| <a href="#v:SqlInsertQuery">SqlInsertQuery</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>] <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> </li></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlCreate">SqlCreate</a> <ul class="subs"><li>= <a href="#v:SqlCreateDB">SqlCreateDB</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:SqlCreateTable">SqlCreateTable</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, (<a href="Database-HaskellDB-Sql.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></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlDrop">SqlDrop</a> <ul class="subs"><li>= <a href="#v:SqlDropDB">SqlDropDB</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:SqlDropTable">SqlDropTable</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> </li></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:SqlExpr">SqlExpr</a> <ul class="subs"><li>= <a href="#v:ColumnSqlExpr">ColumnSqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a> </li><li>| <a href="#v:BinSqlExpr">BinSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> </li><li>| <a href="#v:PrefixSqlExpr">PrefixSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> </li><li>| <a href="#v:PostfixSqlExpr">PostfixSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> </li><li>| <a href="#v:FunSqlExpr">FunSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>] </li><li>| <a href="#v:AggrFunSqlExpr">AggrFunSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>] </li><li>| <a href="#v:ConstSqlExpr">ConstSqlExpr</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:CaseSqlExpr">CaseSqlExpr</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)] <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> </li><li>| <a href="#v:ListSqlExpr">ListSqlExpr</a> [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>] </li><li>| <a href="#v:ExistsSqlExpr">ExistsSqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> </li><li>| <a href="#v:ParamSqlExpr">ParamSqlExpr</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:SqlName">SqlName</a>) <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> </li><li>| <a href="#v:PlaceHolderSqlExpr">PlaceHolderSqlExpr</a> </li><li>| <a href="#v:ParensSqlExpr">ParensSqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> </li><li>| <a href="#v:CastSqlExpr">CastSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> </li></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:Mark">Mark</a> <ul class="subs"><li>= <a href="#v:All">All</a> </li><li>| <a href="#v:Columns">Columns</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)] </li></ul></li><li class="src short"><a href="#v:newSelect">newSelect</a> :: <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a></li><li class="src short"><a href="#v:foldSqlExpr">foldSqlExpr</a> :: (<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a> -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> [t] -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> [t] -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t, [(t, t)] -> t -> t, [t] -> t, <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:SqlName">SqlName</a> -> t -> t, t, t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t) -> <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> -> t</li><li class="src short"><a href="#v:foldSqlSelect">foldSqlSelect</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-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)] -> [(<a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a>, t)] -> [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>] -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:Mark">Mark</a> -> [(<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>, <a href="Database-HaskellDB-Sql.html#t:SqlOrder">SqlOrder</a>)] -> [<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>] -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t -> t, <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> -> t, t) -> <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> -> t</li></ul></div><div id="interface"><h1>Documentation</h1><div class="top"><p class="src"><span class="keyword">type</span> <a name="t:SqlTable" class="def">SqlTable</a> = <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a><a href="src/Database-HaskellDB-Sql.html#SqlTable" class="link">Source</a></p></div><div class="top"><p class="src"><span class="keyword">type</span> <a name="t:SqlColumn" class="def">SqlColumn</a> = <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a><a href="src/Database-HaskellDB-Sql.html#SqlColumn" class="link">Source</a></p></div><div class="top"><p class="src"><span class="keyword">type</span> <a name="t:SqlName" class="def">SqlName</a> = <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a><a href="src/Database-HaskellDB-Sql.html#SqlName" class="link">Source</a></p><div class="doc"><p>A valid SQL name for a parameter.
</p></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlOrder" class="def">SqlOrder</a> <a href="src/Database-HaskellDB-Sql.html#SqlOrder" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlAsc" class="def">SqlAsc</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlDesc" class="def">SqlDesc</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:SqlOrder" class="caption collapser" onclick="toggleSection('i:SqlOrder')">Instances</p><div id="section.i:SqlOrder" 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-HaskellDB-Sql.html#t:SqlOrder">SqlOrder</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/Database-HaskellDB-Sql.html#SqlType" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlType" class="def">SqlType</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 name="v:SqlType1" class="def">SqlType1</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/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlType2" class="def">SqlType2</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/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: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/Text-Show.html#t:Show">Show</a> <a href="Database-HaskellDB-Sql.html#t:SqlType">SqlType</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:SqlSelect" class="def">SqlSelect</a> <a href="src/Database-HaskellDB-Sql.html#SqlSelect" class="link">Source</a></p><div class="doc"><p>Data type for SQL SELECT statements.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlSelect" class="def">SqlSelect</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:options" class="def">options</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"><p>DISTINCT, ALL etc.
</p></dd><dt class="src"><a name="v:attrs" class="def">attrs</a> :: [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)]</dt><dd class="doc"><p>result
</p></dd><dt class="src"><a name="v:tables" class="def">tables</a> :: [(<a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a>, <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a>)]</dt><dd class="doc"><p>FROM
</p></dd><dt class="src"><a name="v:criteria" class="def">criteria</a> :: [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</dt><dd class="doc"><p>WHERE
</p></dd><dt class="src"><a name="v:groupby" class="def">groupby</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:Mark">Mark</a></dt><dd class="doc"><p>GROUP BY
</p></dd><dt class="src"><a name="v:orderby" class="def">orderby</a> :: [(<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>, <a href="Database-HaskellDB-Sql.html#t:SqlOrder">SqlOrder</a>)]</dt><dd class="doc"><p>ORDER BY
</p></dd><dt class="src"><a name="v:extra" class="def">extra</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"><p>TOP n, etc.
</p></dd></dl><div class="clear"></div></div></td></tr><tr><td class="src"><a name="v:SqlBin" class="def">SqlBin</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-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a></td><td class="doc"><p>Binary relational operator
</p></td></tr><tr><td class="src"><a name="v:SqlTable" class="def">SqlTable</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a></td><td class="doc"><p>Select a whole table.
</p></td></tr><tr><td class="src"><a name="v:SqlEmpty" class="def">SqlEmpty</a></td><td class="doc"><p>Empty select.
</p></td></tr></table></div><div class="subs instances"><p id="control.i:SqlSelect" class="caption collapser" onclick="toggleSection('i:SqlSelect')">Instances</p><div id="section.i:SqlSelect" 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-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</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:SqlUpdate" class="def">SqlUpdate</a> <a href="src/Database-HaskellDB-Sql.html#SqlUpdate" class="link">Source</a></p><div class="doc"><p>Data type for SQL UPDATE statements.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlUpdate" class="def">SqlUpdate</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)] [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</td><td class="doc empty"> </td></tr></table></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlDelete" class="def">SqlDelete</a> <a href="src/Database-HaskellDB-Sql.html#SqlDelete" class="link">Source</a></p><div class="doc"><p>Data type for SQL DELETE statements.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlDelete" class="def">SqlDelete</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</td><td class="doc empty"> </td></tr></table></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlInsert" class="def">SqlInsert</a> <a href="src/Database-HaskellDB-Sql.html#SqlInsert" class="link">Source</a></p><div class="doc"><p>Data type for SQL INSERT statements.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlInsert" class="def">SqlInsert</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>] [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:SqlInsertQuery" class="def">SqlInsertQuery</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>] <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a></td><td class="doc empty"> </td></tr></table></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlCreate" class="def">SqlCreate</a> <a href="src/Database-HaskellDB-Sql.html#SqlCreate" class="link">Source</a></p><div class="doc"><p>Data type for SQL CREATE statements.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlCreateDB" class="def">SqlCreateDB</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>Create a database
</p></td></tr><tr><td class="src"><a name="v:SqlCreateTable" class="def">SqlCreateTable</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, (<a href="Database-HaskellDB-Sql.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>))]</td><td class="doc"><p>Create a table.
</p></td></tr></table></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlDrop" class="def">SqlDrop</a> <a href="src/Database-HaskellDB-Sql.html#SqlDrop" class="link">Source</a></p><div class="doc"><p>Data type representing the SQL DROP statement.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:SqlDropDB" class="def">SqlDropDB</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>Delete a database
</p></td></tr><tr><td class="src"><a name="v:SqlDropTable" class="def">SqlDropTable</a> <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a></td><td class="doc"><p>Delete a table named SqlTable
</p></td></tr></table></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:SqlExpr" class="def">SqlExpr</a> <a href="src/Database-HaskellDB-Sql.html#SqlExpr" class="link">Source</a></p><div class="doc"><p>Expressions in SQL statements.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:ColumnSqlExpr" class="def">ColumnSqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:BinSqlExpr" class="def">BinSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:PrefixSqlExpr" class="def">PrefixSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:PostfixSqlExpr" class="def">PostfixSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:FunSqlExpr" class="def">FunSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:AggrFunSqlExpr" class="def">AggrFunSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</td><td class="doc"><p>Aggregate functions separate from normal functions.
</p></td></tr><tr><td class="src"><a name="v:ConstSqlExpr" class="def">ConstSqlExpr</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 name="v:CaseSqlExpr" class="def">CaseSqlExpr</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)] <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:ListSqlExpr" class="def">ListSqlExpr</a> [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>]</td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:ExistsSqlExpr" class="def">ExistsSqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:ParamSqlExpr" class="def">ParamSqlExpr</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:SqlName">SqlName</a>) <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:PlaceHolderSqlExpr" class="def">PlaceHolderSqlExpr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:ParensSqlExpr" class="def">ParensSqlExpr</a> <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:CastSqlExpr" class="def">CastSqlExpr</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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a></td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:SqlExpr" class="caption collapser" onclick="toggleSection('i:SqlExpr')">Instances</p><div id="section.i:SqlExpr" 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-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</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:Mark" class="def">Mark</a> <a href="src/Database-HaskellDB-Sql.html#Mark" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:All" class="def">All</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a name="v:Columns" class="def">Columns</a> [(<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)]</td><td class="doc empty"> </td></tr></table></div><div class="subs instances"><p id="control.i:Mark" class="caption collapser" onclick="toggleSection('i:Mark')">Instances</p><div id="section.i:Mark" 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-HaskellDB-Sql.html#t:Mark">Mark</a></td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><a name="v:newSelect" class="def">newSelect</a> :: <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a><a href="src/Database-HaskellDB-Sql.html#newSelect" class="link">Source</a></p></div><div class="top"><p class="src"><a name="v:foldSqlExpr" class="def">foldSqlExpr</a> :: (<a href="Database-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a> -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> [t] -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> [t] -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t, [(t, t)] -> t -> t, [t] -> t, <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:SqlName">SqlName</a> -> t -> t, t, t -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t) -> <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a> -> t<a href="src/Database-HaskellDB-Sql.html#foldSqlExpr" class="link">Source</a></p><div class="doc"><p>Transform a SqlExpr value.
</p></div></div><div class="top"><p class="src"><a name="v:foldSqlSelect" class="def">foldSqlSelect</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-HaskellDB-Sql.html#t:SqlColumn">SqlColumn</a>, <a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>)] -> [(<a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a>, t)] -> [<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>] -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-Sql.html#t:Mark">Mark</a> -> [(<a href="Database-HaskellDB-Sql.html#t:SqlExpr">SqlExpr</a>, <a href="Database-HaskellDB-Sql.html#t:SqlOrder">SqlOrder</a>)] -> [<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>] -> t, <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> t -> t -> t, <a href="Database-HaskellDB-Sql.html#t:SqlTable">SqlTable</a> -> t, t) -> <a href="Database-HaskellDB-Sql.html#t:SqlSelect">SqlSelect</a> -> t<a href="src/Database-HaskellDB-Sql.html#foldSqlSelect" class="link">Source</a></p><div class="doc"><p>Transform a SqlSelect value.
</p></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>
|