regexp

Documentation

Overview

Package regexp provides additional regular expression functions.

It provides the following Unicode aware functions:

• regexp_like(text, pattern),
• regexp_count(text, pattern [, start]),
• regexp_instr(text, pattern [, start [, N [, endoption [, subexpr ]]]]),
• regexp_substr(text, pattern [, start [, N [, subexpr ]]]),
• regexp_replace(text, pattern, replacement [, start [, N ]]),
• and a REGEXP operator.

The implementation uses Go regexp/syntax for regular expressions.

https://github.com/nalgeon/sqlean/blob/main/docs/regexp.md

Index

• func GlobPrefix(re *regexp.Regexp) string
• func Register(db *sqlite3.Conn) error

Functions

func GlobPrefix

func GlobPrefix(re *regexp.Regexp) string

GlobPrefix returns a GLOB for a regular expression appropriate to take advantage of the LIKE optimization in a query such as:

SELECT column WHERE column GLOB :glob_prefix AND column REGEXP :regexp

func Register

func Register(db *sqlite3.Conn) error

Register registers Unicode aware functions for a database connection.