Add three new regexp functions: regexp_matches, regexp_split_to_array,
authorNeil Conway <neilc@samurai.com>
Tue, 20 Mar 2007 05:45:00 +0000 (05:45 +0000)
committerNeil Conway <neilc@samurai.com>
Tue, 20 Mar 2007 05:45:00 +0000 (05:45 +0000)
commit619258e4df1de3e73cfca27c1e454cfb11aa7668
treeff498a26852e2d65e1fd7e4b650368b039124577
parent091c8529bcf6030ccf4d146f053ecce406032d39
Add three new regexp functions: regexp_matches, regexp_split_to_array,
and regexp_split_to_table. These functions provide access to the
capture groups resulting from a POSIX regular expression match,
and provide the ability to split a string on a POSIX regular
expression, respectively. Patch from Jeremy Drake; code review by
Neil Conway, additional comments and suggestions from Tom and
Peter E.

This patch bumps the catversion, adds some regression tests,
and updates the docs.
doc/src/sgml/func.sgml
src/backend/utils/adt/regexp.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/utils/builtins.h
src/test/regress/expected/strings.out
src/test/regress/sql/strings.sql