/usr/share/doc/haskell-haskelldb-doc/html/src/Database-HaskellDB-Sql-PostgreSQL.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 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 | <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<!-- Generated by HsColour, http://code.haskell.org/~malcolm/hscolour/ -->
<title>src/Database/HaskellDB/Sql/PostgreSQL.hs</title>
<link type='text/css' rel='stylesheet' href='hscolour.css' />
</head>
<body>
<pre><a name="line-1"></a><span class='hs-comment'>-----------------------------------------------------------</span>
<a name="line-2"></a><span class='hs-comment'>-- |</span>
<a name="line-3"></a><span class='hs-comment'>-- Module : Database.HaskellDB.Sql.PostgreSQL</span>
<a name="line-4"></a><span class='hs-comment'>-- Copyright : Bjorn Bringert 2006</span>
<a name="line-5"></a><span class='hs-comment'>-- License : BSD-style</span>
<a name="line-6"></a><span class='hs-comment'>-- </span>
<a name="line-7"></a><span class='hs-comment'>-- Maintainer : haskelldb-users@lists.sourceforge.net</span>
<a name="line-8"></a><span class='hs-comment'>-- Stability : experimental</span>
<a name="line-9"></a><span class='hs-comment'>-- Portability : non-portable</span>
<a name="line-10"></a><span class='hs-comment'>-- </span>
<a name="line-11"></a><span class='hs-comment'>-- SQL generation for PostgreSQL.</span>
<a name="line-12"></a><span class='hs-comment'>-- </span>
<a name="line-13"></a><span class='hs-comment'>-----------------------------------------------------------</span>
<a name="line-14"></a><span class='hs-keyword'>module</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>Sql</span><span class='hs-varop'>.</span><span class='hs-conid'>PostgreSQL</span> <span class='hs-layout'>(</span><span class='hs-varid'>generator</span><span class='hs-layout'>)</span> <span class='hs-keyword'>where</span>
<a name="line-15"></a>
<a name="line-16"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>Sql</span>
<a name="line-17"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>Sql</span><span class='hs-varop'>.</span><span class='hs-conid'>Default</span>
<a name="line-18"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>Sql</span><span class='hs-varop'>.</span><span class='hs-conid'>Generate</span>
<a name="line-19"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>FieldType</span>
<a name="line-20"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>PrimQuery</span>
<a name="line-21"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>System</span><span class='hs-varop'>.</span><span class='hs-conid'>Locale</span>
<a name="line-22"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>System</span><span class='hs-varop'>.</span><span class='hs-conid'>Time</span>
<a name="line-23"></a>
<a name="line-24"></a>
<a name="line-25"></a><a name="generator"></a><span class='hs-definition'>generator</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>SqlGenerator</span>
<a name="line-26"></a><span class='hs-definition'>generator</span> <span class='hs-keyglyph'>=</span> <span class='hs-layout'>(</span><span class='hs-varid'>mkSqlGenerator</span> <span class='hs-varid'>generator</span><span class='hs-layout'>)</span> <span class='hs-layout'>{</span> <span class='hs-varid'>sqlSpecial</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>postgresqlSpecial</span>
<a name="line-27"></a> <span class='hs-layout'>,</span> <span class='hs-varid'>sqlType</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>postgresqlType</span>
<a name="line-28"></a> <span class='hs-layout'>,</span> <span class='hs-varid'>sqlLiteral</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>postgresqlLiteral</span>
<a name="line-29"></a> <span class='hs-layout'>,</span> <span class='hs-varid'>sqlExpr</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>postgresqlExpr</span>
<a name="line-30"></a> <span class='hs-layout'>}</span>
<a name="line-31"></a>
<a name="line-32"></a><a name="postgresqlSpecial"></a><span class='hs-definition'>postgresqlSpecial</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>SpecialOp</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>SqlSelect</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>SqlSelect</span>
<a name="line-33"></a><span class='hs-definition'>postgresqlSpecial</span> <span class='hs-varid'>op</span> <span class='hs-varid'>q</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlSpecial</span> <span class='hs-varid'>generator</span> <span class='hs-varid'>op</span> <span class='hs-varid'>q</span>
<a name="line-34"></a>
<a name="line-35"></a><a name="postgresqlLiteral"></a><span class='hs-comment'>-- Postgres > 7.1 wants a timezone with calendar time.</span>
<a name="line-36"></a><span class='hs-definition'>postgresqlLiteral</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>Literal</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>String</span>
<a name="line-37"></a><span class='hs-definition'>postgresqlLiteral</span> <span class='hs-layout'>(</span><span class='hs-conid'>DateLit</span> <span class='hs-varid'>d</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlQuote</span> <span class='hs-varid'>generator</span> <span class='hs-layout'>(</span><span class='hs-varid'>formatCalendarTime</span> <span class='hs-varid'>defaultTimeLocale</span> <span class='hs-varid'>fmt</span> <span class='hs-varid'>d</span><span class='hs-layout'>)</span>
<a name="line-38"></a> <span class='hs-keyword'>where</span> <span class='hs-varid'>fmt</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>iso8601DateFormat</span> <span class='hs-layout'>(</span><span class='hs-conid'>Just</span> <span class='hs-str'>"%H:%M:%S %Z"</span><span class='hs-layout'>)</span>
<a name="line-39"></a><span class='hs-definition'>postgresqlLiteral</span> <span class='hs-varid'>l</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlLiteral</span> <span class='hs-varid'>generator</span> <span class='hs-varid'>l</span>
<a name="line-40"></a>
<a name="line-41"></a><a name="postgresqlType"></a><span class='hs-definition'>postgresqlType</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>FieldType</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>SqlType</span>
<a name="line-42"></a><span class='hs-definition'>postgresqlType</span> <span class='hs-conid'>BoolT</span> <span class='hs-keyglyph'>=</span> <span class='hs-conid'>SqlType</span> <span class='hs-str'>"boolean"</span>
<a name="line-43"></a><span class='hs-definition'>postgresqlType</span> <span class='hs-varid'>t</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlType</span> <span class='hs-varid'>generator</span> <span class='hs-varid'>t</span>
<a name="line-44"></a>
<a name="line-45"></a><a name="postgresqlExpr"></a><span class='hs-definition'>postgresqlExpr</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>PrimExpr</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>SqlExpr</span>
<a name="line-46"></a><span class='hs-definition'>postgresqlExpr</span> <span class='hs-layout'>(</span><span class='hs-conid'>BinExpr</span> <span class='hs-conid'>OpMod</span> <span class='hs-varid'>e1</span> <span class='hs-varid'>e2</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span>
<a name="line-47"></a> <span class='hs-keyword'>let</span> <span class='hs-varid'>e1S</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlExpr</span> <span class='hs-varid'>generator</span> <span class='hs-varid'>e1</span>
<a name="line-48"></a> <span class='hs-varid'>e2S</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlExpr</span> <span class='hs-varid'>generator</span> <span class='hs-varid'>e2</span>
<a name="line-49"></a> <span class='hs-keyword'>in</span> <span class='hs-conid'>BinSqlExpr</span> <span class='hs-str'>"%"</span> <span class='hs-varid'>e1S</span> <span class='hs-varid'>e2S</span>
<a name="line-50"></a><span class='hs-definition'>postgresqlExpr</span> <span class='hs-varid'>e</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlExpr</span> <span class='hs-varid'>generator</span> <span class='hs-varid'>e</span>
</pre></body>
</html>
|