|The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 454 pages
RRP £14.95 ($19.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
18.104.22.168 Basic Regular Expressions
BREs differ from EREs in several respects.
are ordinary characters and there is no equivalent
for their functionality.
The delimiters for bounds are
by themselves ordinary characters.
The parentheses for nested subexpressions are
) by themselves ordinary characters.
^ is an ordinary character except at the beginning of the
RE or the beginning of a parenthesized subexpression,
$ is an ordinary character except at the end of the
RE or the end of a parenthesized subexpression,
* is an ordinary character if it appears at the beginning
of the RE or the beginning of a parenthesized subexpression
(after a possible leading
Finally, single-digit back references are available, and
are synonyms for
respectively; no other escapes are available in BREs.
|ISBN 9781906966041||The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference||See the print edition|