| The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group Paperback (6"x9"), 454 pages ISBN 9781906966041 RRP £14.95 ($19.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
7.7.3.7 Basic Regular Expressions
BREs differ from EREs in several respects.
In BREs, |, +, and ?
are ordinary characters and there is no equivalent
for their functionality.
The delimiters for bounds are
\{ and \},
with { and }
by themselves ordinary characters.
The parentheses for nested subexpressions are
\( and \),
with ( and ) 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,
and * 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
\< and \>
are synonyms for
[[:<:]] and [[:>:]]
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 |