]> granicus.if.org Git - postgresql/commit
Implement SQL99 OVERLAY(). Allows substitution of a substring in a string.
authorThomas G. Lockhart <lockhart@fourpalms.org>
Tue, 11 Jun 2002 15:44:38 +0000 (15:44 +0000)
committerThomas G. Lockhart <lockhart@fourpalms.org>
Tue, 11 Jun 2002 15:44:38 +0000 (15:44 +0000)
commitea01a451ccec55cada68cb45a54519a750fd3d60
treee6f38191dbf7383eaf35f41009b37a13b2ce1fe7
parent090dd22de67e6a7e50cfc3efb92a8472fa8750ba
Implement SQL99 OVERLAY(). Allows substitution of a substring in a string.
Implement SQL99 SIMILAR TO as a synonym for our existing operator "~".
Implement SQL99 regular expression SUBSTRING(string FROM pat FOR escape).
 Extend the definition to make the FOR clause optional.
 Define textregexsubstr() to actually implement this feature.
Update the regression test to include these new string features.
 All tests pass.
Rename the regular expression support routines from "pg95_xxx" to "pg_xxx".
Define CREATE CHARACTER SET in the parser per SQL99. No implementation yet.
16 files changed:
doc/src/sgml/ref/set.sgml
src/backend/parser/gram.y
src/backend/parser/keywords.c
src/backend/parser/scan.l
src/backend/regex/regcomp.c
src/backend/regex/regerror.c
src/backend/regex/regexec.c
src/backend/regex/regfree.c
src/backend/regex/retest.c
src/backend/utils/adt/regexp.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/regex/regex.h
src/include/utils/builtins.h
src/test/regress/expected/strings.out
src/test/regress/sql/strings.sql