HTSQL Reference Manual

Compiled by Yuri Yerokhin

• 1. Basic Concepts
  • 1.1. Abstract
    • 1.1.1. Understanding HTSQL
    • 1.1.2. How to read syntax diagrams
  • 1.2. HTSQL catalog
  • 1.3. Data Types (Domains)
    • 1.3.1. Summary of HTSQL domains
    • 1.3.2. Boolean
    • 1.3.3. String
    • 1.3.4. Numeric
    • 1.3.5. Date and Time
    • 1.3.6. Array
  • 1.4. Language elements
    • 1.4.1. Constants
    • 1.4.2. Nulls
    • 1.4.3. Identifiers
    • 1.4.4. Namespaces
    • 1.4.5. Aliases
    • 1.4.6. Variables
  • 1.5. Encoding And Escaping characters
  • 1.6. Authorization issues
  • 1.7. Transactions
• 2. Expressions
  • 2.1. Expression Context
  • 2.2. Specifiers
  • 2.3. Plurality and Plural Expressions
  • 2.4. Assignments
  • 2.5. Pointers
• 3. HTSQL Query Syntax
  • 3.1. Syntax Diagrams
  • 3.2. Query
  • 3.3. Credentials
  • 3.4. Hints
  • 3.5. Tree Path
    • 3.5.1. tree_clause
    • 3.5.2. segment_clause
  • 3.6. Selector
    • 3.6.1. selector_clause
    • 3.6.2. selection
  • 3.7. Filter
    • 3.7.1. filter_clause
  • 3.8. Locator
    • 3.8.1. locator_clause
    • 3.8.2. location
    • 3.8.3. label
    • 3.8.4. sublocator
  • 3.9. Commands
    • 3.9.1. command_call
    • 3.9.2. argument_list
• 4. Operators
  • 4.1. Comparison Operators
    • 4.1.1. = (equals)
    • 4.1.2. != (not equals)
    • 4.1.3. == (null-safe equals)
    • 4.1.4. !== (null-safe not equals)
    • 4.1.5. > (greater)
    • 4.1.6. >= (greater or equals)
    • 4.1.7. < (less)
    • 4.1.8. <= (less or equals)
  • 4.2. Boolean Operators
    • 4.2.1. | (disjunction, logical OR)
    • 4.2.2. & (conjunction, logical AND)
    • 4.2.3. ! (inversion, logical NOT)
    • 4.2.4. -> (implication)
  • 4.3. String Operators
    • 4.3.1. [ ] (index)
    • 4.3.2. [:] (slice)
    • 4.3.3. + (concatenation)
    • 4.3.4. ~ (case-insensitive pattern check)
    • 4.3.5. !~ (case-insensitive inverse pattern check)
    • 4.3.6. ~~ (case-sensitive pattern check)
    • 4.3.7. !~~ (case-insensitive inverse pattern check)
  • 4.4. Numeric Operators
    • 4.4.1. - (negation)
    • 4.4.2. + (addition)
    • 4.4.3. - (subtraction)
    • 4.4.4. * (multiplication)
    • 4.4.5. div
    • 4.4.6. mod
    • 4.4.7. ^ (power)
    • 4.4.8. bitwise_and
    • 4.4.9. bitwise_or
    • 4.4.10. bitwise_xor
    • 4.4.11. bitwise_lshift
    • 4.4.12. bitwise_rshift
  • 4.5. Date And Time Operators
    • 4.5.1. - (negation)
    • 4.5.2. + (addition)
    • 4.5.3. - (subtraction)
    • 4.5.4. * (multiplication)
    • 4.5.5. div
  • 4.6. Array Operators
    • 4.6.1. [ ] (index)
    • 4.6.2. [:] (slice)
    • 4.6.3. + (concatenation)
  • 4.7. Aliasing and Assignment Operators
    • 4.7.1. as
    • 4.7.2. := (assignment)
• 5. Functions
  • 5.1. Conversion and Constructor Functions
    • 5.1.1. String conversion
    • 5.1.2. Numeric conversion
    • 5.1.3. Boolean conversion
    • 5.1.4. Date and Time conversion
    • 5.1.5. Array constructor
  • 5.2. Boolean Functions
    • 5.2.1. Basic functions
    • 5.2.2. Conditional functions
  • 5.3. String Functions
    • 5.3.1. Basic functions
    • 5.3.2. Filtering and formatting functions
    • 5.3.3. Search and replace functions
  • 5.4. Numeric Functions
    • 5.4.1. Arithmetic functions
    • 5.4.2. Bitwise functions
    • 5.4.3. Mathematical functions
    • 5.4.4. Trigonometric functions
  • 5.5. Date And Time Functions
    • 5.5.1. Current date and time functions
    • 5.5.2. Date and time arithmetic
  • 5.6. Array Functions
    • 5.6.1. Basic functions
  • 5.7. Aggregate Functions
    • 5.7.1. Aggregate functions
    • 5.7.2. Multivalue comparison functions
  • 5.8. Other Functions
    • 5.8.1. Null related functions
    • 5.8.2. Identity functions
    • 5.8.3. Aliasing function
    • 5.8.4. Other functions
• 6. Commands
  • 6.1. Descriptor Commands
    • 6.1.1. version
    • 6.1.2. meta
    • 6.1.3. describe
    • 6.1.4. sql
    • 6.1.5. root
  • 6.2. Query Processor Commands
    • 6.2.1. select
    • 6.2.2. insert
    • 6.2.3. update
    • 6.2.4. delete
    • 6.2.5. merge
  • 6.3. Transformer Commands
    • 6.3.1. flatten
    • 6.3.2. interweave
    • 6.3.3. first
    • 6.3.4. pivot
    • 6.3.5. foreach
  • 6.4. Formatter Commands
    • 6.4.1. txt
    • 6.4.2. csv
    • 6.4.3. tsv
    • 6.4.4. html
    • 6.4.5. xml
    • 6.4.6. yaml
    • 6.4.7. json
    • 6.4.8. jsonp
  • 6.5. Transactions Supporting Command
    • 6.5.1. transaction
• 7. Error Codes

Indices and tables

• Index
• Module Index
• Search Page