Bring SIMILAR TO and SUBSTRING into some semblance of conformance with
Tom Lane <tgl@sss.pgh.pa.us>
Bring SIMILAR TO and SUBSTRING into some semblance of conformance with the SQL99 standard. (I'm not sure that the character-class features are quite right, but that can be fixed later.) Document SQL99 and POSIX regexps as being different features; provide variants of SUBSTRING for each.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +547 −389 |
| src/backend/parser/gram.y | modified | +23 −5 |
| src/backend/utils/adt/regexp.c | modified | +118 −9 |
| src/include/catalog/pg_proc.h | modified | +9 −6 |
| src/include/utils/builtins.h | modified | +2 −1 |
| src/test/regress/expected/strings.out | modified | +13 −5 |
| src/test/regress/sql/strings.sql | modified | +10 −5 |