l      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~                !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~             !!!!!""###########$$$$$%%%%%%%%&' Safe-Inferred$Data type for SQL DELETE statements.$Data type for SQL UPDATE statements.Expressions in SQL statements.3Aggregate functions separate from normal functions.!A valid SQL name for a parameter.       Safe-Inferred  !"#$%  !"#$% !"#%$  !"#$% Safe-Inferred&'(&'(&'(&'(&'( Safe-Inferred)*+,-./)*+,-./)*+,-./)*+,-./ Safe-Inferred^used for hacking in custom SQLcrepresents a default valuef#Cast an expression to a given type.E0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstE0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstEtsrqpeonmlkjihgf]dcba`_^F\[ZYXWVUTSRQPONMLKJIHG@EDCBA5?>=<;:987634021 021345 ?>=<;:9876@EDCBAF\[ZYXWVUTSRQPONMLKJIHG]dcba`_^e onmlkjihgfpqrst Safe-Inferreduvwxyz{|}~uvwxyz{|}~v~}|{zyxwu uv ~}|{zyxw Safe-Inferred Safe-InferredHM    Safe-InferreddTurn a string into a quoted string. Quote characters and any escaping are handled by this function.  Safe-InferredQuote a string and escape characters that need escaping FIXME: this is *very* backend dependent. We use Postgres "escape strings", i.e. strings prefixed with E, to ensure that escaping with backslash is valid.$Escape characters that need escapingName of the table to update.=Conditions which must all be true for a row to be updated.Update the data with this.Name of the tableWhat to insert.Name of the table;Criteria which must all be true for a row to be deleted.  Safe-Inferred888  Safe-Inferred  Safe-Inferred234             Safe-InferredThe  and  instances for  a; are too general. For example, they allow you to add two  /s. This will be fixed in a subsequent release.      Safe-Inferred36  !"#$%  %$#"! !"#$%None &'()*+,-./ &'()*+,-./ &'()*+,-./ &'()*+,-./ Safe-Inferred0A NULL of any type2,The Opaleye equivalent of the maybe function30The Opaleye equivalent of the fromMaybe function01234 0123401234 01234 Safe-Inferred246 56789:;<=5678 5678=<;:956789:;<= Safe-Inferred246 >?@ABCDEFGH>?@ABC @AB>?CHGFED >?@ABCDEFGH Safe-Inferred2346IJKLMNOPIJKLIJKLPONMIJKLMNOPNone2346QRSTUVWXYZ[\]^_`abQRSTUVWSTQRUVWba`_^]\[ZYXQRSTUVWXYZ[\]^_`ab Safe-InferredcAn cE represents an expression to order on and a sort direction. Multiple cs can be composed with '(0. If two rows are equal according to the first c , the second is used, and so on. cdefghijklmcdefghij efmcdlkghij cdefghijklm Safe-Inferred246nopqrstuvwxyz{|}~nopqrstupqnorstu~}|{zyxwvnopqrstuvwxyz{|}~ Safe-Inferred3  Safe-Inferred  Safe-Inferred3   Safe-InferrednRestrict query results to a particular condition. Corresponds to the guard method of the MonadPlus class.   Safe-Inferred3M) Safe-Inferred Safe-Inferred36 Safe-Inferred2346None3Use X to make an instance to allow you to run queries on your own datatypes. For example: cnewtype Foo = Foo Int instance Default QueryRunnerColumn Foo Foo where def = queryRunnerColumn (& :: Column Foo -> Column Int) Foo def QSQS None3    ! Safe-InferredOrder the rows of a  according to the Order. 6Specify an ascending ordering by the given expression.7Specify an descending ordering by the given expression.JLimit the results of the given query to the given maximum number of items.ZOffset the results of the given query by the given amount, skipping that many result rows.cc" Safe-Inferred3# Safe-InferredAn $ takes a collection of rows of type aC, groups them, and transforms each group into a single row of type b(. This corresponds to aggregators using GROUP BY in SQL.   $ Safe-Inferred2Group the aggregation by equality on the input to .Sum all rows in a group.-Count the number of non-null rows in a group.Average of a groupGiven a  producing rows of type a and an  accepting rows of type a3, apply the aggregator to the results of the query.% Safe-Inferred6& Safe-Inferred3**++,,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~l           l                                    D               !"#$%&'()*++,-./0123456789:;<=>?@ABBCDEFGHIJJKLMNOPQRSTTAUVWXYZZ[[\]^_`abcdefghijjklmnopqqrrstuvwxyz{|}~t             !!!!!""###########$$$$$%%%%%%%%& opaleye-0.2Opaleye.Internal.HaskellDB.Sql$Opaleye.Internal.HaskellDB.Sql.PrintOpaleye.Internal.HelpersOpaleye.Internal.Tag$Opaleye.Internal.HaskellDB.PrimQueryOpaleye.Internal.PrimQueryOpaleye.Internal.OptimizeOpaleye.Internal.PackMap'Opaleye.Internal.HaskellDB.Sql.Generate&Opaleye.Internal.HaskellDB.Sql.DefaultOpaleye.Internal.SqlOpaleye.Internal.Print Opaleye.Internal.HaskellDB.QueryOpaleye.Internal.ColumnOpaleye.Internal.BinaryOpaleye.PGTypesOpaleye.ColumnOpaleye.Internal.UnpackspecOpaleye.Internal.ValuesOpaleye.Internal.JoinOpaleye.Internal.RunQueryOpaleye.Internal.OrderOpaleye.Internal.TableMakerOpaleye.Internal.TableOpaleye.Internal.QueryArr Opaleye.TableOpaleye.Operators Opaleye.SqlOpaleye.Binary Opaleye.JoinOpaleye.RunQueryOpaleye.Manipulation Opaleye.OrderOpaleye.ValuesOpaleye.Internal.AggregateOpaleye.AggregateOpaleye.Internal.DistinctOpaleye.Distinct Data.MonoidmappendOpaleye.QueryArr SqlInsert SqlDelete SqlUpdateSqlExpr CastSqlExpr ParensSqlExprPlaceHolderSqlExpr ParamSqlExpr ListSqlExpr CaseSqlExpr ConstSqlExprAggrFunSqlExpr FunSqlExprPostfixSqlExpr PrefixSqlExpr BinSqlExpr ColumnSqlExprMarkColumnsSqlOrderSqlDescSqlAscSqlName SqlColumnSqlTableppWhere ppGroupBy ppOrderByppAsppUpdateppDeleteppInsert ppSqlExprcommaHcommaV.:.:..::Tag UnsafeTagstartnext unsafeUnTagtagWith appendShowOrderOpOpDescOpAsc OrderExprAggrOp AggrOtherAggrVarPAggrVar AggrStdDevP AggrStdDevAggrMaxAggrMinAggrAvgAggrSum AggrCountUnOp UnOpOtherOpLength OpIsNotNullOpIsNullOpNotBinOpOpAsgOpBitXorOpBitOrOpBitAndOpBitNotOpModOpDivOpMulOpMinusOpPlusOpCatOpOtherOpInOpLikeOpOrOpAndOpNotEqOpGtEqOpGtOpLtEqOpLtOpEqLiteralOtherLit DoubleLit IntegerLit StringLitBoolLit DefaultLitNullLitPrimExprCastExprFunExpr ParamExprListExprCaseExpr ConstExprAggrExprUnExprBinExprAttrExprAssocSchemeName Attribute TableName PrimQueryFold PrimQueryBinaryValuesJoinLimitOrder AggregateProduct BaseTableUnitJoinTypeLeftJoinUnionAllUnionExceptLimitOp LimitOffsetOpOffsetOpSymbol foldPrimQuerytimesrestrictisUnitoptimize removeUnit mergeProductPMPackMappackmapovernewwriterun extractAttr extractAttrPE$fProductProfunctorPackMap$fProfunctorPackMap$fApplicativePackMap$fFunctorPackMap SqlGenerator sqlUpdate sqlDelete sqlInsertsqlExpr sqlLiteralsqlQuoteUnOpType UnOpPostfix UnOpPrefixUnOpFunmkSqlGeneratordefaultSqlGenerator toSqlOrder toSqlAssocdefaultSqlUpdatedefaultSqlInsertdefaultSqlDeletedefaultSqlExpr showBinOpsqlUnOp showAggrOpdefaultSqlLiteraldefaultSqlQuotequoteescape ReturningStringbOpbSelect1bSelect2vAttrsvValues jJoinTypejAttrsjTablesjCondFromattrstablescriteriagroupByorderBylimitoffsetSelect SelectBinary SelectValues SelectJoinTable SelectFromsqlQueryGeneratorsqlunit baseTableproduct aggregateaggrExprorderlimit_joinvaluesbinaryjoinTypebinOp newSelectppSql ppSelectFrom ppSelectJoinppSelectValuesppSelectBinary ppJoinTypeppAttrsnameAsppTables tableAliasppTableppLimitppOffsetppValues ppValuesRowppBinOpppInsertReturning ShowConstant showConstant$fShowConstantMaybe$fShowConstantBool$fShowConstantDouble$fShowConstantInteger$fShowConstantInt$fShowConstant[]NullableColumnunColumn unsafeCoerceconstantunOpcase_ ifThenElse.>.==$fFractionalColumn $fNumColumn$fShowConstantInt64 BinaryspecextractBinaryFields runBinaryspec$fProductProfunctorBinaryspec$fProfunctorBinaryspec$fApplicativeBinaryspec$fFunctorBinaryspec$fDefaultBinaryspecColumnColumn literalColumnpgStringpgTextpgInt pgIntegerpgDoublepgBoolpgUUIDpgDay pgUTCTimenullisNull matchNullable fromNullable toNullable UnpackspecunpackspecColumn runUnpackspec$fProductProfunctorUnpackspec$fProfunctorUnpackspec$fApplicativeUnpackspec$fFunctorUnpackspec$fDefaultUnpackspecColumnColumn ValuesspecvaluesUextractValuesEntryextractValuesField runValuesspec$fProductProfunctorValuesspec$fProfunctorValuesspec$fApplicativeValuesspec$fFunctorValuesspec$fDefaultValuesspecColumnColumn NullMakerextractLeftJoinFields$fProductProfunctorNullMaker$fProfunctorNullMaker$fDefaultNullMakerColumnColumn$fDefaultNullMakerColumnColumn0 QueryRunnerQueryRunnerColumnfieldQueryRunnerColumn queryRunnerqueryRunnerColumnNullable$fProductProfunctorQueryRunner$fProfunctorQueryRunner$fApplicativeQueryRunner$fFunctorQueryRunner&$fDefaultQueryRunnerColumnDoubleDouble$fDefaultQueryRunnerColumn[][]($fDefaultQueryRunnerColumnIntegerInteger$$fDefaultQueryRunnerColumnInt64Int64 $fDefaultQueryRunnerColumnIntInt$fDefaultQueryRunnerColumnb'$fDefaultQueryRunnerColumnNullableMaybe SingleOrderorderByUlimit'offset' $fMonoidOrder$fContravariantOrder$fContravariantSingleOrder ColumnMakerViewColumnMakerrunViewColumnMakerrunColumnMaker tableColumncolumn$fProductProfunctorColumnMaker$fProfunctorColumnMaker$fApplicativeColumnMaker$fFunctorColumnMaker"$fProductProfunctorViewColumnMaker$fProfunctorViewColumnMaker$fApplicativeViewColumnMaker$fFunctorViewColumnMaker $fDefaultColumnMakerColumnColumn $fDefaultViewColumnMaker[]ColumnWriterViewTableProperties queryTable runWriterrequiredoptional$fFunctorTable"$fProductProfunctorTableProperties$fProfunctorTableProperties$fApplicativeTableProperties$fFunctorTableProperties$fProductProfunctorWriter$fProfunctorWriter$fApplicativeWriter$fFunctorWriterQueryQueryArrsimpleQueryArr runQueryArrrunSimpleQueryArrrunQueryArrUnpackfirst3$fProductProfunctorQueryArr$fProfunctorQueryArr$fApplicativeQueryArr$fFunctorQueryArr$fArrowQueryArr$fCategory*QueryArrqueryTableExplicit doubleOfInt.<.<=.>=.&&.||not.++./=showSqlForPostgresshowSqlForPostgresUnoptshowSqlForPostgresExplicitshowSqlForPostgresUnoptExplicitformatAndShowSQLunionAllunionAllExplicitleftJoinleftJoinExplicitrunQueryrunQueryExplicitqueryRunnerColumn arrangeInsertarrangeInsertSql runInsert arrangeUpdatearrangeUpdateSql runUpdate arrangeDeletearrangeDeleteSql runDeletearrangeInsertReturningarrangeInsertReturningSqlrunInsertReturningExplicitrunInsertReturningascdescvaluesExplicit Aggregator makeAggr'makeAggr runAggregator aggregateUextractAggregateFields$fProductProfunctorAggregator$fProfunctorAggregator$fApplicativeAggregator$fFunctorAggregatorsumcountavg DistinctspecdistinctExplicit$fProductProfunctorDistinctspec$fProfunctorDistinctspec$fApplicativeDistinctspec$fFunctorDistinctspec!$fDefaultDistinctspecColumnColumndistinctbaseGHC.NumNumGHC.Real FractionalGHC.Base