Îõ³h$ã '      !"#$%&None #$?ÎìÕ  pg-transact Perform a SELECTÿ or other SQL query that is expected to return results. All results are retrieved and converted before this function returns.èWhen processing large results, this function will consume a lot of client-side memory. Consider using fold instead.Exceptions that may be thrown: FormatError4: the query string could not be formatted correctly. QueryError>: the result contains no columns (i.e. you should be using  instead of  ). ResultError: result conversion failed.'ô: the postgresql backend returned an error, e.g. a syntax or type error, or an incorrect table or column name.  pg-transact A version of  * that does not perform query substitution. pg-transact Execute an INSERT, UPDATE=, or other SQL query that is not expected to return results.$Returns the number of rows affected.Throws  FormatError6 if the query could not be formatted correctly, or a '+ exception if the backend returns an error. pg-transact>A version of execute that does not perform query substitution. pg-transactExecute a multi-row INSERT, UPDATE=, or other SQL query that is not expected to return results.ÅReturns the number of rows affected. If the list of parameters is empty, this function will simply return 0 without issuing the query to the backend. If this is not desired, consider using the ( constructor instead.Throws  FormatError6 if the query could not be formatted correctly, or a '+ exception if the backend returns an error.ÔFor example, here's a command that inserts two rows into a table with two columns: ÙexecuteMany [sql| INSERT INTO sometable VALUES (?,?) |] [(1, "hello"),(2, "world")] :Here's an canonical example of a multi-row update command: «executeMany [sql| UPDATE sometable SET sometable.y = upd.y FROM (VALUES (?,?)) as upd(x,y) WHERE sometable.x = upd.x |] [(1, "hello"),(2, "world")]  pg-transactExecute INSERT ... RETURNING, UPDATE ... RETURNINGý, or other SQL query that accepts multi-row input and is expected to return results. Note that it is possible to write  $ conn "INSERT ... RETURNING ..." ...ã in cases where you are only inserting a single row, and do not need functionality analogous to .ÆIf the list of parameters is empty, this function will simply return []Ú without issuing the query to the backend. If this is not desired, consider using the ( constructor instead.Throws  FormatError/ if the query could not be formatted correctly. pg-transactFormat a query string.íThis function is exposed to help with debugging and logging. Do not use it to prepare queries for execution.ÌString parameters are escaped according to the character set in use on the ).Throws  FormatError7 if the query string could not be formatted correctly. pg-transact Create a *. pg-transact Release the * and discard the effects. pg-transact;Run an action and discard the effects but return the result pg-transactA  is a similar to  but calls ROLLBACK to abort the transaction. Ïs is global. It affects everything before and after it is called. Duplicate s do nothing. Calling  throws an Ó exception that is not caught by the transaction running functions. If you call / you need to also be prepared to handle the  exception.  +      !"#$%&'()'*+'(,'*-.*pg-transact-0.3.2.0-B43nvipshQkBEHslPOfm8SDatabase.PostgreSQL.TransactAbortDBDBTunDBT isClass25isNoTransaction getConnectionrunDBTrunDBTSerializablerunDBTNoTransactionqueryquery_executeexecute_ executeMany returning formatQueryqueryOne queryOne_ savepointrollbackToAndReleaseSavepointrollbackabort$fMonadMaskDBT$fMonadFailDBT $fMonadDBT $fMonadIODBT$fApplicativeDBT $fFunctorDBT $fMonoidDBT$fSemigroupDBT$fExceptionAbort$fMonadCatchDBT $fShowAbort $fEqAbort$fMonadTransDBT$fMonadThrowDBT.postgresql-simple-0.6.4-Kqp41a5oeih3CcydjjQY4p#Database.PostgreSQL.Simple.InternalSqlError Database.PostgreSQL.Simple.TypesValues Connection Savepoint