Adding upstream version 0.11.1.upstream/0.11.1upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

3 files changed, 5482 insertions, 0 deletions

diff --git a/src/internals/README.md b/src/internals/README.md
new file mode 100644
index 0000000..d4a2187
--- /dev/null
+++ b/src/internals/README.md
@@ -0,0 +1,4 @@
+# Internals
+
+This directory contains documentation fragments that are generated from lnav's
+built-in help and schemas.
diff --git a/src/internals/cmd-ref.rst b/src/internals/cmd-ref.rst
new file mode 100644
index 0000000..8509286
--- /dev/null
+++ b/src/internals/cmd-ref.rst
@@ -0,0 +1,1628 @@
+
+.. _adjust_log_time:
+
+:adjust-log-time *timestamp*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Change the timestamps of the top file to be relative to the given date
+
+  **Parameters**
+    * **timestamp\*** --- The new timestamp for the top line in the view
+
+  **Examples**
+    To set the top timestamp to a given date:
+
+    .. code-block::  lnav
+
+      :adjust-log-time 2017-01-02T05:33:00
+
+    To set the top timestamp back an hour:
+
+    .. code-block::  lnav
+
+      :adjust-log-time -1h
+
+
+----
+
+
+.. _alt_msg:
+
+:alt-msg *msg*
+^^^^^^^^^^^^^^
+
+  Display a message in the alternate command position
+
+  **Parameters**
+    * **msg\*** --- The message to display
+
+  **Examples**
+    To display 'Press t to switch to the text view' on the bottom right:
+
+    .. code-block::  lnav
+
+      :alt-msg Press t to switch to the text view
+
+  **See Also**
+    :ref:`echo`, :ref:`eval`, :ref:`export_session_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_view_to`
+
+----
+
+
+.. _append_to:
+
+:append-to *path*
+^^^^^^^^^^^^^^^^^
+
+  Append marked lines in the current view to the given file
+
+  **Parameters**
+    * **path\*** --- The path to the file to append to
+
+  **Examples**
+    To append marked lines to the file /tmp/interesting-lines.txt:
+
+    .. code-block::  lnav
+
+      :append-to /tmp/interesting-lines.txt
+
+  **See Also**
+    :ref:`echo`, :ref:`echoln`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_view_to`
+
+----
+
+
+.. _clear_comment:
+
+:clear-comment
+^^^^^^^^^^^^^^
+
+  Clear the comment attached to the top log line
+
+  **See Also**
+    :ref:`comment`, :ref:`tag`
+
+----
+
+
+.. _clear_filter_expr:
+
+:clear-filter-expr
+^^^^^^^^^^^^^^^^^^
+
+  Clear the filter expression
+
+  **See Also**
+    :ref:`filter_expr`, :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _clear_highlight:
+
+:clear-highlight *pattern*
+^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Remove a previously set highlight regular expression
+
+  **Parameters**
+    * **pattern\*** --- The regular expression previously used with :highlight
+
+  **Examples**
+    To clear the highlight with the pattern 'foobar':
+
+    .. code-block::  lnav
+
+      :clear-highlight foobar
+
+  **See Also**
+    :ref:`enable_word_wrap`, :ref:`hide_fields`, :ref:`highlight`
+
+----
+
+
+.. _clear_mark_expr:
+
+:clear-mark-expr
+^^^^^^^^^^^^^^^^
+
+  Clear the mark expression
+
+  **See Also**
+    :ref:`hide_unmarked_lines`, :ref:`mark_expr`, :ref:`mark`, :ref:`next_mark`, :ref:`prev_mark`
+
+----
+
+
+.. _clear_partition:
+
+:clear-partition
+^^^^^^^^^^^^^^^^
+
+  Clear the partition the top line is a part of
+
+
+----
+
+
+.. _close:
+
+:close
+^^^^^^
+
+  Close the top file in the view
+
+
+----
+
+
+.. _comment:
+
+:comment *text*
+^^^^^^^^^^^^^^^
+
+  Attach a comment to the top log line.  The comment will be displayed right below the log message it is associated with. The comment can be formatted using markdown and you can add new-lines with '\n'.
+
+  **Parameters**
+    * **text\*** --- The comment text
+
+  **Examples**
+    To add the comment 'This is where it all went wrong' to the top line:
+
+    .. code-block::  lnav
+
+      :comment This is where it all went wrong
+
+  **See Also**
+    :ref:`clear_comment`, :ref:`tag`
+
+----
+
+
+.. _config:
+
+:config *option* *\[value\]*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Read or write a configuration option
+
+  **Parameters**
+    * **option\*** --- The path to the option to read or write
+    * **value** --- The value to write.  If not given, the current value is returned
+
+  **Examples**
+    To read the configuration of the '/ui/clock-format' option:
+
+    .. code-block::  lnav
+
+      :config /ui/clock-format
+
+    To set the '/ui/dim-text' option to 'false':
+
+    .. code-block::  lnav
+
+      :config /ui/dim-text false
+
+  **See Also**
+    :ref:`reset_config`
+
+----
+
+
+.. _create_logline_table:
+
+:create-logline-table *table-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Create an SQL table using the top line of the log view as a template
+
+  **Parameters**
+    * **table-name\*** --- The name for the new table
+
+  **Examples**
+    To create a logline-style table named 'task_durations':
+
+    .. code-block::  lnav
+
+      :create-logline-table task_durations
+
+  **See Also**
+    :ref:`create_search_table`, :ref:`create_search_table`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_view_to`
+
+----
+
+
+.. _create_search_table:
+
+:create-search-table *table-name* *\[pattern\]*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Create an SQL table based on a regex search
+
+  **Parameters**
+    * **table-name\*** --- The name of the table to create
+    * **pattern** --- The regular expression used to capture the table columns.  If not given, the current search pattern is used.
+
+  **Examples**
+    To create a table named 'task_durations' that matches log messages with the pattern 'duration=(?<duration>\d+)':
+
+    .. code-block::  lnav
+
+      :create-search-table task_durations duration=(?<duration>\d+)
+
+  **See Also**
+    :ref:`create_logline_table`, :ref:`create_logline_table`, :ref:`delete_search_table`, :ref:`delete_search_table`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_view_to`
+
+----
+
+
+.. _current_time:
+
+:current-time
+^^^^^^^^^^^^^
+
+  Print the current time in human-readable form and seconds since the epoch
+
+
+----
+
+
+.. _delete_filter:
+
+:delete-filter *pattern*
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Delete the filter created with :filter-in or :filter-out
+
+  **Parameters**
+    * **pattern\*** --- The regular expression to match
+
+  **Examples**
+    To delete the filter with the pattern 'last message repeated':
+
+    .. code-block::  lnav
+
+      :delete-filter last message repeated
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _delete_logline_table:
+
+:delete-logline-table *table-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Delete a table created with create-logline-table
+
+  **Parameters**
+    * **table-name\*** --- The name of the table to delete
+
+  **Examples**
+    To delete the logline-style table named 'task_durations':
+
+    .. code-block::  lnav
+
+      :delete-logline-table task_durations
+
+  **See Also**
+    :ref:`create_logline_table`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`create_search_table`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_view_to`
+
+----
+
+
+.. _delete_search_table:
+
+:delete-search-table *table-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Create an SQL table based on a regex search
+
+  **Parameters**
+    * **table-name\*** --- The name of the table to create
+
+  **Examples**
+    To delete the search table named 'task_durations':
+
+    .. code-block::  lnav
+
+      :delete-search-table task_durations
+
+  **See Also**
+    :ref:`create_logline_table`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`create_search_table`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_view_to`
+
+----
+
+
+.. _delete_tags:
+
+:delete-tags *tag*
+^^^^^^^^^^^^^^^^^^
+
+  Remove the given tags from all log lines
+
+  **Parameters**
+    * **tag** --- The tags to delete
+
+  **Examples**
+    To remove the tags '#BUG123' and '#needs-review' from all log lines:
+
+    .. code-block::  lnav
+
+      :delete-tags #BUG123 #needs-review
+
+  **See Also**
+    :ref:`comment`, :ref:`tag`
+
+----
+
+
+.. _disable_filter:
+
+:disable-filter *pattern*
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Disable a filter created with filter-in/filter-out
+
+  **Parameters**
+    * **pattern\*** --- The regular expression used in the filter command
+
+  **Examples**
+    To disable the filter with the pattern 'last message repeated':
+
+    .. code-block::  lnav
+
+      :disable-filter last message repeated
+
+  **See Also**
+    :ref:`enable_filter`, :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _disable_word_wrap:
+
+:disable-word-wrap
+^^^^^^^^^^^^^^^^^^
+
+  Disable word-wrapping for the current view
+
+  **See Also**
+    :ref:`enable_word_wrap`, :ref:`hide_fields`, :ref:`highlight`
+
+----
+
+
+.. _echo:
+
+:echo *\[-n\]* *msg*
+^^^^^^^^^^^^^^^^^^^^
+
+  Echo the given message to the screen or, if :redirect-to has been called, to output file specified in the redirect.  Variable substitution is performed on the message.  Use a backslash to escape any special characters, like '$'
+
+  **Parameters**
+    * **-n** --- Do not print a line-feed at the end of the output
+    * **msg\*** --- The message to display
+
+  **Examples**
+    To output 'Hello, World!':
+
+    .. code-block::  lnav
+
+      :echo Hello, World!
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _enable_filter:
+
+:enable-filter *pattern*
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Enable a previously created and disabled filter
+
+  **Parameters**
+    * **pattern\*** --- The regular expression used in the filter command
+
+  **Examples**
+    To enable the disabled filter with the pattern 'last message repeated':
+
+    .. code-block::  lnav
+
+      :enable-filter last message repeated
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _enable_word_wrap:
+
+:enable-word-wrap
+^^^^^^^^^^^^^^^^^
+
+  Enable word-wrapping for the current view
+
+  **See Also**
+    :ref:`disable_word_wrap`, :ref:`hide_fields`, :ref:`highlight`
+
+----
+
+
+.. _eval:
+
+:eval *command*
+^^^^^^^^^^^^^^^
+
+  Evaluate the given command/query after doing environment variable substitution
+
+  **Parameters**
+    * **command\*** --- The command or query to perform substitution on.
+
+  **Examples**
+    To substitute the table name from a variable:
+
+    .. code-block::  lnav
+
+      :eval ;SELECT * FROM ${table}
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`echo`, :ref:`export_session_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_view_to`
+
+----
+
+
+.. _export_session_to:
+
+:export-session-to *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Export the current lnav state to an executable lnav script file that contains the commands needed to restore the current session
+
+  **Parameters**
+    * **path\*** --- The path to the file to write
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _filter_expr:
+
+:filter-expr *expr*
+^^^^^^^^^^^^^^^^^^^
+
+  Set the filter expression
+
+  **Parameters**
+    * **expr\*** --- The SQL expression to evaluate for each log message.  The message values can be accessed using column names prefixed with a colon
+
+  **Examples**
+    To set a filter expression that matched syslog messages from 'syslogd':
+
+    .. code-block::  lnav
+
+      :filter-expr :log_procname = 'syslogd'
+
+    To set a filter expression that matches log messages where 'id' is followed by a number and contains the string 'foo':
+
+    .. code-block::  lnav
+
+      :filter-expr :log_body REGEXP 'id\d+' AND :log_body REGEXP 'foo'
+
+  **See Also**
+    :ref:`clear_filter_expr`, :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _filter_in:
+
+:filter-in *pattern*
+^^^^^^^^^^^^^^^^^^^^
+
+  Only show lines that match the given regular expression in the current view
+
+  **Parameters**
+    * **pattern\*** --- The regular expression to match
+
+  **Examples**
+    To filter out log messages that do not have the string 'dhclient':
+
+    .. code-block::  lnav
+
+      :filter-in dhclient
+
+  **See Also**
+    :ref:`delete_filter`, :ref:`disable_filter`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _filter_out:
+
+:filter-out *pattern*
+^^^^^^^^^^^^^^^^^^^^^
+
+  Remove lines that match the given regular expression in the current view
+
+  **Parameters**
+    * **pattern\*** --- The regular expression to match
+
+  **Examples**
+    To filter out log messages that contain the string 'last message repeated':
+
+    .. code-block::  lnav
+
+      :filter-out last message repeated
+
+  **See Also**
+    :ref:`delete_filter`, :ref:`disable_filter`, :ref:`filter_in`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _goto:
+
+:goto *line#|N%|timestamp|#anchor*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Go to the given location in the top view
+
+  **Parameters**
+    * **line#|N%|timestamp|#anchor\*** --- A line number, percent into the file, timestamp, or an anchor in a text file
+
+  **Examples**
+    To go to line 22:
+
+    .. code-block::  lnav
+
+      :goto 22
+
+    To go to the line 75% of the way into the view:
+
+    .. code-block::  lnav
+
+      :goto 75%
+
+    To go to the first message on the first day of 2017:
+
+    .. code-block::  lnav
+
+      :goto 2017-01-01
+
+    To go to the Screenshots section:
+
+    .. code-block::  lnav
+
+      :goto #screenshots
+
+  **See Also**
+    :ref:`next_location`, :ref:`next_mark`, :ref:`prev_location`, :ref:`prev_mark`, :ref:`relative_goto`
+
+----
+
+
+.. _help:
+
+:help
+^^^^^
+
+  Open the help text view
+
+
+----
+
+
+.. _hide_fields:
+
+:hide-fields *field-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Hide log message fields by replacing them with an ellipsis
+
+  **Parameters**
+    * **field-name** --- The name of the field to hide in the format for the top log line.  A qualified name can be used where the field name is prefixed by the format name and a dot to hide any field.
+
+  **Examples**
+    To hide the log_procname fields in all formats:
+
+    .. code-block::  lnav
+
+      :hide-fields log_procname
+
+    To hide only the log_procname field in the syslog format:
+
+    .. code-block::  lnav
+
+      :hide-fields syslog_log.log_procname
+
+  **See Also**
+    :ref:`enable_word_wrap`, :ref:`highlight`, :ref:`show_fields`
+
+----
+
+
+.. _hide_file:
+
+:hide-file *path*
+^^^^^^^^^^^^^^^^^
+
+  Hide the given file(s) and skip indexing until it is shown again.  If no path is given, the current file in the view is hidden
+
+  **Parameters**
+    * **path** --- A path or glob pattern that specifies the files to hide
+
+
+----
+
+
+.. _hide_lines_after:
+
+:hide-lines-after *date*
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Hide lines that come after the given date
+
+  **Parameters**
+    * **date\*** --- An absolute or relative date
+
+  **Examples**
+    To hide the lines after the top line in the view:
+
+    .. code-block::  lnav
+
+      :hide-lines-after here
+
+    To hide the lines after 6 AM today:
+
+    .. code-block::  lnav
+
+      :hide-lines-after 6am
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`show_lines_before_and_after`, :ref:`toggle_filtering`
+
+----
+
+
+.. _hide_lines_before:
+
+:hide-lines-before *date*
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Hide lines that come before the given date
+
+  **Parameters**
+    * **date\*** --- An absolute or relative date
+
+  **Examples**
+    To hide the lines before the top line in the view:
+
+    .. code-block::  lnav
+
+      :hide-lines-before here
+
+    To hide the log messages before 6 AM today:
+
+    .. code-block::  lnav
+
+      :hide-lines-before 6am
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_unmarked_lines`, :ref:`show_lines_before_and_after`, :ref:`toggle_filtering`
+
+----
+
+
+.. _hide_unmarked_lines:
+
+:hide-unmarked-lines
+^^^^^^^^^^^^^^^^^^^^
+
+  Hide lines that have not been bookmarked
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`mark`, :ref:`next_mark`, :ref:`prev_mark`, :ref:`toggle_filtering`
+
+----
+
+
+.. _highlight:
+
+:highlight *pattern*
+^^^^^^^^^^^^^^^^^^^^
+
+  Add coloring to log messages fragments that match the given regular expression
+
+  **Parameters**
+    * **pattern\*** --- The regular expression to match
+
+  **Examples**
+    To highlight numbers with three or more digits:
+
+    .. code-block::  lnav
+
+      :highlight \d{3,}
+
+  **See Also**
+    :ref:`clear_highlight`, :ref:`enable_word_wrap`, :ref:`hide_fields`
+
+----
+
+
+.. _load_session:
+
+:load-session
+^^^^^^^^^^^^^
+
+  Load the latest session state
+
+
+----
+
+
+.. _mark:
+
+:mark
+^^^^^
+
+  Toggle the bookmark state for the top line in the current view
+
+  **See Also**
+    :ref:`hide_unmarked_lines`, :ref:`next_mark`, :ref:`prev_mark`
+
+----
+
+
+.. _mark_expr:
+
+:mark-expr *expr*
+^^^^^^^^^^^^^^^^^
+
+  Set the bookmark expression
+
+  **Parameters**
+    * **expr\*** --- The SQL expression to evaluate for each log message.  The message values can be accessed using column names prefixed with a colon
+
+  **Examples**
+    To mark lines from 'dhclient' that mention 'eth0':
+
+    .. code-block::  lnav
+
+      :mark-expr :log_procname = 'dhclient' AND :log_body LIKE '%eth0%'
+
+  **See Also**
+    :ref:`clear_mark_expr`, :ref:`hide_unmarked_lines`, :ref:`mark`, :ref:`next_mark`, :ref:`prev_mark`
+
+----
+
+
+.. _next_location:
+
+:next-location
+^^^^^^^^^^^^^^
+
+  Move to the next position in the location history
+
+  **See Also**
+    :ref:`goto`, :ref:`next_mark`, :ref:`prev_location`, :ref:`prev_mark`, :ref:`relative_goto`
+
+----
+
+
+.. _next_mark:
+
+:next-mark *type*
+^^^^^^^^^^^^^^^^^
+
+  Move to the next bookmark of the given type in the current view
+
+  **Parameters**
+    * **type** --- The type of bookmark -- error, warning, search, user, file, meta
+
+  **Examples**
+    To go to the next error:
+
+    .. code-block::  lnav
+
+      :next-mark error
+
+  **See Also**
+    :ref:`goto`, :ref:`hide_unmarked_lines`, :ref:`mark`, :ref:`next_location`, :ref:`prev_location`, :ref:`prev_mark`, :ref:`prev_mark`, :ref:`relative_goto`
+
+----
+
+
+.. _open:
+
+:open *path*
+^^^^^^^^^^^^
+
+  Open the given file(s) in lnav.  Opening files on machines accessible via SSH can be done using the syntax: [user@]host:/path/to/logs
+
+  **Parameters**
+    * **path** --- The path to the file to open
+
+  **Examples**
+    To open the file '/path/to/file':
+
+    .. code-block::  lnav
+
+      :open /path/to/file
+
+    To open the remote file '/var/log/syslog.log':
+
+    .. code-block::  lnav
+
+      :open dean@host1.example.com:/var/log/syslog.log
+
+
+----
+
+
+.. _partition_name:
+
+:partition-name *name*
+^^^^^^^^^^^^^^^^^^^^^^
+
+  Mark the top line in the log view as the start of a new partition with the given name
+
+  **Parameters**
+    * **name\*** --- The name for the new partition
+
+  **Examples**
+    To mark the top line as the start of the partition named 'boot #1':
+
+    .. code-block::  lnav
+
+      :partition-name boot #1
+
+
+----
+
+
+.. _pipe_line_to:
+
+:pipe-line-to *shell-cmd*
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Pipe the top line to the given shell command
+
+  **Parameters**
+    * **shell-cmd\*** --- The shell command-line to execute
+
+  **Examples**
+    To write the top line to 'sed' for processing:
+
+    .. code-block::  lnav
+
+      :pipe-line-to sed -e 's/foo/bar/g'
+
+  **See Also**
+    :ref:`append_to`, :ref:`echo`, :ref:`echoln`, :ref:`export_session_to`, :ref:`pipe_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_view_to`
+
+----
+
+
+.. _pipe_to:
+
+:pipe-to *shell-cmd*
+^^^^^^^^^^^^^^^^^^^^
+
+  Pipe the marked lines to the given shell command
+
+  **Parameters**
+    * **shell-cmd\*** --- The shell command-line to execute
+
+  **Examples**
+    To write marked lines to 'sed' for processing:
+
+    .. code-block::  lnav
+
+      :pipe-to sed -e s/foo/bar/g
+
+  **See Also**
+    :ref:`append_to`, :ref:`echo`, :ref:`echoln`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_view_to`
+
+----
+
+
+.. _prev_location:
+
+:prev-location
+^^^^^^^^^^^^^^
+
+  Move to the previous position in the location history
+
+  **See Also**
+    :ref:`goto`, :ref:`next_location`, :ref:`next_mark`, :ref:`prev_mark`, :ref:`relative_goto`
+
+----
+
+
+.. _prev_mark:
+
+:prev-mark *type*
+^^^^^^^^^^^^^^^^^
+
+  Move to the previous bookmark of the given type in the current view
+
+  **Parameters**
+    * **type** --- The type of bookmark -- error, warning, search, user, file, meta
+
+  **Examples**
+    To go to the previous error:
+
+    .. code-block::  lnav
+
+      :prev-mark error
+
+  **See Also**
+    :ref:`goto`, :ref:`hide_unmarked_lines`, :ref:`mark`, :ref:`next_location`, :ref:`next_mark`, :ref:`next_mark`, :ref:`prev_location`, :ref:`relative_goto`
+
+----
+
+
+.. _prompt:
+
+:prompt *type* *\[--alt\]* *\[prompt\]* *\[initial-value\]*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Open the given prompt
+
+  **Parameters**
+    * **type\*** --- The type of prompt -- command, script, search, sql, user
+    * **--alt** --- Perform the alternate action for this prompt by default
+    * **prompt** --- The prompt to display
+    * **initial-value** --- The initial value to fill in for the prompt
+
+  **Examples**
+    To open the command prompt with 'filter-in' already filled in:
+
+    .. code-block::  lnav
+
+      :prompt command : 'filter-in '
+
+    To ask the user a question:
+
+    .. code-block::  lnav
+
+      :prompt user 'Are you sure? '
+
+
+----
+
+
+.. _quit:
+
+:quit
+^^^^^
+
+  Quit lnav
+
+
+----
+
+
+.. _rebuild:
+
+:rebuild
+^^^^^^^^
+
+  Forcefully rebuild file indexes
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`echo`, :ref:`eval`, :ref:`export_session_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_view_to`
+
+----
+
+
+.. _redirect_to:
+
+:redirect-to *\[path\]*
+^^^^^^^^^^^^^^^^^^^^^^^
+
+  Redirect the output of commands that write to stdout to the given file
+
+  **Parameters**
+    * **path** --- The path to the file to write.  If not specified, the current redirect will be cleared
+
+  **Examples**
+    To write the output of lnav commands to the file /tmp/script-output.txt:
+
+    .. code-block::  lnav
+
+      :redirect-to /tmp/script-output.txt
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _redraw:
+
+:redraw
+^^^^^^^
+
+  Do a full redraw of the screen
+
+
+----
+
+
+.. _relative_goto:
+
+:relative-goto *line-count|N%*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Move the current view up or down by the given amount
+
+  **Parameters**
+    * **line-count|N%\*** --- The amount to move the view by.
+
+  **Examples**
+    To move 22 lines down in the view:
+
+    .. code-block::  lnav
+
+      :relative-goto +22
+
+    To move 10 percent back in the view:
+
+    .. code-block::  lnav
+
+      :relative-goto -10%
+
+  **See Also**
+    :ref:`goto`, :ref:`next_location`, :ref:`next_mark`, :ref:`prev_location`, :ref:`prev_mark`
+
+----
+
+
+.. _reset_config:
+
+:reset-config *option*
+^^^^^^^^^^^^^^^^^^^^^^
+
+  Reset the configuration option to its default value
+
+  **Parameters**
+    * **option\*** --- The path to the option to reset
+
+  **Examples**
+    To reset the '/ui/clock-format' option back to the builtin default:
+
+    .. code-block::  lnav
+
+      :reset-config /ui/clock-format
+
+  **See Also**
+    :ref:`config`
+
+----
+
+
+.. _reset_session:
+
+:reset-session
+^^^^^^^^^^^^^^
+
+  Reset the session state, clearing all filters, highlights, and bookmarks
+
+
+----
+
+
+.. _save_session:
+
+:save-session
+^^^^^^^^^^^^^
+
+  Save the current state as a session
+
+
+----
+
+
+.. _session:
+
+:session *lnav-command*
+^^^^^^^^^^^^^^^^^^^^^^^
+
+  Add the given command to the session file (~/.lnav/session)
+
+  **Parameters**
+    * **lnav-command\*** --- The lnav command to save.
+
+  **Examples**
+    To add the command ':highlight foobar' to the session file:
+
+    .. code-block::  lnav
+
+      :session :highlight foobar
+
+
+----
+
+
+.. _set_min_log_level:
+
+:set-min-log-level *log-level*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Set the minimum log level to display in the log view
+
+  **Parameters**
+    * **log-level\*** --- The new minimum log level
+
+  **Examples**
+    To set the minimum log level displayed to error:
+
+    .. code-block::  lnav
+
+      :set-min-log-level error
+
+
+----
+
+
+.. _show_fields:
+
+:show-fields *field-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Show log message fields that were previously hidden
+
+  **Parameters**
+    * **field-name** --- The name of the field to show
+
+  **Examples**
+    To show all the log_procname fields in all formats:
+
+    .. code-block::  lnav
+
+      :show-fields log_procname
+
+  **See Also**
+    :ref:`enable_word_wrap`, :ref:`hide_fields`, :ref:`highlight`
+
+----
+
+
+.. _show_file:
+
+:show-file *path*
+^^^^^^^^^^^^^^^^^
+
+  Show the given file(s) and resume indexing.
+
+  **Parameters**
+    * **path** --- The path or glob pattern that specifies the files to show
+
+
+----
+
+
+.. _show_lines_before_and_after:
+
+:show-lines-before-and-after
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Show lines that were hidden by the 'hide-lines' commands
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`toggle_filtering`
+
+----
+
+
+.. _show_only_this_file:
+
+:show-only-this-file
+^^^^^^^^^^^^^^^^^^^^
+
+  Show only the file for the top line in the view
+
+
+----
+
+
+.. _show_unmarked_lines:
+
+:show-unmarked-lines
+^^^^^^^^^^^^^^^^^^^^
+
+  Show lines that have not been bookmarked
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`, :ref:`hide_unmarked_lines`, :ref:`mark`, :ref:`next_mark`, :ref:`prev_mark`, :ref:`toggle_filtering`
+
+----
+
+
+.. _spectrogram:
+
+:spectrogram *field-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Visualize the given message field or database column using a spectrogram
+
+  **Parameters**
+    * **field-name\*** --- The name of the numeric field to visualize.
+
+  **Examples**
+    To visualize the sc_bytes field in the access_log format:
+
+    .. code-block::  lnav
+
+      :spectrogram sc_bytes
+
+
+----
+
+
+.. _summarize:
+
+:summarize *column-name*
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Execute a SQL query that computes the characteristics of the values in the given column
+
+  **Parameters**
+    * **column-name\*** --- The name of the column to analyze.
+
+  **Examples**
+    To get a summary of the sc_bytes column in the access_log table:
+
+    .. code-block::  lnav
+
+      :summarize sc_bytes
+
+
+----
+
+
+.. _switch_to_view:
+
+:switch-to-view *view-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Switch to the given view
+
+  **Parameters**
+    * **view-name\*** --- The name of the view to switch to.
+
+  **Examples**
+    To switch to the 'schema' view:
+
+    .. code-block::  lnav
+
+      :switch-to-view schema
+
+
+----
+
+
+.. _tag:
+
+:tag *tag*
+^^^^^^^^^^
+
+  Attach tags to the top log line
+
+  **Parameters**
+    * **tag** --- The tags to attach
+
+  **Examples**
+    To add the tags '#BUG123' and '#needs-review' to the top line:
+
+    .. code-block::  lnav
+
+      :tag #BUG123 #needs-review
+
+  **See Also**
+    :ref:`comment`, :ref:`delete_tags`, :ref:`untag`
+
+----
+
+
+.. _toggle_filtering:
+
+:toggle-filtering
+^^^^^^^^^^^^^^^^^
+
+  Toggle the filtering flag for the current view
+
+  **See Also**
+    :ref:`filter_in`, :ref:`filter_out`, :ref:`hide_lines_after`, :ref:`hide_lines_before`, :ref:`hide_unmarked_lines`
+
+----
+
+
+.. _toggle_view:
+
+:toggle-view *view-name*
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Switch to the given view or, if it is already displayed, switch to the previous view
+
+  **Parameters**
+    * **view-name\*** --- The name of the view to toggle the display of.
+
+  **Examples**
+    To switch to the 'schema' view if it is not displayed or switch back to the previous view:
+
+    .. code-block::  lnav
+
+      :toggle-view schema
+
+
+----
+
+
+.. _unix_time:
+
+:unix-time *seconds*
+^^^^^^^^^^^^^^^^^^^^
+
+  Convert epoch time to a human-readable form
+
+  **Parameters**
+    * **seconds\*** --- The epoch timestamp to convert
+
+  **Examples**
+    To convert the epoch time 1490191111:
+
+    .. code-block::  lnav
+
+      :unix-time 1490191111
+
+
+----
+
+
+.. _untag:
+
+:untag *tag*
+^^^^^^^^^^^^
+
+  Detach tags from the top log line
+
+  **Parameters**
+    * **tag** --- The tags to detach
+
+  **Examples**
+    To remove the tags '#BUG123' and '#needs-review' from the top line:
+
+    .. code-block::  lnav
+
+      :untag #BUG123 #needs-review
+
+  **See Also**
+    :ref:`comment`, :ref:`tag`
+
+----
+
+
+.. _write_table_to:
+
+:write-table-to *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Write SQL results to the given file in a tabular format
+
+  **Parameters**
+    * **--anonymize** --- Anonymize the table contents
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write SQL results as text to /tmp/table.txt:
+
+    .. code-block::  lnav
+
+      :write-table-to /tmp/table.txt
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _write_csv_to:
+
+:write-csv-to *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Write SQL results to the given file in CSV format
+
+  **Parameters**
+    * **--anonymize** --- Anonymize the row contents
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write SQL results as CSV to /tmp/table.csv:
+
+    .. code-block::  lnav
+
+      :write-csv-to /tmp/table.csv
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _write_json_to:
+
+:write-json-to *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Write SQL results to the given file in JSON format
+
+  **Parameters**
+    * **--anonymize** --- Anonymize the JSON values
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write SQL results as JSON to /tmp/table.json:
+
+    .. code-block::  lnav
+
+      :write-json-to /tmp/table.json
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _write_jsonlines_to:
+
+:write-jsonlines-to *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Write SQL results to the given file in JSON Lines format
+
+  **Parameters**
+    * **--anonymize** --- Anonymize the JSON values
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write SQL results as JSON Lines to /tmp/table.json:
+
+    .. code-block::  lnav
+
+      :write-jsonlines-to /tmp/table.json
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _write_raw_to:
+
+:write-raw-to *\[--view={log,db}\]* *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  In the log view, write the original log file content of the marked messages to the file.  In the DB view, the contents of the cells are written to the output file.
+
+  **Parameters**
+    * **--view={log,db}** --- The view to use as the source of data
+    * **--anonymize** --- Anonymize the lines
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write the marked lines in the log view to /tmp/table.txt:
+
+    .. code-block::  lnav
+
+      :write-raw-to /tmp/table.txt
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _write_screen_to:
+
+:write-screen-to *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Write the displayed text or SQL results to the given file without any formatting
+
+  **Parameters**
+    * **--anonymize** --- Anonymize the lines
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write only the displayed text to /tmp/table.txt:
+
+    .. code-block::  lnav
+
+      :write-screen-to /tmp/table.txt
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`, :ref:`write_view_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _write_to:
+
+:write-to *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Overwrite the given file with any marked lines in the current view
+
+  **Parameters**
+    * **--anonymize** --- Anonymize the lines
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write marked lines to the file /tmp/interesting-lines.txt:
+
+    .. code-block::  lnav
+
+      :write-to /tmp/interesting-lines.txt
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_view_to`, :ref:`write_view_to`
+
+----
+
+
+.. _write_view_to:
+
+:write-view-to *\[--anonymize\]* *path*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Write the text in the top view to the given file without any formatting
+
+  **Parameters**
+    * **--anonymize** --- Anonymize the lines
+    * **path\*** --- The path to the file to write
+
+  **Examples**
+    To write the top view to /tmp/table.txt:
+
+    .. code-block::  lnav
+
+      :write-view-to /tmp/table.txt
+
+  **See Also**
+    :ref:`alt_msg`, :ref:`append_to`, :ref:`create_logline_table`, :ref:`create_search_table`, :ref:`echo`, :ref:`echo`, :ref:`echoln`, :ref:`eval`, :ref:`export_session_to`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`rebuild`, :ref:`redirect_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_to`
+
+----
+
+
+.. _zoom_to:
+
+:zoom-to *zoom-level*
+^^^^^^^^^^^^^^^^^^^^^
+
+  Zoom the histogram view to the given level
+
+  **Parameters**
+    * **zoom-level\*** --- The zoom level
+
+  **Examples**
+    To set the zoom level to '1-week':
+
+    .. code-block::  lnav
+
+      :zoom-to 1-week
+
+
+----
+
diff --git a/src/internals/sql-ref.rst b/src/internals/sql-ref.rst
new file mode 100644
index 0000000..791aebb
--- /dev/null
+++ b/src/internals/sql-ref.rst
@@ -0,0 +1,3850 @@
+
+.. _infix_between_and:
+
+expr *\[NOT\]* BETWEEN *low* AND *hi*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Test if an expression is between two values.
+
+  **Parameters**
+    * **low\*** --- The low point
+    * **hi\*** --- The high point
+
+  **Examples**
+    To check if 3 is between 5 and 10:
+
+    .. code-block::  custsqlite
+
+      ;SELECT 3 BETWEEN 5 AND 10
+      0
+
+    To check if 10 is between 5 and 10:
+
+    .. code-block::  custsqlite
+
+      ;SELECT 10 BETWEEN 5 AND 10
+      1
+
+
+----
+
+
+.. _attach:
+
+ATTACH DATABASE *filename* AS *schema-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Attach a database file to the current connection.
+
+  **Parameters**
+    * **filename\*** --- The path to the database file.
+    * **schema-name\*** --- The prefix for tables in this database.
+
+  **Examples**
+    To attach the database file '/tmp/customers.db' with the name customers:
+
+    .. code-block::  custsqlite
+
+      ;ATTACH DATABASE '/tmp/customers.db' AS customers
+
+
+----
+
+
+.. _create_view:
+
+CREATE *\[TEMP\]* VIEW  *\[IF NOT EXISTS\]* *\[schema-name.\]* *view-name* AS *select-stmt*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Assign a name to a SELECT statement
+
+  **Parameters**
+    * **IF NOT EXISTS** --- Do not create the view if it already exists
+    * **schema-name.** --- The database to create the view in
+    * **view-name\*** --- The name of the view
+    * **select-stmt\*** --- The SELECT statement the view represents
+
+
+----
+
+
+.. _create_table:
+
+CREATE *\[TEMP\]* TABLE  *\[IF NOT EXISTS\]* *\[schema-name.\]* *table-name* AS *select-stmt*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Create a table
+
+
+----
+
+
+.. _with_recursive:
+
+WITH RECURSIVE  *cte-table-name* AS *select-stmt*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Create a temporary view that exists only for the duration of a SQL statement.
+
+  **Parameters**
+    * **cte-table-name\*** --- The name for the temporary table.
+    * **select-stmt\*** --- The SELECT statement used to populate the temporary table.
+
+
+----
+
+
+.. _cast:
+
+CAST(*expr* AS *type-name*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Convert the value of the given expression to a different storage class specified by type-name.
+
+  **Parameters**
+    * **expr\*** --- The value to convert.
+    * **type-name\*** --- The name of the type to convert to.
+
+  **Examples**
+    To cast the value 1.23 as an integer:
+
+    .. code-block::  custsqlite
+
+      ;SELECT CAST(1.23 AS INTEGER)
+      1
+
+
+----
+
+
+.. _case_end:
+
+CASE *\[base-expr\]* WHEN *cmp-expr* ELSE *\[else-expr\]* END 
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Evaluate a series of expressions in order until one evaluates to true and then return it's result.  Similar to an IF-THEN-ELSE construct in other languages.
+
+  **Parameters**
+    * **base-expr** --- The base expression that is used for comparison in the branches
+    * **cmp-expr** --- The expression to test if this branch should be taken
+    * **else-expr** --- The result of this CASE if no branches matched.
+
+  **Examples**
+    To evaluate the number one and return the string 'one':
+
+    .. code-block::  custsqlite
+
+      ;SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
+      one
+
+
+----
+
+
+.. _infix_collate:
+
+expr COLLATE *collation-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Assign a collating sequence to the expression.
+
+  **Parameters**
+    * **collation-name\*** --- The name of the collator.
+
+  **Examples**
+    To change the collation method for string comparisons:
+
+    .. code-block::  custsqlite
+
+      ;SELECT ('a2' < 'a10'), ('a2' < 'a10' COLLATE naturalnocase)
+      ('a2' < 'a10') ('a2' < 'a10' COLLATE naturalnocase) 
+                   0                                    1 
+
+
+----
+
+
+.. _detach:
+
+DETACH DATABASE *schema-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Detach a database from the current connection.
+
+  **Parameters**
+    * **schema-name\*** --- The prefix for tables in this database.
+
+  **Examples**
+    To detach the database named 'customers':
+
+    .. code-block::  custsqlite
+
+      ;DETACH DATABASE customers
+
+
+----
+
+
+.. _delete:
+
+DELETE FROM *table-name* WHERE *\[cond\]*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Delete rows from a table
+
+  **Parameters**
+    * **table-name\*** --- The name of the table
+    * **cond** --- The conditions used to delete the rows.
+
+
+----
+
+
+.. _drop_index:
+
+DROP INDEX  *\[IF EXISTS\]* *\[schema-name.\]* *index-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Drop an index
+
+
+----
+
+
+.. _drop_table:
+
+DROP TABLE  *\[IF EXISTS\]* *\[schema-name.\]* *table-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Drop a table
+
+
+----
+
+
+.. _drop_view:
+
+DROP VIEW  *\[IF EXISTS\]* *\[schema-name.\]* *view-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Drop a view
+
+
+----
+
+
+.. _drop_trigger:
+
+DROP TRIGGER  *\[IF EXISTS\]* *\[schema-name.\]* *trigger-name*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Drop a trigger
+
+
+----
+
+
+.. _infix_glob:
+
+expr *\[NOT\]* GLOB *pattern*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Match an expression against a glob pattern.
+
+  **Parameters**
+    * **pattern\*** --- The glob pattern to match against.
+
+  **Examples**
+    To check if a value matches the pattern '*.log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT 'foobar.log' GLOB '*.log'
+      1
+
+
+----
+
+
+.. _infix_like:
+
+expr *\[NOT\]* LIKE *pattern*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Match an expression against a text pattern.
+
+  **Parameters**
+    * **pattern\*** --- The pattern to match against.
+
+  **Examples**
+    To check if a value matches the pattern 'Hello, %!':
+
+    .. code-block::  custsqlite
+
+      ;SELECT 'Hello, World!' LIKE 'Hello, %!'
+      1
+
+
+----
+
+
+.. _infix_regexp:
+
+expr *\[NOT\]* REGEXP *pattern*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Match an expression against a regular expression.
+
+  **Parameters**
+    * **pattern\*** --- The regular expression to match against.
+
+  **Examples**
+    To check if a value matches the pattern 'file-\d+':
+
+    .. code-block::  custsqlite
+
+      ;SELECT 'file-23' REGEXP 'file-\d+'
+      1
+
+
+----
+
+
+.. _select:
+
+SELECT *result-column* FROM *table* WHERE *\[cond\]* GROUP BY *grouping-expr* ORDER BY *ordering-term* LIMIT *limit-expr*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Query the database and return zero or more rows of data.
+
+  **Parameters**
+    * **result-column** --- The expression used to generate a result for this column.
+    * **table** --- The table(s) to query for data
+    * **cond** --- The conditions used to select the rows to return.
+    * **grouping-expr** --- The expression to use when grouping rows.
+    * **ordering-term** --- The values to use when ordering the result set.
+    * **limit-expr** --- The maximum number of rows to return.
+
+  **Examples**
+    To select all of the columns from the table 'syslog_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT * FROM syslog_log
+
+
+----
+
+
+.. _insert_into:
+
+INSERT INTO  *\[schema-name.\]* *table-name* *column-name* VALUES *expr*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Insert rows into a table
+
+  **Examples**
+    To insert the pair containing 'MSG' and 'HELLO, WORLD!' into the 'environ' table:
+
+    .. code-block::  custsqlite
+
+      ;INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
+
+
+----
+
+
+.. _over:
+
+OVER(*\[base-window-name\]* PARTITION BY *expr* ORDER BY *expr*, *\[frame-spec\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Executes the preceding function over a window
+
+  **Parameters**
+    * **base-window-name** --- The name of the window definition
+    * **expr** --- The values to use for partitioning
+    * **expr** --- The values used to order the rows in the window
+    * **frame-spec** --- Determines which output rows are read by an aggregate window function
+
+
+----
+
+
+.. _over:
+
+OVER *window-name*
+^^^^^^^^^^^^^^^^^^
+
+  Executes the preceding function over a window
+
+  **Parameters**
+    * **window-name\*** --- The name of the window definition
+
+
+----
+
+
+.. _update_set:
+
+UPDATE *table* SET  *column-name* WHERE *\[cond\]*
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Modify a subset of values in zero or more rows of the given table
+
+  **Parameters**
+    * **table\*** --- The table to update
+    * **column-name** --- The columns in the table to update.
+    * **cond** --- The condition used to determine whether a row should be updated.
+
+  **Examples**
+    To mark the syslog message at line 40:
+
+    .. code-block::  custsqlite
+
+      ;UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
+
+
+----
+
+
+.. _abs:
+
+abs(*x*)
+^^^^^^^^
+
+  Return the absolute value of the argument
+
+  **Parameters**
+    * **x\*** --- The number to convert
+
+  **Examples**
+    To get the absolute value of -1:
+
+    .. code-block::  custsqlite
+
+      ;SELECT abs(-1)
+      1
+
+  **See Also**
+    :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _acos:
+
+acos(*num*)
+^^^^^^^^^^^
+
+  Returns the arccosine of a number, in radians
+
+  **Parameters**
+    * **num\*** --- A cosine value that is between -1 and 1
+
+  **Examples**
+    To get the arccosine of 0.2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT acos(0.2)
+      1.3694384060045657
+
+  **See Also**
+    :ref:`abs`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _acosh:
+
+acosh(*num*)
+^^^^^^^^^^^^
+
+  Returns the hyperbolic arccosine of a number
+
+  **Parameters**
+    * **num\*** --- A number that is one or more
+
+  **Examples**
+    To get the hyperbolic arccosine of 1.2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT acosh(1.2)
+      0.6223625037147786
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _anonymize:
+
+anonymize(*value*)
+^^^^^^^^^^^^^^^^^^
+
+  Replace identifying information with random values.
+
+  **Parameters**
+    * **value\*** --- The text to anonymize
+
+  **Examples**
+    To anonymize an IP address:
+
+    .. code-block::  custsqlite
+
+      ;SELECT anonymize('Hello, 192.168.1.2')
+      Aback, 10.0.0.1
+
+  **See Also**
+    :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _asin:
+
+asin(*num*)
+^^^^^^^^^^^
+
+  Returns the arcsine of a number, in radians
+
+  **Parameters**
+    * **num\*** --- A sine value that is between -1 and 1
+
+  **Examples**
+    To get the arcsine of 0.2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT asin(0.2)
+      0.2013579207903308
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _asinh:
+
+asinh(*num*)
+^^^^^^^^^^^^
+
+  Returns the hyperbolic arcsine of a number
+
+  **Parameters**
+    * **num\*** --- The number
+
+  **Examples**
+    To get the hyperbolic arcsine of 0.2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT asinh(0.2)
+      0.19869011034924142
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _atan:
+
+atan(*num*)
+^^^^^^^^^^^
+
+  Returns the arctangent of a number, in radians
+
+  **Parameters**
+    * **num\*** --- The number
+
+  **Examples**
+    To get the arctangent of 0.2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT atan(0.2)
+      0.19739555984988078
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _atan2:
+
+atan2(*y*, *x*)
+^^^^^^^^^^^^^^^
+
+  Returns the angle in the plane between the positive X axis and the ray from (0, 0) to the point (x, y)
+
+  **Parameters**
+    * **y\*** --- The y coordinate of the point
+    * **x\*** --- The x coordinate of the point
+
+  **Examples**
+    To get the angle, in degrees, for the point at (5, 5):
+
+    .. code-block::  custsqlite
+
+      ;SELECT degrees(atan2(5, 5))
+      45
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _atanh:
+
+atanh(*num*)
+^^^^^^^^^^^^
+
+  Returns the hyperbolic arctangent of a number
+
+  **Parameters**
+    * **num\*** --- The number
+
+  **Examples**
+    To get the hyperbolic arctangent of 0.2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT atanh(0.2)
+      0.2027325540540822
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _atn2:
+
+atn2(*y*, *x*)
+^^^^^^^^^^^^^^
+
+  Returns the angle in the plane between the positive X axis and the ray from (0, 0) to the point (x, y)
+
+  **Parameters**
+    * **y\*** --- The y coordinate of the point
+    * **x\*** --- The x coordinate of the point
+
+  **Examples**
+    To get the angle, in degrees, for the point at (5, 5):
+
+    .. code-block::  custsqlite
+
+      ;SELECT degrees(atn2(5, 5))
+      45
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _avg:
+
+avg(*X*)
+^^^^^^^^
+
+  Returns the average value of all non-NULL numbers within a group.
+
+  **Parameters**
+    * **X\*** --- The value to compute the average of.
+
+  **Examples**
+    To get the average of the column 'ex_duration' from the table 'lnav_example_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT avg(ex_duration) FROM lnav_example_log
+      4.25
+
+    To get the average of the column 'ex_duration' from the table 'lnav_example_log' when grouped by 'ex_procname':
+
+    .. code-block::  custsqlite
+
+      ;SELECT ex_procname, avg(ex_duration) FROM lnav_example_log GROUP BY ex_procname
+      ex_procname avg(ex_duration) 
+      gw                         5 
+      hw                         2 
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _basename:
+
+basename(*path*)
+^^^^^^^^^^^^^^^^
+
+  Extract the base portion of a pathname.
+
+  **Parameters**
+    * **path\*** --- The path
+
+  **Examples**
+    To get the base of a plain file name:
+
+    .. code-block::  custsqlite
+
+      ;SELECT basename('foobar')
+      foobar
+
+    To get the base of a path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT basename('foo/bar')
+      bar
+
+    To get the base of a directory:
+
+    .. code-block::  custsqlite
+
+      ;SELECT basename('foo/bar/')
+      bar
+
+    To get the base of an empty string:
+
+    .. code-block::  custsqlite
+
+      ;SELECT basename('')
+      .
+
+    To get the base of a Windows path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT basename('foo\bar')
+      bar
+
+    To get the base of the root directory:
+
+    .. code-block::  custsqlite
+
+      ;SELECT basename('/')
+      /
+
+  **See Also**
+    :ref:`dirname`, :ref:`joinpath`, :ref:`readlink`, :ref:`realpath`
+
+----
+
+
+.. _ceil:
+
+ceil(*num*)
+^^^^^^^^^^^
+
+  Returns the smallest integer that is not less than the argument
+
+  **Parameters**
+    * **num\*** --- The number to raise to the ceiling
+
+  **Examples**
+    To get the ceiling of 1.23:
+
+    .. code-block::  custsqlite
+
+      ;SELECT ceil(1.23)
+      2
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _changes:
+
+changes()
+^^^^^^^^^
+
+  The number of database rows that were changed, inserted, or deleted by the most recent statement.
+
+
+----
+
+
+.. _char:
+
+char(*X*)
+^^^^^^^^^
+
+  Returns a string composed of characters having the given unicode code point values
+
+  **Parameters**
+    * **X** --- The unicode code point values
+
+  **Examples**
+    To get a string with the code points 0x48 and 0x49:
+
+    .. code-block::  custsqlite
+
+      ;SELECT char(0x48, 0x49)
+      HI
+
+  **See Also**
+    :ref:`anonymize`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _charindex:
+
+charindex(*needle*, *haystack*, *\[start\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Finds the first occurrence of the needle within the haystack and returns the number of prior characters plus 1, or 0 if Y is nowhere found within X
+
+  **Parameters**
+    * **needle\*** --- The string to look for in the haystack
+    * **haystack\*** --- The string to search within
+    * **start** --- The one-based index within the haystack to start the search
+
+  **Examples**
+    To search for the string 'abc' within 'abcabc' and starting at position 2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT charindex('abc', 'abcabc', 2)
+      4
+
+    To search for the string 'abc' within 'abcdef' and starting at position 2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT charindex('abc', 'abcdef', 2)
+      0
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _coalesce:
+
+coalesce(*X*, *Y*)
+^^^^^^^^^^^^^^^^^^
+
+  Returns a copy of its first non-NULL argument, or NULL if all arguments are NULL
+
+  **Parameters**
+    * **X\*** --- A value to check for NULL-ness
+    * **Y** --- A value to check for NULL-ness
+
+  **Examples**
+    To get the first non-null value from three parameters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT coalesce(null, 0, null)
+      0
+
+
+----
+
+
+.. _count:
+
+count(*X*)
+^^^^^^^^^^
+
+  If the argument is '*', the total number of rows in the group is returned.  Otherwise, the number of times the argument is non-NULL.
+
+  **Parameters**
+    * **X\*** --- The value to count.
+
+  **Examples**
+    To get the count of the non-NULL rows of 'lnav_example_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT count(*) FROM lnav_example_log
+      4
+
+    To get the count of the non-NULL values of 'log_part' from 'lnav_example_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT count(log_part) FROM lnav_example_log
+      2
+
+
+----
+
+
+.. _cume_dist:
+
+cume_dist()
+^^^^^^^^^^^
+
+  Returns the cumulative distribution
+
+  **See Also**
+    :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _date:
+
+date(*timestring*, *modifier*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the date in this format: YYYY-MM-DD.
+
+  **Parameters**
+    * **timestring\*** --- The string to convert to a date.
+    * **modifier** --- A transformation that is applied to the value to the left.
+
+  **Examples**
+    To get the date portion of the timestamp '2017-01-02T03:04:05':
+
+    .. code-block::  custsqlite
+
+      ;SELECT date('2017-01-02T03:04:05')
+      2017-01-02
+
+    To get the date portion of the timestamp '2017-01-02T03:04:05' plus one day:
+
+    .. code-block::  custsqlite
+
+      ;SELECT date('2017-01-02T03:04:05', '+1 day')
+      2017-01-03
+
+    To get the date portion of the epoch timestamp 1491341842:
+
+    .. code-block::  custsqlite
+
+      ;SELECT date(1491341842, 'unixepoch')
+      2017-04-04
+
+  **See Also**
+    :ref:`datetime`, :ref:`humanize_duration`, :ref:`julianday`, :ref:`strftime`, :ref:`time`, :ref:`timediff`, :ref:`timeslice`
+
+----
+
+
+.. _datetime:
+
+datetime(*timestring*, *modifier*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the date and time in this format: YYYY-MM-DD HH:MM:SS.
+
+  **Parameters**
+    * **timestring\*** --- The string to convert to a date with time.
+    * **modifier** --- A transformation that is applied to the value to the left.
+
+  **Examples**
+    To get the date and time portion of the timestamp '2017-01-02T03:04:05':
+
+    .. code-block::  custsqlite
+
+      ;SELECT datetime('2017-01-02T03:04:05')
+      2017-01-02 03:04:05
+
+    To get the date and time portion of the timestamp '2017-01-02T03:04:05' plus one minute:
+
+    .. code-block::  custsqlite
+
+      ;SELECT datetime('2017-01-02T03:04:05', '+1 minute')
+      2017-01-02 03:05:05
+
+    To get the date and time portion of the epoch timestamp 1491341842:
+
+    .. code-block::  custsqlite
+
+      ;SELECT datetime(1491341842, 'unixepoch')
+      2017-04-04 21:37:22
+
+  **See Also**
+    :ref:`date`, :ref:`humanize_duration`, :ref:`julianday`, :ref:`strftime`, :ref:`time`, :ref:`timediff`, :ref:`timeslice`
+
+----
+
+
+.. _decode:
+
+decode(*value*, *algorithm*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Decode the value using the given algorithm
+
+  **Parameters**
+    * **value\*** --- The value to decode
+    * **algorithm\*** --- One of the following encoding algorithms: base64, hex, uri
+
+  **Examples**
+    To decode the URI-encoded string '%63%75%72%6c':
+
+    .. code-block::  custsqlite
+
+      ;SELECT decode('%63%75%72%6c', 'uri')
+      curl
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _degrees:
+
+degrees(*radians*)
+^^^^^^^^^^^^^^^^^^
+
+  Converts radians to degrees
+
+  **Parameters**
+    * **radians\*** --- The radians value to convert to degrees
+
+  **Examples**
+    To convert PI to degrees:
+
+    .. code-block::  custsqlite
+
+      ;SELECT degrees(pi())
+      180
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _dense_rank:
+
+dense_rank()
+^^^^^^^^^^^^
+
+  Returns the row_number() of the first peer in each group without gaps
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _dirname:
+
+dirname(*path*)
+^^^^^^^^^^^^^^^
+
+  Extract the directory portion of a pathname.
+
+  **Parameters**
+    * **path\*** --- The path
+
+  **Examples**
+    To get the directory of a relative file path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT dirname('foo/bar')
+      foo
+
+    To get the directory of an absolute file path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT dirname('/foo/bar')
+      /foo
+
+    To get the directory of a file in the root directory:
+
+    .. code-block::  custsqlite
+
+      ;SELECT dirname('/bar')
+      /
+
+    To get the directory of a Windows path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT dirname('foo\bar')
+      foo
+
+    To get the directory of an empty path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT dirname('')
+      .
+
+  **See Also**
+    :ref:`basename`, :ref:`joinpath`, :ref:`readlink`, :ref:`realpath`
+
+----
+
+
+.. _echoln:
+
+echoln(*value*)
+^^^^^^^^^^^^^^^
+
+  Echo the argument to the current output file and return it
+
+  **Parameters**
+    * **value\*** --- The value to write to the current output file
+
+  **See Also**
+    :ref:`append_to`, :ref:`echo`, :ref:`export_session_to`, :ref:`pipe_line_to`, :ref:`pipe_to`, :ref:`redirect_to`, :ref:`write_csv_to`, :ref:`write_json_to`, :ref:`write_jsonlines_to`, :ref:`write_raw_to`, :ref:`write_screen_to`, :ref:`write_table_to`, :ref:`write_to`, :ref:`write_view_to`
+
+----
+
+
+.. _encode:
+
+encode(*value*, *algorithm*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Encode the value using the given algorithm
+
+  **Parameters**
+    * **value\*** --- The value to encode
+    * **algorithm\*** --- One of the following encoding algorithms: base64, hex, uri
+
+  **Examples**
+    To base64-encode 'Hello, World!':
+
+    .. code-block::  custsqlite
+
+      ;SELECT encode('Hello, World!', 'base64')
+      SGVsbG8sIFdvcmxkIQ==
+
+    To hex-encode 'Hello, World!':
+
+    .. code-block::  custsqlite
+
+      ;SELECT encode('Hello, World!', 'hex')
+      48656c6c6f2c20576f726c6421
+
+    To URI-encode 'Hello, World!':
+
+    .. code-block::  custsqlite
+
+      ;SELECT encode('Hello, World!', 'uri')
+      Hello%2C%20World%21
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _endswith:
+
+endswith(*str*, *suffix*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Test if a string ends with the given suffix
+
+  **Parameters**
+    * **str\*** --- The string to test
+    * **suffix\*** --- The suffix to check in the string
+
+  **Examples**
+    To test if the string 'notbad.jpg' ends with '.jpg':
+
+    .. code-block::  custsqlite
+
+      ;SELECT endswith('notbad.jpg', '.jpg')
+      1
+
+    To test if the string 'notbad.png' starts with '.jpg':
+
+    .. code-block::  custsqlite
+
+      ;SELECT endswith('notbad.png', '.jpg')
+      0
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _exp:
+
+exp(*x*)
+^^^^^^^^
+
+  Returns the value of e raised to the power of x
+
+  **Parameters**
+    * **x\*** --- The exponent
+
+  **Examples**
+    To raise e to 2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT exp(2)
+      7.38905609893065
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _extract:
+
+extract(*str*)
+^^^^^^^^^^^^^^
+
+  Automatically Parse and extract data from a string
+
+  **Parameters**
+    * **str\*** --- The string to parse
+
+  **Examples**
+    To extract key/value pairs from a string:
+
+    .. code-block::  custsqlite
+
+      ;SELECT extract('foo=1 bar=2 name="Rolo Tomassi"')
+      {"foo":1,"bar":2,"name":"Rolo Tomassi"}
+
+    To extract columnar data from a string:
+
+    .. code-block::  custsqlite
+
+      ;SELECT extract('1.0 abc 2.0')
+      {"col_0":1.0,"col_1":2.0}
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _first_value:
+
+first_value(*expr*)
+^^^^^^^^^^^^^^^^^^^
+
+  Returns the result of evaluating the expression against the first row in the window frame.
+
+  **Parameters**
+    * **expr\*** --- The expression to execute over the first row
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _floor:
+
+floor(*num*)
+^^^^^^^^^^^^
+
+  Returns the largest integer that is not greater than the argument
+
+  **Parameters**
+    * **num\*** --- The number to lower to the floor
+
+  **Examples**
+    To get the floor of 1.23:
+
+    .. code-block::  custsqlite
+
+      ;SELECT floor(1.23)
+      1
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _generate_series:
+
+generate_series(*start*, *stop*, *\[step\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  A table-valued-function that returns the whole numbers between a lower and upper bound, inclusive
+
+  **Parameters**
+    * **start\*** --- The starting point of the series
+    * **stop\*** --- The stopping point of the series
+    * **step** --- The increment between each value
+
+  **Examples**
+    To generate the numbers in the range [10, 14]:
+
+    .. code-block::  custsqlite
+
+      ;SELECT value FROM generate_series(10, 14)
+      value 
+         10 
+         11 
+         12 
+         13 
+         14 
+
+    To generate every other number in the range [10, 14]:
+
+    .. code-block::  custsqlite
+
+      ;SELECT value FROM generate_series(10, 14, 2)
+      value 
+         10 
+         12 
+         14 
+
+    To count down from five to 1:
+
+    .. code-block::  custsqlite
+
+      ;SELECT value FROM generate_series(1, 5, -1)
+      value 
+          5 
+          4 
+          3 
+          2 
+          1 
+
+
+----
+
+
+.. _gethostbyaddr:
+
+gethostbyaddr(*hostname*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Get the hostname for the given IP address
+
+  **Parameters**
+    * **hostname\*** --- The IP address to lookup.
+
+  **Examples**
+    To get the hostname for the IP '127.0.0.1':
+
+    .. code-block::  custsqlite
+
+      ;SELECT gethostbyaddr('127.0.0.1')
+      localhost
+
+  **See Also**
+    :ref:`gethostbyname`
+
+----
+
+
+.. _gethostbyname:
+
+gethostbyname(*hostname*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Get the IP address for the given hostname
+
+  **Parameters**
+    * **hostname\*** --- The DNS hostname to lookup.
+
+  **Examples**
+    To get the IP address for 'localhost':
+
+    .. code-block::  custsqlite
+
+      ;SELECT gethostbyname('localhost')
+      127.0.0.1
+
+  **See Also**
+    :ref:`gethostbyaddr`
+
+----
+
+
+.. _glob:
+
+glob(*pattern*, *str*)
+^^^^^^^^^^^^^^^^^^^^^^
+
+  Match a string against Unix glob pattern
+
+  **Parameters**
+    * **pattern\*** --- The glob pattern
+    * **str\*** --- The string to match
+
+  **Examples**
+    To test if the string 'abc' matches the glob 'a*':
+
+    .. code-block::  custsqlite
+
+      ;SELECT glob('a*', 'abc')
+      1
+
+
+----
+
+
+.. _group_concat:
+
+group_concat(*X*, *\[sep\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a string which is the concatenation of all non-NULL values of X separated by a comma or the given separator.
+
+  **Parameters**
+    * **X\*** --- The value to concatenate.
+    * **sep** --- The separator to place between the values.
+
+  **Examples**
+    To concatenate the values of the column 'ex_procname' from the table 'lnav_example_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT group_concat(ex_procname) FROM lnav_example_log
+      hw,gw,gw,gw
+
+    To join the values of the column 'ex_procname' using the string ', ':
+
+    .. code-block::  custsqlite
+
+      ;SELECT group_concat(ex_procname, ', ') FROM lnav_example_log
+      hw, gw, gw, gw
+
+    To concatenate the distinct values of the column 'ex_procname' from the table 'lnav_example_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT group_concat(DISTINCT ex_procname) FROM lnav_example_log
+      hw,gw
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _group_spooky_hash_agg:
+
+group_spooky_hash(*str*)
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Compute the hash value for the given arguments
+
+  **Parameters**
+    * **str** --- The string to hash
+
+  **Examples**
+    To produce a hash of all of the values of 'column1':
+
+    .. code-block::  custsqlite
+
+      ;SELECT group_spooky_hash(column1) FROM (VALUES ('abc'), ('123'))
+      4e7a190aead058cb123c94290f29c34a
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _gunzip:
+
+gunzip(*b*)
+^^^^^^^^^^^
+
+  Decompress a gzip file
+
+  **Parameters**
+    * **b** --- The blob to decompress
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _gzip:
+
+gzip(*value*)
+^^^^^^^^^^^^^
+
+  Compress a string into a gzip file
+
+  **Parameters**
+    * **value** --- The value to compress
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _hex:
+
+hex(*X*)
+^^^^^^^^
+
+  Returns a string which is the upper-case hexadecimal rendering of the content of its argument.
+
+  **Parameters**
+    * **X\*** --- The blob to convert to hexadecimal
+
+  **Examples**
+    To get the hexadecimal rendering of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT hex('abc')
+      616263
+
+
+----
+
+
+.. _humanize_duration:
+
+humanize_duration(*secs*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Format the given seconds value as an abbreviated duration string
+
+  **Parameters**
+    * **secs\*** --- The duration in seconds
+
+  **Examples**
+    To format a duration:
+
+    .. code-block::  custsqlite
+
+      ;SELECT humanize_duration(15 * 60)
+      15m0s
+
+    To format a sub-second value:
+
+    .. code-block::  custsqlite
+
+      ;SELECT humanize_duration(1.5)
+      1s500
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`date`, :ref:`datetime`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`julianday`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`strftime`, :ref:`substr`, :ref:`time`, :ref:`timediff`, :ref:`timeslice`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _humanize_file_size:
+
+humanize_file_size(*value*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Format the given file size as a human-friendly string
+
+  **Parameters**
+    * **value\*** --- The file size to format
+
+  **Examples**
+    To format an amount:
+
+    .. code-block::  custsqlite
+
+      ;SELECT humanize_file_size(10 * 1024 * 1024)
+      10.0MB
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _ifnull:
+
+ifnull(*X*, *Y*)
+^^^^^^^^^^^^^^^^
+
+  Returns a copy of its first non-NULL argument, or NULL if both arguments are NULL
+
+  **Parameters**
+    * **X\*** --- A value to check for NULL-ness
+    * **Y\*** --- A value to check for NULL-ness
+
+  **Examples**
+    To get the first non-null value between null and zero:
+
+    .. code-block::  custsqlite
+
+      ;SELECT ifnull(null, 0)
+      0
+
+
+----
+
+
+.. _instr:
+
+instr(*haystack*, *needle*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Finds the first occurrence of the needle within the haystack and returns the number of prior characters plus 1, or 0 if the needle was not found
+
+  **Parameters**
+    * **haystack\*** --- The string to search within
+    * **needle\*** --- The string to look for in the haystack
+
+  **Examples**
+    To test get the position of 'b' in the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT instr('abc', 'b')
+      2
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _jget:
+
+jget(*json*, *ptr*, *\[default\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Get the value from a JSON object using a JSON-Pointer.
+
+  **Parameters**
+    * **json\*** --- The JSON object to query.
+    * **ptr\*** --- The JSON-Pointer to lookup in the object.
+    * **default** --- The default value if the value was not found
+
+  **Examples**
+    To get the root of a JSON value:
+
+    .. code-block::  custsqlite
+
+      ;SELECT jget('1', '')
+      1
+
+    To get the property named 'b' in a JSON object:
+
+    .. code-block::  custsqlite
+
+      ;SELECT jget('{ "a": 1, "b": 2 }', '/b')
+      2
+
+    To get the 'msg' property and return a default if it does not exist:
+
+    .. code-block::  custsqlite
+
+      ;SELECT jget(null, '/msg', 'Hello')
+      Hello
+
+  **See Also**
+    :ref:`json_concat`, :ref:`json_contains`, :ref:`json_group_array`, :ref:`json_group_object`, :ref:`yaml_to_json`
+
+----
+
+
+.. _joinpath:
+
+joinpath(*path*)
+^^^^^^^^^^^^^^^^
+
+  Join components of a path together.
+
+  **Parameters**
+    * **path** --- One or more path components to join together.  If an argument starts with a forward or backward slash, it will be considered an absolute path and any preceding elements will be ignored.
+
+  **Examples**
+    To join a directory and file name into a relative path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT joinpath('foo', 'bar')
+      foo/bar
+
+    To join an empty component with other names into a relative path:
+
+    .. code-block::  custsqlite
+
+      ;SELECT joinpath('', 'foo', 'bar')
+      foo/bar
+
+    To create an absolute path with two path components:
+
+    .. code-block::  custsqlite
+
+      ;SELECT joinpath('/', 'foo', 'bar')
+      /foo/bar
+
+    To create an absolute path from a path component that starts with a forward slash:
+
+    .. code-block::  custsqlite
+
+      ;SELECT joinpath('/', 'foo', '/bar')
+      /bar
+
+  **See Also**
+    :ref:`basename`, :ref:`dirname`, :ref:`readlink`, :ref:`realpath`
+
+----
+
+
+.. _json_concat:
+
+json_concat(*json*, *value*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns an array with the given values concatenated onto the end.  If the initial value is null, the result will be an array with the given elements.  If the initial value is an array, the result will be an array with the given values at the end.  If the initial value is not null or an array, the result will be an array with two elements: the initial value and the given value.
+
+  **Parameters**
+    * **json\*** --- The initial JSON value.
+    * **value** --- The value(s) to add to the end of the array.
+
+  **Examples**
+    To append the number 4 to null:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_concat(NULL, 4)
+      [4]
+
+    To append 4 and 5 to the array [1, 2, 3]:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_concat('[1, 2, 3]', 4, 5)
+      [1,2,3,4,5]
+
+    To concatenate two arrays together:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_concat('[1, 2, 3]', json('[4, 5]'))
+      [1,2,3,4,5]
+
+  **See Also**
+    :ref:`jget`, :ref:`json_contains`, :ref:`json_group_array`, :ref:`json_group_object`, :ref:`yaml_to_json`
+
+----
+
+
+.. _json_contains:
+
+json_contains(*json*, *value*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Check if a JSON value contains the given element.
+
+  **Parameters**
+    * **json\*** --- The JSON value to query.
+    * **value\*** --- The value to look for in the first argument
+
+  **Examples**
+    To test if a JSON array contains the number 4:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_contains('[1, 2, 3]', 4)
+      0
+
+    To test if a JSON array contains the string 'def':
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_contains('["abc", "def"]', 'def')
+      1
+
+  **See Also**
+    :ref:`jget`, :ref:`json_concat`, :ref:`json_group_array`, :ref:`json_group_object`, :ref:`yaml_to_json`
+
+----
+
+
+.. _json_group_array:
+
+json_group_array(*value*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Collect the given values from a query into a JSON array
+
+  **Parameters**
+    * **value** --- The values to append to the array
+
+  **Examples**
+    To create an array from arguments:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_group_array('one', 2, 3.4)
+      ["one",2,3.3999999999999999112]
+
+    To create an array from a column of values:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_group_array(column1) FROM (VALUES (1), (2), (3))
+      [1,2,3]
+
+  **See Also**
+    :ref:`jget`, :ref:`json_concat`, :ref:`json_contains`, :ref:`json_group_object`, :ref:`yaml_to_json`
+
+----
+
+
+.. _json_group_object:
+
+json_group_object(*name*, *value*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Collect the given values from a query into a JSON object
+
+  **Parameters**
+    * **name\*** --- The property name for the value
+    * **value** --- The value to add to the object
+
+  **Examples**
+    To create an object from arguments:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_group_object('a', 1, 'b', 2)
+      {"a":1,"b":2}
+
+    To create an object from a pair of columns:
+
+    .. code-block::  custsqlite
+
+      ;SELECT json_group_object(column1, column2) FROM (VALUES ('a', 1), ('b', 2))
+      {"a":1,"b":2}
+
+  **See Also**
+    :ref:`jget`, :ref:`json_concat`, :ref:`json_contains`, :ref:`json_group_array`, :ref:`yaml_to_json`
+
+----
+
+
+.. _julianday:
+
+julianday(*timestring*, *modifier*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the number of days since noon in Greenwich on November 24, 4714 B.C.
+
+  **Parameters**
+    * **timestring\*** --- The string to convert to a date with time.
+    * **modifier** --- A transformation that is applied to the value to the left.
+
+  **Examples**
+    To get the julian day from the timestamp '2017-01-02T03:04:05':
+
+    .. code-block::  custsqlite
+
+      ;SELECT julianday('2017-01-02T03:04:05')
+      2457755.627835648
+
+    To get the julian day from the timestamp '2017-01-02T03:04:05' plus one minute:
+
+    .. code-block::  custsqlite
+
+      ;SELECT julianday('2017-01-02T03:04:05', '+1 minute')
+      2457755.6285300925
+
+    To get the julian day from the timestamp 1491341842:
+
+    .. code-block::  custsqlite
+
+      ;SELECT julianday(1491341842, 'unixepoch')
+      2457848.400949074
+
+  **See Also**
+    :ref:`date`, :ref:`datetime`, :ref:`humanize_duration`, :ref:`strftime`, :ref:`time`, :ref:`timediff`, :ref:`timeslice`
+
+----
+
+
+.. _lag:
+
+lag(*expr*, *\[offset\]*, *\[default\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the result of evaluating the expression against the previous row in the partition.
+
+  **Parameters**
+    * **expr\*** --- The expression to execute over the previous row
+    * **offset** --- The offset from the current row in the partition
+    * **default** --- The default value if the previous row does not exist instead of NULL
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _last_insert_rowid:
+
+last_insert_rowid()
+^^^^^^^^^^^^^^^^^^^
+
+  Returns the ROWID of the last row insert from the database connection which invoked the function
+
+
+----
+
+
+.. _last_value:
+
+last_value(*expr*)
+^^^^^^^^^^^^^^^^^^
+
+  Returns the result of evaluating the expression against the last row in the window frame.
+
+  **Parameters**
+    * **expr\*** --- The expression to execute over the last row
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _lead:
+
+lead(*expr*, *\[offset\]*, *\[default\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the result of evaluating the expression against the next row in the partition.
+
+  **Parameters**
+    * **expr\*** --- The expression to execute over the next row
+    * **offset** --- The offset from the current row in the partition
+    * **default** --- The default value if the next row does not exist instead of NULL
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _leftstr:
+
+leftstr(*str*, *N*)
+^^^^^^^^^^^^^^^^^^^
+
+  Returns the N leftmost (UTF-8) characters in the given string.
+
+  **Parameters**
+    * **str\*** --- The string to return subset.
+    * **N\*** --- The number of characters from the left side of the string to return.
+
+  **Examples**
+    To get the first character of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT leftstr('abc', 1)
+      a
+
+    To get the first ten characters of a string, regardless of size:
+
+    .. code-block::  custsqlite
+
+      ;SELECT leftstr('abc', 10)
+      abc
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _length:
+
+length(*str*)
+^^^^^^^^^^^^^
+
+  Returns the number of characters (not bytes) in the given string prior to the first NUL character
+
+  **Parameters**
+    * **str\*** --- The string to determine the length of
+
+  **Examples**
+    To get the length of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT length('abc')
+      3
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _like:
+
+like(*pattern*, *str*, *\[escape\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Match a string against a pattern
+
+  **Parameters**
+    * **pattern\*** --- The pattern to match.  A percent symbol (%) will match zero or more characters and an underscore (_) will match a single character.
+    * **str\*** --- The string to match
+    * **escape** --- The escape character that can be used to prefix a literal percent or underscore in the pattern.
+
+  **Examples**
+    To test if the string 'aabcc' contains the letter 'b':
+
+    .. code-block::  custsqlite
+
+      ;SELECT like('%b%', 'aabcc')
+      1
+
+    To test if the string 'aab%' ends with 'b%':
+
+    .. code-block::  custsqlite
+
+      ;SELECT like('%b:%', 'aab%', ':')
+      1
+
+
+----
+
+
+.. _likelihood:
+
+likelihood(*value*, *probability*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Provides a hint to the query planner that the first argument is a boolean that is true with the given probability
+
+  **Parameters**
+    * **value\*** --- The boolean value to return
+    * **probability\*** --- A floating point constant between 0.0 and 1.0
+
+
+----
+
+
+.. _likely:
+
+likely(*value*)
+^^^^^^^^^^^^^^^
+
+  Short-hand for likelihood(X,0.9375)
+
+  **Parameters**
+    * **value\*** --- The boolean value to return
+
+
+----
+
+
+.. _lnav_top_file:
+
+lnav_top_file()
+^^^^^^^^^^^^^^^
+
+  Return the name of the file that the top line in the current view came from.
+
+
+----
+
+
+.. _lnav_version:
+
+lnav_version()
+^^^^^^^^^^^^^^
+
+  Return the current version of lnav
+
+
+----
+
+
+.. _load_extension:
+
+load_extension(*path*, *\[entry-point\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Loads SQLite extensions out of the given shared library file using the given entry point.
+
+  **Parameters**
+    * **path\*** --- The path to the shared library containing the extension.
+
+
+----
+
+
+.. _log:
+
+log(*x*)
+^^^^^^^^
+
+  Returns the natural logarithm of x
+
+  **Parameters**
+    * **x\*** --- The number
+
+  **Examples**
+    To get the natual logarithm of 8:
+
+    .. code-block::  custsqlite
+
+      ;SELECT log(8)
+      2.0794415416798357
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _log10:
+
+log10(*x*)
+^^^^^^^^^^
+
+  Returns the base-10 logarithm of X
+
+  **Parameters**
+    * **x\*** --- The number
+
+  **Examples**
+    To get the logarithm of 100:
+
+    .. code-block::  custsqlite
+
+      ;SELECT log10(100)
+      2
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _log_top_datetime:
+
+log_top_datetime()
+^^^^^^^^^^^^^^^^^^
+
+  Return the timestamp of the line at the top of the log view.
+
+
+----
+
+
+.. _log_top_line:
+
+log_top_line()
+^^^^^^^^^^^^^^
+
+  Return the line number at the top of the log view.
+
+
+----
+
+
+.. _logfmt2json:
+
+logfmt2json(*str*)
+^^^^^^^^^^^^^^^^^^
+
+  Convert a logfmt-encoded string into JSON
+
+  **Parameters**
+    * **str\*** --- The logfmt message to parse
+
+  **Examples**
+    To extract key/value pairs from a log message:
+
+    .. code-block::  custsqlite
+
+      ;SELECT logfmt2json('foo=1 bar=2 name="Rolo Tomassi"')
+      {"foo":1,"bar":2,"name":"Rolo Tomassi"}
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _lower:
+
+lower(*str*)
+^^^^^^^^^^^^
+
+  Returns a copy of the given string with all ASCII characters converted to lower case.
+
+  **Parameters**
+    * **str\*** --- The string to convert.
+
+  **Examples**
+    To lowercase the string 'AbC':
+
+    .. code-block::  custsqlite
+
+      ;SELECT lower('AbC')
+      abc
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _ltrim:
+
+ltrim(*str*, *\[chars\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a string formed by removing any and all characters that appear in the second argument from the left side of the first.
+
+  **Parameters**
+    * **str\*** --- The string to trim characters from the left side
+    * **chars** --- The characters to trim.  Defaults to spaces.
+
+  **Examples**
+    To trim the leading space characters from the string '   abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT ltrim('   abc')
+      abc
+
+    To trim the characters 'a' or 'b' from the left side of the string 'aaaabbbc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT ltrim('aaaabbbc', 'ab')
+      c
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _max:
+
+max(*X*)
+^^^^^^^^
+
+  Returns the argument with the maximum value, or return NULL if any argument is NULL.
+
+  **Parameters**
+    * **X** --- The numbers to find the maximum of.  If only one argument is given, this function operates as an aggregate.
+
+  **Examples**
+    To get the largest value from the parameters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT max(2, 1, 3)
+      3
+
+    To get the largest value from an aggregate:
+
+    .. code-block::  custsqlite
+
+      ;SELECT max(status) FROM http_status_codes
+      511
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _min:
+
+min(*X*)
+^^^^^^^^
+
+  Returns the argument with the minimum value, or return NULL if any argument is NULL.
+
+  **Parameters**
+    * **X** --- The numbers to find the minimum of.  If only one argument is given, this function operates as an aggregate.
+
+  **Examples**
+    To get the smallest value from the parameters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT min(2, 1, 3)
+      1
+
+    To get the smallest value from an aggregate:
+
+    .. code-block::  custsqlite
+
+      ;SELECT min(status) FROM http_status_codes
+      100
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _nth_value:
+
+nth_value(*expr*, *N*)
+^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the result of evaluating the expression against the nth row in the window frame.
+
+  **Parameters**
+    * **expr\*** --- The expression to execute over the nth row
+    * **N\*** --- The row number
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _ntile:
+
+ntile(*groups*)
+^^^^^^^^^^^^^^^
+
+  Returns the number of the group that the current row is a part of
+
+  **Parameters**
+    * **groups\*** --- The number of groups
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`percent_rank`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _nullif:
+
+nullif(*X*, *Y*)
+^^^^^^^^^^^^^^^^
+
+  Returns its first argument if the arguments are different and NULL if the arguments are the same.
+
+  **Parameters**
+    * **X\*** --- The first argument to compare.
+    * **Y\*** --- The argument to compare against the first.
+
+  **Examples**
+    To test if 1 is different from 1:
+
+    .. code-block::  custsqlite
+
+      ;SELECT nullif(1, 1)
+      <NULL>
+
+    To test if 1 is different from 2:
+
+    .. code-block::  custsqlite
+
+      ;SELECT nullif(1, 2)
+      1
+
+
+----
+
+
+.. _padc:
+
+padc(*str*, *len*)
+^^^^^^^^^^^^^^^^^^
+
+  Pad the given string with enough spaces to make it centered within the given length
+
+  **Parameters**
+    * **str\*** --- The string to pad
+    * **len\*** --- The minimum desired length of the output string
+
+  **Examples**
+    To pad the string 'abc' to a length of six characters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT padc('abc', 6) || 'def'
+       abc  def
+
+    To pad the string 'abcdef' to a length of eight characters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT padc('abcdef', 8) || 'ghi'
+       abcdef ghi
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _padl:
+
+padl(*str*, *len*)
+^^^^^^^^^^^^^^^^^^
+
+  Pad the given string with leading spaces until it reaches the desired length
+
+  **Parameters**
+    * **str\*** --- The string to pad
+    * **len\*** --- The minimum desired length of the output string
+
+  **Examples**
+    To pad the string 'abc' to a length of six characters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT padl('abc', 6)
+         abc
+
+    To pad the string 'abcdef' to a length of four characters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT padl('abcdef', 4)
+      abcdef
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _padr:
+
+padr(*str*, *len*)
+^^^^^^^^^^^^^^^^^^
+
+  Pad the given string with trailing spaces until it reaches the desired length
+
+  **Parameters**
+    * **str\*** --- The string to pad
+    * **len\*** --- The minimum desired length of the output string
+
+  **Examples**
+    To pad the string 'abc' to a length of six characters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT padr('abc', 6) || 'def'
+      abc   def
+
+    To pad the string 'abcdef' to a length of four characters:
+
+    .. code-block::  custsqlite
+
+      ;SELECT padr('abcdef', 4) || 'ghi'
+      abcdefghi
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _parse_url:
+
+parse_url(*url*)
+^^^^^^^^^^^^^^^^
+
+  Parse a URL and return the components in a JSON object. Limitations: not all URL schemes are supported and repeated query parameters are not captured.
+
+  **Parameters**
+    * **url\*** --- The URL to parse
+
+  **Examples**
+    To parse the URL 'https://example.com/search?q=hello%20world':
+
+    .. code-block::  custsqlite
+
+      ;SELECT parse_url('https://example.com/search?q=hello%20world')
+      {"scheme":"https","user":null,"password":null,"host":"example.com","port":null,"path":"/search","query":"q=hello%20world","parameters":{"q":"hello world"},"fragment":null}
+
+    To parse the URL 'https://alice@[fe80::14ff:4ee5:1215:2fb2]':
+
+    .. code-block::  custsqlite
+
+      ;SELECT parse_url('https://alice@[fe80::14ff:4ee5:1215:2fb2]')
+      {"scheme":"https","user":"alice","password":null,"host":"[fe80::14ff:4ee5:1215:2fb2]","port":null,"path":"/","query":null,"parameters":null,"fragment":null}
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _percent_rank:
+
+percent_rank()
+^^^^^^^^^^^^^^
+
+  Returns (rank - 1) / (partition-rows - 1)
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`rank`, :ref:`row_number`
+
+----
+
+
+.. _pi:
+
+pi()
+^^^^
+
+  Returns the value of PI
+
+  **Examples**
+    To get the value of PI:
+
+    .. code-block::  custsqlite
+
+      ;SELECT pi()
+      3.141592653589793
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _power:
+
+power(*base*, *exp*)
+^^^^^^^^^^^^^^^^^^^^
+
+  Returns the base to the given exponent
+
+  **Parameters**
+    * **base\*** --- The base number
+    * **exp\*** --- The exponent
+
+  **Examples**
+    To raise two to the power of three:
+
+    .. code-block::  custsqlite
+
+      ;SELECT power(2, 3)
+      8
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _printf:
+
+printf(*format*, *X*)
+^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a string with this functions arguments substituted into the given format.  Substitution points are specified using percent (%) options, much like the standard C printf() function.
+
+  **Parameters**
+    * **format\*** --- The format of the string to return.
+    * **X\*** --- The argument to substitute at a given position in the format.
+
+  **Examples**
+    To substitute 'World' into the string 'Hello, %s!':
+
+    .. code-block::  custsqlite
+
+      ;SELECT printf('Hello, %s!', 'World')
+      Hello, World!
+
+    To right-align 'small' in the string 'align:' with a column width of 10:
+
+    .. code-block::  custsqlite
+
+      ;SELECT printf('align: % 10s', 'small')
+      align:      small
+
+    To format 11 with a width of five characters and leading zeroes:
+
+    .. code-block::  custsqlite
+
+      ;SELECT printf('value: %05d', 11)
+      value: 00011
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _proper:
+
+proper(*str*)
+^^^^^^^^^^^^^
+
+  Capitalize the first character of words in the given string
+
+  **Parameters**
+    * **str\*** --- The string to capitalize.
+
+  **Examples**
+    To capitalize the words in the string 'hello, world!':
+
+    .. code-block::  custsqlite
+
+      ;SELECT proper('hello, world!')
+      Hello, World!
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _quote:
+
+quote(*X*)
+^^^^^^^^^^
+
+  Returns the text of an SQL literal which is the value of its argument suitable for inclusion into an SQL statement.
+
+  **Parameters**
+    * **X\*** --- The string to quote.
+
+  **Examples**
+    To quote the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT quote('abc')
+      'abc'
+
+    To quote the string 'abc'123':
+
+    .. code-block::  custsqlite
+
+      ;SELECT quote('abc''123')
+      'abc''123'
+
+
+----
+
+
+.. _radians:
+
+radians(*degrees*)
+^^^^^^^^^^^^^^^^^^
+
+  Converts degrees to radians
+
+  **Parameters**
+    * **degrees\*** --- The degrees value to convert to radians
+
+  **Examples**
+    To convert 180 degrees to radians:
+
+    .. code-block::  custsqlite
+
+      ;SELECT radians(180)
+      3.141592653589793
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _raise_error:
+
+raise_error(*msg*)
+^^^^^^^^^^^^^^^^^^
+
+  Raises an error with the given message when executed
+
+  **Parameters**
+    * **msg\*** --- The error message
+
+
+----
+
+
+.. _random:
+
+random()
+^^^^^^^^
+
+  Returns a pseudo-random integer between -9223372036854775808 and +9223372036854775807.
+
+
+----
+
+
+.. _randomblob:
+
+randomblob(*N*)
+^^^^^^^^^^^^^^^
+
+  Return an N-byte blob containing pseudo-random bytes.
+
+  **Parameters**
+    * **N\*** --- The size of the blob in bytes.
+
+
+----
+
+
+.. _rank:
+
+rank()
+^^^^^^
+
+  Returns the row_number() of the first peer in each group with gaps
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`row_number`
+
+----
+
+
+.. _readlink:
+
+readlink(*path*)
+^^^^^^^^^^^^^^^^
+
+  Read the target of a symbolic link.
+
+  **Parameters**
+    * **path\*** --- The path to the symbolic link.
+
+  **See Also**
+    :ref:`basename`, :ref:`dirname`, :ref:`joinpath`, :ref:`realpath`
+
+----
+
+
+.. _realpath:
+
+realpath(*path*)
+^^^^^^^^^^^^^^^^
+
+  Returns the resolved version of the given path, expanding symbolic links and resolving '.' and '..' references.
+
+  **Parameters**
+    * **path\*** --- The path to resolve.
+
+  **See Also**
+    :ref:`basename`, :ref:`dirname`, :ref:`joinpath`, :ref:`readlink`
+
+----
+
+
+.. _regexp:
+
+regexp(*re*, *str*)
+^^^^^^^^^^^^^^^^^^^
+
+  Test if a string matches a regular expression
+
+  **Parameters**
+    * **re\*** --- The regular expression to use
+    * **str\*** --- The string to test against the regular expression
+
+
+----
+
+
+.. _regexp_capture:
+
+regexp_capture(*string*, *pattern*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  A table-valued function that executes a regular-expression over a string and returns the captured values.  If the regex only matches a subset of the input string, it will be rerun on the remaining parts of the string until no more matches are found.
+
+  **Parameters**
+    * **string\*** --- The string to match against the given pattern.
+    * **pattern\*** --- The regular expression to match.
+
+  **Examples**
+    To extract the key/value pairs 'a'/1 and 'b'/2 from the string 'a=1; b=2':
+
+    .. code-block::  custsqlite
+
+      ;SELECT * FROM regexp_capture('a=1; b=2', '(\w+)=(\d+)')
+      match_index capture_index capture_name capture_count range_start range_stop content 
+                0             0       <NULL>             3           1          4 a=1     
+                0             1       <NULL>             3           1          2 a       
+                0             2       <NULL>             3           3          4 1       
+                1             0       <NULL>             3           6          9 b=2     
+                1             1       <NULL>             3           6          7 b       
+                1             2       <NULL>             3           8          9 2       
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _regexp_capture_into_json:
+
+regexp_capture_into_json(*string*, *pattern*, *\[options\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  A table-valued function that executes a regular-expression over a string and returns the captured values as a JSON object.  If the regex only matches a subset of the input string, it will be rerun on the remaining parts of the string until no more matches are found.
+
+  **Parameters**
+    * **string\*** --- The string to match against the given pattern.
+    * **pattern\*** --- The regular expression to match.
+    * **options** --- A JSON object with the following option: convert-numbers - True (default) if text that looks like numeric data should be converted to JSON numbers, false if they should be captured as strings.
+
+  **Examples**
+    To extract the key/value pairs 'a'/1 and 'b'/2 from the string 'a=1; b=2':
+
+    .. code-block::  custsqlite
+
+      ;SELECT * FROM regexp_capture_into_json('a=1; b=2', '(\w+)=(\d+)')
+      match_index         content         
+                0 {"col_0":"a","col_1":1} 
+                1 {"col_0":"b","col_1":2} 
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _regexp_match:
+
+regexp_match(*re*, *str*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Match a string against a regular expression and return the capture groups as JSON.
+
+  **Parameters**
+    * **re\*** --- The regular expression to use
+    * **str\*** --- The string to test against the regular expression
+
+  **Examples**
+    To capture the digits from the string '123':
+
+    .. code-block::  custsqlite
+
+      ;SELECT regexp_match('(\d+)', '123')
+      123
+
+    To capture a number and word into a JSON object with the properties 'col_0' and 'col_1':
+
+    .. code-block::  custsqlite
+
+      ;SELECT regexp_match('(\d+) (\w+)', '123 four')
+      {"col_0":123,"col_1":"four"}
+
+    To capture a number and word into a JSON object with the named properties 'num' and 'str':
+
+    .. code-block::  custsqlite
+
+      ;SELECT regexp_match('(?<num>\d+) (?<str>\w+)', '123 four')
+      {"num":123,"str":"four"}
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_replace`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _regexp_replace:
+
+regexp_replace(*str*, *re*, *repl*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Replace the parts of a string that match a regular expression.
+
+  **Parameters**
+    * **str\*** --- The string to perform replacements on
+    * **re\*** --- The regular expression to match
+    * **repl\*** --- The replacement string.  You can reference capture groups with a backslash followed by the number of the group, starting with 1.
+
+  **Examples**
+    To replace the word at the start of the string 'Hello, World!' with 'Goodbye':
+
+    .. code-block::  custsqlite
+
+      ;SELECT regexp_replace('Hello, World!', '^(\w+)', 'Goodbye')
+      Goodbye, World!
+
+    To wrap alphanumeric words with angle brackets:
+
+    .. code-block::  custsqlite
+
+      ;SELECT regexp_replace('123 abc', '(\w+)', '<\1>')
+      <123> <abc>
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_match`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _replace:
+
+replace(*str*, *old*, *replacement*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a string formed by substituting the replacement string for every occurrence of the old string in the given string.
+
+  **Parameters**
+    * **str\*** --- The string to perform substitutions on.
+    * **old\*** --- The string to be replaced.
+    * **replacement\*** --- The string to replace any occurrences of the old string with.
+
+  **Examples**
+    To replace the string 'x' with 'z' in 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT replace('abc', 'x', 'z')
+      abc
+
+    To replace the string 'a' with 'z' in 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT replace('abc', 'a', 'z')
+      zbc
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _replicate:
+
+replicate(*str*, *N*)
+^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the given string concatenated N times.
+
+  **Parameters**
+    * **str\*** --- The string to replicate.
+    * **N\*** --- The number of times to replicate the string.
+
+  **Examples**
+    To repeat the string 'abc' three times:
+
+    .. code-block::  custsqlite
+
+      ;SELECT replicate('abc', 3)
+      abcabcabc
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _reverse:
+
+reverse(*str*)
+^^^^^^^^^^^^^^
+
+  Returns the reverse of the given string.
+
+  **Parameters**
+    * **str\*** --- The string to reverse.
+
+  **Examples**
+    To reverse the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT reverse('abc')
+      cba
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _rightstr:
+
+rightstr(*str*, *N*)
+^^^^^^^^^^^^^^^^^^^^
+
+  Returns the N rightmost (UTF-8) characters in the given string.
+
+  **Parameters**
+    * **str\*** --- The string to return subset.
+    * **N\*** --- The number of characters from the right side of the string to return.
+
+  **Examples**
+    To get the last character of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT rightstr('abc', 1)
+      c
+
+    To get the last ten characters of a string, regardless of size:
+
+    .. code-block::  custsqlite
+
+      ;SELECT rightstr('abc', 10)
+      abc
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _round:
+
+round(*num*, *\[digits\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a floating-point value rounded to the given number of digits to the right of the decimal point.
+
+  **Parameters**
+    * **num\*** --- The value to round.
+    * **digits** --- The number of digits to the right of the decimal to round to.
+
+  **Examples**
+    To round the number 123.456 to an integer:
+
+    .. code-block::  custsqlite
+
+      ;SELECT round(123.456)
+      123
+
+    To round the number 123.456 to a precision of 1:
+
+    .. code-block::  custsqlite
+
+      ;SELECT round(123.456, 1)
+      123.5
+
+    To round the number 123.456 to a precision of 5:
+
+    .. code-block::  custsqlite
+
+      ;SELECT round(123.456, 5)
+      123.456
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`sign`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _row_number:
+
+row_number()
+^^^^^^^^^^^^
+
+  Returns the number of the row within the current partition, starting from 1.
+
+  **Examples**
+    To number messages from a process:
+
+    .. code-block::  custsqlite
+
+      ;SELECT row_number() OVER (PARTITION BY ex_procname ORDER BY log_line) AS msg_num, ex_procname, log_body FROM lnav_example_log
+      msg_num ex_procname    log_body     
+            1 gw          Goodbye, World! 
+            2 gw          Goodbye, World! 
+            3 gw          Goodbye, World! 
+            1 hw          Hello, World!   
+
+  **See Also**
+    :ref:`cume_dist`, :ref:`dense_rank`, :ref:`first_value`, :ref:`lag`, :ref:`last_value`, :ref:`lead`, :ref:`nth_value`, :ref:`ntile`, :ref:`percent_rank`, :ref:`rank`
+
+----
+
+
+.. _rtrim:
+
+rtrim(*str*, *\[chars\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a string formed by removing any and all characters that appear in the second argument from the right side of the first.
+
+  **Parameters**
+    * **str\*** --- The string to trim characters from the right side
+    * **chars** --- The characters to trim.  Defaults to spaces.
+
+  **Examples**
+    To trim the space characters from the end of the string 'abc   ':
+
+    .. code-block::  custsqlite
+
+      ;SELECT rtrim('abc   ')
+      abc
+
+    To trim the characters 'b' and 'c' from the string 'abbbbcccc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT rtrim('abbbbcccc', 'bc')
+      a
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _sign:
+
+sign(*num*)
+^^^^^^^^^^^
+
+  Returns the sign of the given number as -1, 0, or 1
+
+  **Parameters**
+    * **num\*** --- The number
+
+  **Examples**
+    To get the sign of 10:
+
+    .. code-block::  custsqlite
+
+      ;SELECT sign(10)
+      1
+
+    To get the sign of 0:
+
+    .. code-block::  custsqlite
+
+      ;SELECT sign(0)
+      0
+
+    To get the sign of -10:
+
+    .. code-block::  custsqlite
+
+      ;SELECT sign(-10)
+      -1
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`square`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _sparkline:
+
+sparkline(*value*, *\[upper\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Function used to generate a sparkline bar chart.  The non-aggregate version converts a single numeric value on a range to a bar chart character.  The aggregate version returns a string with a bar character for every numeric input
+
+  **Parameters**
+    * **value\*** --- The numeric value to convert
+    * **upper** --- The upper bound of the numeric range.  The non-aggregate version defaults to 100.  The aggregate version uses the largest value in the inputs.
+
+  **Examples**
+    To get the unicode block element for the value 32 in the range of 0-128:
+
+    .. code-block::  custsqlite
+
+      ;SELECT sparkline(32, 128)
+      ▂
+
+    To chart the values in a JSON array:
+
+    .. code-block::  custsqlite
+
+      ;SELECT sparkline(value) FROM json_each('[0, 1, 2, 3, 4, 5, 6, 7, 8]')
+       ▁▂▃▄▅▆▇█
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _spooky_hash:
+
+spooky_hash(*str*)
+^^^^^^^^^^^^^^^^^^
+
+  Compute the hash value for the given arguments.
+
+  **Parameters**
+    * **str** --- The string to hash
+
+  **Examples**
+    To produce a hash for the string 'Hello, World!':
+
+    .. code-block::  custsqlite
+
+      ;SELECT spooky_hash('Hello, World!')
+      0b1d52cc5427db4c6a9eed9d3e5700f4
+
+    To produce a hash for the parameters where one is NULL:
+
+    .. code-block::  custsqlite
+
+      ;SELECT spooky_hash('Hello, World!', NULL)
+      c96ee75d48e6ea444fee8af948f6da25
+
+    To produce a hash for the parameters where one is an empty string:
+
+    .. code-block::  custsqlite
+
+      ;SELECT spooky_hash('Hello, World!', '')
+      c96ee75d48e6ea444fee8af948f6da25
+
+    To produce a hash for the parameters where one is a number:
+
+    .. code-block::  custsqlite
+
+      ;SELECT spooky_hash('Hello, World!', 123)
+      f96b3d9c1a19f4394c97a1b79b1880df
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _sqlite_compileoption_get:
+
+sqlite_compileoption_get(*N*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the N-th compile-time option used to build SQLite or NULL if N is out of range.
+
+  **Parameters**
+    * **N\*** --- The option number to get
+
+
+----
+
+
+.. _sqlite_compileoption_used:
+
+sqlite_compileoption_used(*option*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns true (1) or false (0) depending on whether or not that compile-time option was used during the build.
+
+  **Parameters**
+    * **option\*** --- The name of the compile-time option.
+
+  **Examples**
+    To check if the SQLite library was compiled with ENABLE_FTS3:
+
+    .. code-block::  custsqlite
+
+      ;SELECT sqlite_compileoption_used('ENABLE_FTS3')
+      1
+
+
+----
+
+
+.. _sqlite_source_id:
+
+sqlite_source_id()
+^^^^^^^^^^^^^^^^^^
+
+  Returns a string that identifies the specific version of the source code that was used to build the SQLite library.
+
+
+----
+
+
+.. _sqlite_version:
+
+sqlite_version()
+^^^^^^^^^^^^^^^^
+
+  Returns the version string for the SQLite library that is running.
+
+
+----
+
+
+.. _square:
+
+square(*num*)
+^^^^^^^^^^^^^
+
+  Returns the square of the argument
+
+  **Parameters**
+    * **num\*** --- The number to square
+
+  **Examples**
+    To get the square of two:
+
+    .. code-block::  custsqlite
+
+      ;SELECT square(2)
+      4
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`sum`, :ref:`total`
+
+----
+
+
+.. _startswith:
+
+startswith(*str*, *prefix*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Test if a string begins with the given prefix
+
+  **Parameters**
+    * **str\*** --- The string to test
+    * **prefix\*** --- The prefix to check in the string
+
+  **Examples**
+    To test if the string 'foobar' starts with 'foo':
+
+    .. code-block::  custsqlite
+
+      ;SELECT startswith('foobar', 'foo')
+      1
+
+    To test if the string 'foobar' starts with 'bar':
+
+    .. code-block::  custsqlite
+
+      ;SELECT startswith('foobar', 'bar')
+      0
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _strfilter:
+
+strfilter(*source*, *include*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the source string with only the characters given in the second parameter
+
+  **Parameters**
+    * **source\*** --- The string to filter
+    * **include\*** --- The characters to include in the result
+
+  **Examples**
+    To get the 'b', 'c', and 'd' characters from the string 'abcabc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT strfilter('abcabc', 'bcd')
+      bcbc
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _strftime:
+
+strftime(*format*, *timestring*, *modifier*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the date formatted according to the format string specified as the first argument.
+
+  **Parameters**
+    * **format\*** --- A format string with substitutions similar to those found in the strftime() standard C library.
+    * **timestring\*** --- The string to convert to a date with time.
+    * **modifier** --- A transformation that is applied to the value to the left.
+
+  **Examples**
+    To get the year from the timestamp '2017-01-02T03:04:05':
+
+    .. code-block::  custsqlite
+
+      ;SELECT strftime('%Y', '2017-01-02T03:04:05')
+      2017
+
+    To create a string with the time from the timestamp '2017-01-02T03:04:05' plus one minute:
+
+    .. code-block::  custsqlite
+
+      ;SELECT strftime('The time is: %H:%M:%S', '2017-01-02T03:04:05', '+1 minute')
+      The time is: 03:05:05
+
+    To create a string with the Julian day from the epoch timestamp 1491341842:
+
+    .. code-block::  custsqlite
+
+      ;SELECT strftime('Julian day: %J', 1491341842, 'unixepoch')
+      Julian day: 2457848.400949074
+
+  **See Also**
+    :ref:`date`, :ref:`datetime`, :ref:`humanize_duration`, :ref:`julianday`, :ref:`time`, :ref:`timediff`, :ref:`timeslice`
+
+----
+
+
+.. _substr:
+
+substr(*str*, *start*, *\[size\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a substring of input string X that begins with the Y-th character and which is Z characters long.
+
+  **Parameters**
+    * **str\*** --- The string to extract a substring from.
+    * **start\*** --- The index within 'str' that is the start of the substring.  Indexes begin at 1.  A negative value means that the substring is found by counting from the right rather than the left.  
+    * **size** --- The size of the substring.  If not given, then all characters through the end of the string are returned.  If the value is negative, then the characters before the start are returned.
+
+  **Examples**
+    To get the substring starting at the second character until the end of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT substr('abc', 2)
+      bc
+
+    To get the substring of size one starting at the second character of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT substr('abc', 2, 1)
+      b
+
+    To get the substring starting at the last character until the end of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT substr('abc', -1)
+      c
+
+    To get the substring starting at the last character and going backwards one step of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT substr('abc', -1, -1)
+      b
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _sum:
+
+sum(*X*)
+^^^^^^^^
+
+  Returns the sum of the values in the group as an integer.
+
+  **Parameters**
+    * **X\*** --- The values to add.
+
+  **Examples**
+    To sum all of the values in the column 'ex_duration' from the table 'lnav_example_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT sum(ex_duration) FROM lnav_example_log
+      17
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`total`
+
+----
+
+
+.. _time:
+
+time(*timestring*, *modifier*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns the time in this format: HH:MM:SS.
+
+  **Parameters**
+    * **timestring\*** --- The string to convert to a time.
+    * **modifier** --- A transformation that is applied to the value to the left.
+
+  **Examples**
+    To get the time portion of the timestamp '2017-01-02T03:04:05':
+
+    .. code-block::  custsqlite
+
+      ;SELECT time('2017-01-02T03:04:05')
+      03:04:05
+
+    To get the time portion of the timestamp '2017-01-02T03:04:05' plus one minute:
+
+    .. code-block::  custsqlite
+
+      ;SELECT time('2017-01-02T03:04:05', '+1 minute')
+      03:05:05
+
+    To get the time portion of the epoch timestamp 1491341842:
+
+    .. code-block::  custsqlite
+
+      ;SELECT time(1491341842, 'unixepoch')
+      21:37:22
+
+  **See Also**
+    :ref:`date`, :ref:`datetime`, :ref:`humanize_duration`, :ref:`julianday`, :ref:`strftime`, :ref:`timediff`, :ref:`timeslice`
+
+----
+
+
+.. _timediff:
+
+timediff(*time1*, *time2*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Compute the difference between two timestamps in seconds
+
+  **Parameters**
+    * **time1\*** --- The first timestamp
+    * **time2\*** --- The timestamp to subtract from the first
+
+  **Examples**
+    To get the difference between two timestamps:
+
+    .. code-block::  custsqlite
+
+      ;SELECT timediff('2017-02-03T04:05:06', '2017-02-03T04:05:00')
+      6
+
+    To get the difference between relative timestamps:
+
+    .. code-block::  custsqlite
+
+      ;SELECT timediff('today', 'yesterday')
+      86400
+
+  **See Also**
+    :ref:`date`, :ref:`datetime`, :ref:`humanize_duration`, :ref:`julianday`, :ref:`strftime`, :ref:`time`, :ref:`timeslice`
+
+----
+
+
+.. _timeslice:
+
+timeslice(*time*, *slice*)
+^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Return the start of the slice of time that the given timestamp falls in.  If the time falls outside of the slice, NULL is returned.
+
+  **Parameters**
+    * **time\*** --- The timestamp to get the time slice for.
+    * **slice\*** --- The size of the time slices
+
+  **Examples**
+    To get the timestamp rounded down to the start of the ten minute slice:
+
+    .. code-block::  custsqlite
+
+      ;SELECT timeslice('2017-01-01T05:05:00', '10m')
+      2017-01-01 05:00:00.000
+
+    To group log messages into five minute buckets and count them:
+
+    .. code-block::  custsqlite
+
+      ;SELECT timeslice(log_time_msecs, '5m') AS slice, count(1)
+    FROM lnav_example_log GROUP BY slice
+               slice          count(1) 
+      2017-02-03 04:05:00.000        2 
+      2017-02-03 04:25:00.000        1 
+      2017-02-03 04:55:00.000        1 
+
+    To group log messages by those before 4:30am and after:
+
+    .. code-block::  custsqlite
+
+      ;SELECT timeslice(log_time_msecs, 'before 4:30am') AS slice, count(1) FROM lnav_example_log GROUP BY slice
+               slice          count(1) 
+      <NULL>                         1 
+      2017-02-03 00:00:00.000        3 
+
+  **See Also**
+    :ref:`date`, :ref:`datetime`, :ref:`humanize_duration`, :ref:`julianday`, :ref:`strftime`, :ref:`time`, :ref:`timediff`
+
+----
+
+
+.. _total:
+
+total(*X*)
+^^^^^^^^^^
+
+  Returns the sum of the values in the group as a floating-point.
+
+  **Parameters**
+    * **X\*** --- The values to add.
+
+  **Examples**
+    To total all of the values in the column 'ex_duration' from the table 'lnav_example_log':
+
+    .. code-block::  custsqlite
+
+      ;SELECT total(ex_duration) FROM lnav_example_log
+      17
+
+  **See Also**
+    :ref:`abs`, :ref:`acos`, :ref:`acosh`, :ref:`asin`, :ref:`asinh`, :ref:`atan2`, :ref:`atan`, :ref:`atanh`, :ref:`atn2`, :ref:`avg`, :ref:`ceil`, :ref:`degrees`, :ref:`exp`, :ref:`floor`, :ref:`log10`, :ref:`log`, :ref:`max`, :ref:`min`, :ref:`pi`, :ref:`power`, :ref:`radians`, :ref:`round`, :ref:`sign`, :ref:`square`, :ref:`sum`
+
+----
+
+
+.. _total_changes:
+
+total_changes()
+^^^^^^^^^^^^^^^
+
+  Returns the number of row changes caused by INSERT, UPDATE or DELETE statements since the current database connection was opened.
+
+
+----
+
+
+.. _trim:
+
+trim(*str*, *\[chars\]*)
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  Returns a string formed by removing any and all characters that appear in the second argument from the left and right sides of the first.
+
+  **Parameters**
+    * **str\*** --- The string to trim characters from the left and right sides.
+    * **chars** --- The characters to trim.  Defaults to spaces.
+
+  **Examples**
+    To trim spaces from the start and end of the string '    abc   ':
+
+    .. code-block::  custsqlite
+
+      ;SELECT trim('    abc   ')
+      abc
+
+    To trim the characters '-' and '+' from the string '-+abc+-':
+
+    .. code-block::  custsqlite
+
+      ;SELECT trim('-+abc+-', '-+')
+      abc
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _typeof:
+
+typeof(*X*)
+^^^^^^^^^^^
+
+  Returns a string that indicates the datatype of the expression X: "null", "integer", "real", "text", or "blob".
+
+  **Parameters**
+    * **X\*** --- The expression to check.
+
+  **Examples**
+    To get the type of the number 1:
+
+    .. code-block::  custsqlite
+
+      ;SELECT typeof(1)
+      integer
+
+    To get the type of the string 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT typeof('abc')
+      text
+
+
+----
+
+
+.. _unicode:
+
+unicode(*X*)
+^^^^^^^^^^^^
+
+  Returns the numeric unicode code point corresponding to the first character of the string X.
+
+  **Parameters**
+    * **X\*** --- The string to examine.
+
+  **Examples**
+    To get the unicode code point for the first character of 'abc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT unicode('abc')
+      97
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unparse_url`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _unlikely:
+
+unlikely(*value*)
+^^^^^^^^^^^^^^^^^
+
+  Short-hand for likelihood(X, 0.0625)
+
+  **Parameters**
+    * **value\*** --- The boolean value to return
+
+
+----
+
+
+.. _unparse_url:
+
+unparse_url(*obj*)
+^^^^^^^^^^^^^^^^^^
+
+  Convert a JSON object containing the parts of a URL into a URL string
+
+  **Parameters**
+    * **obj\*** --- The JSON object containing the URL parts
+
+  **Examples**
+    To unparse the object '{"scheme": "https", "host": "example.com"}':
+
+    .. code-block::  custsqlite
+
+      ;SELECT unparse_url('{"scheme": "https", "host": "example.com"}')
+      https://example.com/
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`upper`, :ref:`xpath`
+
+----
+
+
+.. _upper:
+
+upper(*str*)
+^^^^^^^^^^^^
+
+  Returns a copy of the given string with all ASCII characters converted to upper case.
+
+  **Parameters**
+    * **str\*** --- The string to convert.
+
+  **Examples**
+    To uppercase the string 'aBc':
+
+    .. code-block::  custsqlite
+
+      ;SELECT upper('aBc')
+      ABC
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`xpath`
+
+----
+
+
+.. _xpath:
+
+xpath(*xpath*, *xmldoc*)
+^^^^^^^^^^^^^^^^^^^^^^^^
+
+  A table-valued function that executes an xpath expression over an XML string and returns the selected values.
+
+  **Parameters**
+    * **xpath\*** --- The XPATH expression to evaluate over the XML document.
+    * **xmldoc\*** --- The XML document as a string.
+
+  **Examples**
+    To select the XML nodes on the path '/abc/def':
+
+    .. code-block::  custsqlite
+
+      ;SELECT * FROM xpath('/abc/def', '<abc><def a="b">Hello</def><def>Bye</def></abc>')
+              result           node_path  node_attr node_text 
+      <def a="b">Hello</def>␊ /abc/def[1] {"a":"b"} Hello     
+      <def>Bye</def>␊         /abc/def[2] {}        Bye       
+
+    To select all 'a' attributes on the path '/abc/def':
+
+    .. code-block::  custsqlite
+
+      ;SELECT * FROM xpath('/abc/def/@a', '<abc><def a="b">Hello</def><def>Bye</def></abc>')
+      result   node_path    node_attr node_text 
+      b      /abc/def[1]/@a {"a":"b"} Hello     
+
+    To select the text nodes on the path '/abc/def':
+
+    .. code-block::  custsqlite
+
+      ;SELECT * FROM xpath('/abc/def/text()', '<abc><def a="b">Hello &#x2605;</def></abc>')
+      result     node_path    node_attr node_text 
+      Hello ★ /abc/def/text() {}        Hello ★   
+
+  **See Also**
+    :ref:`anonymize`, :ref:`char`, :ref:`charindex`, :ref:`decode`, :ref:`encode`, :ref:`endswith`, :ref:`extract`, :ref:`group_concat`, :ref:`group_spooky_hash_agg`, :ref:`gunzip`, :ref:`gzip`, :ref:`humanize_duration`, :ref:`humanize_file_size`, :ref:`instr`, :ref:`leftstr`, :ref:`length`, :ref:`logfmt2json`, :ref:`lower`, :ref:`ltrim`, :ref:`padc`, :ref:`padl`, :ref:`padr`, :ref:`parse_url`, :ref:`printf`, :ref:`proper`, :ref:`regexp_capture_into_json`, :ref:`regexp_capture`, :ref:`regexp_match`, :ref:`regexp_replace`, :ref:`replace`, :ref:`replicate`, :ref:`reverse`, :ref:`rightstr`, :ref:`rtrim`, :ref:`sparkline`, :ref:`spooky_hash`, :ref:`startswith`, :ref:`strfilter`, :ref:`substr`, :ref:`trim`, :ref:`unicode`, :ref:`unparse_url`, :ref:`upper`
+
+----
+
+
+.. _yaml_to_json:
+
+yaml_to_json(*yaml*)
+^^^^^^^^^^^^^^^^^^^^
+
+  Convert a YAML document to a JSON-encoded string
+
+  **Parameters**
+    * **yaml\*** --- The YAML value to convert to JSON.
+
+  **Examples**
+    To convert the document "abc: def":
+
+    .. code-block::  custsqlite
+
+      ;SELECT yaml_to_json('abc: def')
+      {"abc": "def"}
+
+  **See Also**
+    :ref:`jget`, :ref:`json_concat`, :ref:`json_contains`, :ref:`json_group_array`, :ref:`json_group_object`
+
+----
+
+
+.. _zeroblob:
+
+zeroblob(*N*)
+^^^^^^^^^^^^^
+
+  Returns a BLOB consisting of N bytes of 0x00.
+
+  **Parameters**
+    * **N\*** --- The size of the BLOB.
+
+
+----
+