śĪ³vzž      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œ  Safe-Infered0Variety of common data types used in databases.  HSQL returns  for all ' columns for which it cannot determine  the right type. The backendTypeCode here is the & internal type code returned from the  backend library 3  !"#$%&'()*+,-./0123  !"#$%&'()*+,-./012>210/.+*)('&%$#"!  ,-,-,,,,,,,,,=210/.+*)('&%$#"!  ,-,-,,,,,,,,, Safe-Infered 4$referenced handle is already closed 5requested operation isn' t supported 6requested field isn't known 7requested field returns NULL 8requested field can'!t be converted to requested type ;0more data is needed, e.g. additional connection  specs <-connection is blocked by running transaction =requested handle is invalid >no more data was available ?4generic error condition, with further specification 3456789:;<=>?@ABžŸ3456789:;<=>?@AB3?>=<;87654@AB9:993?>=<;87654@AB9:99žŸ Safe-InferedC8Equivalent to Show and Read adapted to SQL expressions. Dshow as an SQL expression E5read from an SQL expression in text representation,  by support of its  F3read from SQL expression in binary representation,  by support of its ^ and code size info. D This allows for faster conversion for e.g. integral numeric types,  etc. GThe G6 type represents a result from the execution of given  SQL query. I'DB connection the statement depends on J close action K1incrementation of the row pointer and indication 2 whether this is still in range of available rows La O" function applicable for each row M/field descriptors for each result table column N&check whether the statement is closed O?An extraction of a field of type to be specified by requester,  from a row index with source ^, applying an appropriate  P. P8A DB generic field extraction function, specifiable by > field definition, receiving the content code and its length. QA Q- type represents a connection to a database, * through which you can operate on the it. 7 In order to create the connection you need to use the connect function , from the module for your prefered backend. Sdisconnect action T.query execution action (without return value) Uquery action with return value V.retrieval of the names of the tables in reach W'retrieval of the field defs of a table Xbegin of a transaction Y commit of a pending transaction Z"rollback of a pending transaction [ closing state of the connection \ A table ID. ]An SQL Query. ^1Description of the properties of a table column. _+Whether fields of a table col may be NULL. `A table column ID. CDEF"binary content of SQL expression size of binary content GHIJKLMNOfield (column) index source field type spec field reader to be applied field read action Pfield type spec field content code field content length field read action QRSTUVWXYZ[\]^_`a  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`n]\QRSTUVWXYZ[`_^POGHIJKLMNCDEF210/.+*)('&%$#"!  ,-,-,,,,,,,,,3?>=<;87654@AB9:99 CDEFGHIJKLMNOPQ RSTUVWXYZ[\]^_` Safe-Infered ”¢ ”¢ Safe-Infereda A 2D circle eA 2D polygon (without holes). hA 2D rectangle. n.A 2D path, either open, or closed (looping). oA looping path p An open path rA 2D straight line. v A 2D point. abcdefghijklmnopqrstuvwxy£¤„¦§Øabcdefghijklmnopqrstuvwxyvwxyrstunpoqqhijklmefgabcd abcdefghijklmnpoqqrstuvwxy£¤„¦§Ø  Safe-Infered©© Safe-InferedzA MAC network address. ‚.An IP4 address with netmask in CIDR notation. z{|}~€‚ƒ„…†‡ˆŖ«z{|}~€‚ƒ„…†‡ˆ‚ƒ„…†‡ˆz{|}~€z{|}~€‚ƒ„…†‡ˆŖ«  Safe-Infered¬­®Æ°¬­®Æ° Safe-Infered‰if closed, no action. Šif closed, throws 4 exception. ‹Casts, if possible, an ± to an 3. ŒDeprecated: Use ² instead. Deprecated: Use ³ instead. ‰closing state ref DB action to do if not closed Šclosing state ref DB action to do if not closed ‹the exception thinc to be cast Œ‰Š‹Œ‰Š‹Œ‰Š‹Œ Safe-InferedŽ"Closes the connection. Performing Ž on a connection that has $ already been closed has no effect. 8 All other operations on a closed connection will fail. #Submits a command to the database. *Executes a query and returns a result set ‘!List all tables in the database. ’7List all columns in a table along with their types and nullable flags “The “7 function executes the specified action in transaction  mode. M If the action completes successfully then the transaction will be commited. H If the action completes with an exception then the transaction will be 4 rolled back and the exception will be throw again. - A transaction is to catch ANY exception, so “ is adequate. ””6 fetches the next rowset of data from the result set. / The values from columns can be retrieved with ˜ function. ••8 stops processing associated with a specific statement, I closes any open cursors associated with the statement, discards pending A results, and frees all resources associated with the statement.  Performing •- on a statement that has already been closed F has no effect. All other operations on a closed statement will fail. –Returns the type and the nullable$ flag for field with specified name —0Returns the list of fields with their types and nullable flags ˜6Retrieves the value of field with the specified name. š6Retrieves the value of field with the specified name.  If the field value is null2 then the function will return the default value. ›The ›- function iterates through the result set in G 8 and executes the given action for each row in the set.  The function closes the G% after the last row processing or if ' the given action raises an exception. œThe 'forEachRow\'' function is analogous to › but doesn't  provide state.  The function closes the G) after the last row processing or if the # given action raises an exception. The - function iterates through the result set in G L and executes the given action for each row in the set. The values returned I from action are collected and returned as list. The function closes the  G@ after the last row processing or if the given action raises an  exception. Žthe database connection the text of SQL command the database connection the text of SQL query /the associated statement. Must be closed with  the • function ‘Database connection )The names of all tables in the database. ’Database connection Name of a database table  The list of fields in the table “Database connection  an action !the returned value is the result  returned from action ”•–—˜result table data  field name  field value ™š Field name Default field value  Field value › an action the statement initial state  final state œ„  !"#$%&'()*+,-./0123456789:;<=>?@ABCFGQ]^abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…†‡ˆ‹ŒŽ‘’“”•–—˜™š›œ’QŽ‘^’]G•”CF˜™š–—“›œ3?>=<;87654@AB9:99Œ‹vwxyrstunpoqqhijklmabcdefg‚ƒ„…†‡ˆz{|}~€210/.+*)('&%$#"!  ,-,-,,,,,,,,,Ž‘’“”•–—˜™š›œµ    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHI>JKLMNOPQQRSTUVWXYZZ[\]^_`abcdefghiijkllmnnopqrstuvwwxyzz{|}}~€‚ƒ„„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ”¢£¤„¦§Ø© Ŗ«¬ ­ ® Æ ° ±²³“²µ¶²µ·²³ø¹ hsql-1.8.2 DB.HSQL.Type DB.HSQL.ErrorDatabase.HSQL.TypesDB.HSQL.Type.GeometricDB.HSQL.Type.NetAddress DB.HSQL.Core Database.HSQLDB.HSQL.Type.DiverseDB.HSQL.Type.TimeDB.HSQL.Type.NumericSqlType SqlUnknowntypeCodeSqlBLOBSqlSETSqlLongVarBinary SqlVarBinary SqlBinary SqlMacAddr SqlCIDRAddr SqlINetAddr SqlCircleSqlLine SqlPolygonSqlBoxSqlPathSqlLSegSqlPointSqlENUMSqlBitSqlYear SqlDateTimeTZ SqlDateTime SqlTimeStampSqlAbsTimeIntervalSqlTimeInterval SqlRelTime SqlAbsTime SqlTimeTZSqlTimeSqlDateSqlWLongVarChar SqlWVarCharSqlWCharSqlTextSqlLongVarChar SqlVarCharSqlCharSqlMoneySqlFloat SqlDoubleSqlReal SqlNumeric SqlDecimaltypeSize typeDecimals SqlMedInt SqlTinyInt SqlSmallInt SqlBigInt SqlIntegerSqlErrorSqlClosedHandleSqlUnsupportedOperationSqlUnknownField SqlFetchNullSqlBadTypeCast seFieldName seFieldTypeSqlNeedMoreDataSqlStillExecutingSqlInvalidHandle SqlNoMoreDataseState seNativeError seErrorMsgSqlBind toSqlValue fromSqlValuefromSqlCStringLen StatementstmtConn stmtClose stmtFetch stmtGetCol stmtFields stmtClosed FieldReading FieldReader ConnectionconnDisconnect connExecute connQuery connTables connDescribeconnBeginTransactionconnCommitTransactionconnRollbackTransaction connClosedTableIdSQLColDef NullabilityColIdCircle circleCenter circleRadiusPolygon polygonPointsBoxboxX1boxY1boxX2boxY2Path ClosedPathOpenPath pathPointsLine lineBeginlineEndPointpointXpointYMacAddr macOctet1 macOctet2 macOctet3 macOctet4 macOctet5 macOctet6INetAddr ip4Octet1 ip4Octet2 ip4Octet3 ip4Octet4 cidrMaskBits closeHandle checkHandle sqlExceptionscatchSql handleSql disconnectexecutequerytablesdescribe inTransactionfetchcloseStatementgetFieldValueTypegetFieldsTypes getFieldValuegetFieldValueMBgetFieldValue' forEachRow forEachRow' collectRows$fExceptionSqlError$fShowSqlError$fSqlBindMaybe $fSqlBindBool $fSqlBind[]$fSqlBindCircle$fSqlBindPolygon $fSqlBindBox $fSqlBindPath $fSqlBindLine$fSqlBindPoint$fSqlBindClockTime$fSqlBindMacAddr$fSqlBindINetAddr$fSqlBindFloat$fSqlBindDouble$fSqlBindInteger$fSqlBindInt64 $fSqlBindIntbase GHC.Exception ExceptionControl.Exception.Basecatchhandle SomeException